Rumah >pembangunan bahagian belakang >tutorial php >mysql插入记录报错,请问是什么原因
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '08022394106','PM000064' ,'0187-25', 'HDMI - micro HDMI (2.5M) ', '1', '福田 ' at line 1
请问这是什么原因报错的啊,我是导入一个txt文件,就这一记录报错。
得看完整的sql语句。
INSERT INTO `amazon_erp`.`$order_status` (`number` ,`order_id` ,`order_item_id`,`shipments` ,`payments_date` ,`buyer_email` ,`buyer_name` ,`buyer_phone_number` ,`sku`,`jj_sku` ,`product_name` ,`quantity_purchased`,`recipient_name`,`ship_address_1`,`ship_address_2`,`ship_address_3`,`ship_state`,`ship_postal_code`,`ship_country`,`account`,`ship_city`,`cancel_order`,`delivery_areas`,`tracking_number`,`carrier_name`,`package_area`,`matter`,`upload_date`,`delivery_date`)VALUES ('$maxnum','$or_id','$or_it_id', '$shipments', '$payments_date','$buyer_email', '$buyer_name','$buyer_phone','$sku' ,'$jj_sku', '$product_name', '$quantity', '$recipient_name', '$ship_address1', '$ship_address2','$ship_address3','$ship_state' , '$ship_postal', '$ship_country', '$zhanghao', '$ship_city','$cancel_order','$delivery_areas','$tracking_number','$carrier_name','$package_area','$matter',now(),'')
$sql_sale=" INSERT INTO `amazonnew`.`1_sale_orders` "; $sql_sale.="(`number` ,`order_id` ,`order_item_id`,`shipments` ,"; $sql_sale.=" `payments_date` ,`buyer_email` ,`buyer_name` ,`buyer_phone_number` ,"; $sql_sale.="`sku`,`item_code`,`product_name`,`quantity_purchased`,`recipient_name`,"; $sql_sale.="`ship_address_1`,`ship_address_2`,`ship_address_3`,`ship_state`,"; $sql_sale.="`ship_postal_code`,`ship_country`,`account`,`ship_city`,"; $sql_sale.="`delivery_areas`,`package_area`,`upload_date`)"; $sql_sale.=" VALUES "; $sql_sale.="('$maxnum','$order_id','$or_it_id', '$shipments',"; $sql_sale.=" '$payments_date','$buyer_email', '$buyer_name','$buyer_phone',"; $sql_sale.="'$sku' ,'$item_code', '$product_name', '$quantity',"; $sql_sale.=" '$recipient_name', '$ship_address1', '$ship_address2','$ship_address3',"; $sql_sale.="'$ship_state' , '$ship_postal', '$ship_country', '$zhanghao',"; $sql_sale.=" '$ship_city','$delivery_areas','$package_area',now())";