MySQL 查看表状态

 

 

1，只能加反引号或者不加

mysql> show create table ad_package\G

否则报错：

ERROR 1064 (42000): 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 ''ad_package'' at line 1
 

2，只能加引号，不能不加

mysql>  show table status like 'ad_package'\G

 

不加报错：

ERROR 1064 (42000): 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 'ad_package' at line 1

 

 

Database changed
mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' INTO TABLE ad_package FIELDS TERMINATED BY ',';
Query OK, 13480 rows affected, 28351 warnings (0.36 sec)
Records: 13480  Deleted: 0  Skipped: 0  Warnings: 28351

mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' INTO TABLE ad_package FIELDS TERMINATED BY ',' enclosed by '"' ;
ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY'
mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',' enclosed by '"' ;
Query OK, 2 rows affected, 20908 warnings (0.09 sec)
Records: 6740  Deleted: 0  Skipped: 6738  Warnings: 20908

mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',';
Query OK, 13479 rows affected, 28349 warnings (0.18 sec)
Records: 13479  Deleted: 0  Skipped: 0  Warnings: 28349

mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',' ORDERS(ad_id,item_url,crc32,package_name,status) ;
ERROR 1064 (42000): 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 'ORDERS(ad_id,item_url,crc32,package_name,status)' at line 1
mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',' ORDERS (ad_id,item_url,crc32,package_name,status) ;
ERROR 1064 (42000): 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 'ORDERS (ad_id,item_url,crc32,package_name,status)' at line 1
mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package ORDERS (ad_id,item_url,crc32,package_name,status) FIELDS TERMINATED BY ',' ;
ERROR 1064 (42000): 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 'ORDERS (ad_id,item_url,crc32,package_name,status) FIELDS TERMINATED BY ','' at line 1
mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',' ;Query OK, 13479 rows affected, 13480 warnings (0.43 sec)
Records: 13479  Deleted: 0  Skipped: 0  Warnings: 13480

mysql> LOAD DATA INFILE '/var/lib/mysql/ad.txt' IGNORE INTO TABLE ad_package FIELDS TERMINATED BY ',' ;
Query OK, 13479 rows affected, 1 warning (0.14 sec)
Records: 13479  Deleted: 0  Skipped: 0  Warnings: 1