1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
INSERT INTO orders( customers_id, customers_name,
customers_company,
customers_street_address, customers_suburb,
customers_city, customers_postcode, customers_state,
customers_country, customers_telephone,
customers_email_address,
customers_address_format_id,
delivery_name, delivery_company,
delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country,
delivery_address_format_id, billing_name,
billing_company, billing_street_address,
billing_suburb, billing_city, billing_postcode,
billing_state, billing_country,
billing_address_format_id, payment_method,
cc_type, cc_owner, cc_number, cc_expires,
date_purchased, orders_status, currency, currency_value )
VALUES (
'11', 'toto, '', 'rue toto', '', 'totoville', '75000', '',
'France', '01.01.01.01.01', 'toto@wanadoo.fr',
'1', 'toto', '', 'rue toto', '', 'totoville', '75000', '',
'France', '1', 'toto', '', 'rue toto', '', 'toto',
'75000', '', 'France', '1', '', '', '', '', '', now( ) ,
'1', ' ?', ''
) |
Partager