怎么查看mysql各个表的状态_MySQL 查看表状态

最新推荐文章于 2024-07-16 21:32:20 发布

weixin_39870132

最新推荐文章于 2024-07-16 21:32:20 发布

阅读量991

点赞数 1

文章标签：怎么查看mysql各个表的状态

本文链接：https://blog.csdn.net/weixin_39870132/article/details/113282798

版权

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