MySQL table field name contains minus signs _ MySQL
Last Update:2018-04-16
Source: Internet
Author: User
MySQL table field name contains minus signs (bitsCN.com)
The problem that the MySQL table field name contains a minus sign
When inserting data into MySQL data, the SQL syntax error is always prompted. after half a day of check, it turns out that the table name contains a minus sign. Original TABLE structure: SQL code CREATE TABLE IF NOT EXISTS 'Amazon-sellertransactions' ('record-insert-time' timestamp NOT NULL DEFAULT CURRENT-TIMESTAMP ON UPDATE CURRENT-TIMESTAMP, 'record-id' int (10) unsigned not null auto-INCREMENT, 'Amazon-order-id' varchar (30) default null, 'Merchant-id' varchar (30) default null, 'purchase-date' datetime default null, 'last-update-date' datetime default null, 'order-status' varchar (50) default null, 'fulfillment-channel' varchar (20) default null, 'sales-channel' varchar (50) default null, 'Shipments-service-level' varchar (50) default null, 'order-total' varchar (30) default null, 'buyer-name' varchar (50) default null, 'buyer-email 'varchar (60) default null, 'number-items-shipped 'varchar (10) default null, 'number-items-unshipped' varchar (10) default null, 'ship-city' varchar (50) default null, 'ship-state' varchar (50) default null, 'ship-postal-code' varchar (50) default null, 'ship-country 'varchar (50) default null, 'ship-name' varchar (50) default null, 'ship-phone' varchar (30) default null, 'ship-address-line1 'varchar (120) default null, 'payment-method' varchar (30) default null, primary key ('record '), unique key 'Amazon-order-ID' ('Amazon-order-id ')) ENGINE = MyISAM default charset = utf8 AUTO_INCREMENT = 1; this SQL code creates a table. However, a syntax error is reported in related operations, and quotation marks cannot be added. therefore, only TABLE field names can be modified. the modified SQL code is as follows: SQL code CREATE TABLE IF NOT EXISTS 'Amazon _ sellertransactions' ('record _ insert_time' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 'record _ id' int (10) unsigned not null AUTO_INCREMENT, 'Amazon _ order_id 'varchar (30) default null, 'Merchant _ id' varchar (30) default null, 'purchase _ date' datetime default null, 'Last _ update_date 'datetime default null, 'Order _ status' varchar (50) default null, 'fulfillment _ channel' varchar (20) default null, 'sales _ channel' varchar (50) default null, 'Shipments _ service_level 'varchar (50) default null, 'Order _ total' varchar (30) default null, 'bucket _ name' varchar (50) default null, 'bucket _ email 'varchar (60) default null, 'number _ items_shipped' varchar (10) default null, 'number _ items_unshipped 'varchar (10) default null, 'ship _ City' varchar (50) default null, 'ship _ state' varchar (50) default null, 'ship _ postal_code 'varchar (50) default null, 'ship _ country' varchar (50) default null, 'ship _ name' varchar (50) default null, 'ship _ phone' varchar (30) default null, 'ship _ address_line1 'varchar (120) default null, 'payment _ method' varchar (30) default null, primary key ('record '), unique key 'Amazon _ order_id' ('Amazon _ order_id ') ENGINE = MyISAM default charset = utf8 AUTO_INCREMENT = 1; bitsCN.com