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
相关推荐
查看MySQL Galera集群状态 pxc状态使用手册
MySQL常用查询状态命令
mysql命令、介绍有phpmyadmin怎样产看、命令行怎样查看
mysql从服务器状态监控脚本,源自官方网
linux下检测mysql进程状态脚本,做Mysql主备模式,可以监测mysql数据库允许状态。
根据status状态对Mysql数据库进行优化: 1、连接数 1.1 show variables like ‘max_connections’; 1.2、 show global status like ‘Max_used_connections’; 1.3、设置最大连接数值方法: mysqld服务器...
MySQL在进行alter table等DDL操作时,有时会出现Waiting for table metadata lock的等待场景。而且,一旦alter table TableA的操作停滞在Waiting for table metadata lock的状态,后续对TableA的任何操作(包括读)...
docker容器mysql数据库无状态主从配置,从节点重启自动增量同步。
C#/WInform+DotNetBar实现MySQL一件安装,监控服务状态,开启,关闭,重启服务
MySQL运行状态show tytutu
│ 6_MySQL复制状态和延迟复制.mp4 │ 7_MySQL半同步复制.mp4 │ 作业.docx │ ├─新版MySQL DBA综合实战班 第10天 │ │ 1_课后作业讲解.mp4 │ │ 2_MySQL传统复制手动切换和GTID复制原理及切换.mp4 │ │ 3_...
5.4. mysql_fix_privilege_tables:升级MySQL系统表 5.5. MySQL服务器关机进程 5.6. 一般安全问题 5.6.1. 通用安全指南 5.6.2. 使MySQL在攻击者面前保持安全 5.6.3. Mysqld安全相关启动选项 5.6.4. LOAD DATA LOCAL...
PHP版MySQL运行状态监视器+MySQL+Monitor+v1php源码.
在MySQL中,我们可以使用SHOW STATUS指令语句来查看MySQL服务器的状态信息。下面,我们以DOS命令窗口的形式连接MySQL,并执行show status;指令,我们将看到如下显示信息: 当我们执行show stat
MySQL运行状态查询与参数说明,这个是DBA维护mysql系统必会的
5.4. mysql_fix_privilege_tables:升级MySQL系统表 5.5. MySQL服务器关机进程 5.6. 一般安全问题 5.6.1. 通用安全指南 5.6.2. 使MySQL在攻击者面前保持安全 5.6.3. Mysqld安全相关启动选项 5.6.4. LOAD DATA ...
对于关键的MySQL状态进行了整理和总结,对于掌握MySQL的运行状况有一定的辅助作用。除此以外你也可以尝试自己写MySQLMonitor的扩展。可以针对若干MySQL服务器进行监控,通过对监控信息的切换,可以找到这些MySQL...
对于关键的MySQL状态进行了整理和总结,对于掌握MySQL的运行状况有一定的辅助作用。除此以外你也可以尝试自己写MySQLMonitor的扩展。可以针对若干MySQL服务器进行监控,通过对监控信息的切换,可以找到这些MySQL...
状态变量指标。系统变量指标。事务的隔离级别质数 Mysql词汇,如何使用MySQL的MySQL客户端程序来创建和使用一个简单的数据库。 备份你的数据库,你可以恢复你的数据,并在问题发生时再运行至关重要,如系统崩溃,...
5.4. mysql_fix_privilege_tables:升级MySQL系统表 5.5. MySQL服务器关机进程 5.6. 一般安全问题 5.6.1. 通用安全指南 5.6.2. 使MySQL在攻击者面前保持安全 5.6.3. Mysqld安全相关启动选项 5.6.4. LOAD DATA LOCAL...