mysql插入记录报错,请问是什么原因
Jun 23, 2016 pm 02:24 PM 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())";
要插入的内容
249-0810342-5892861 65494678305574 2013-10-13T13:12:31+00:00 2013-10-13T13:12:31+00:00 2013-10-13T13:43:13+00:00 2013-10-16T14:59:59+00:00 -3 9lvzk1663h5yxvc@marketplace.amazon.co.jp 福田 圭 08022394106 PM000064 XPERIA arc / acro / acroHD ?? HDMI (Aタイプ) To micro HDMI (Dタイプ) ハイスピ?ドイ?サ?ネットケ?ブル 2.5m Ver 1.4 1 0 1 Standard 福田 圭 石垣市真?里 261-4 KAIシ?ブリ?ズ2-C ??? 907-0002 JP
就是那个“福田 圭”的原因,我改成123之后就正,报错显示"福田 "后面有两个乱码

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

11 Best PHP URL Shortener Scripts (Free and Premium)

Working with Flash Session Data in Laravel

Simplified HTTP Response Mocking in Laravel Tests

Build a React App With a Laravel Back End: Part 2, React

cURL in PHP: How to Use the PHP cURL Extension in REST APIs

12 Best PHP Chat Scripts on CodeCanyon
