数据搬运工

MySQL执行LOAD DATA语句时报错ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides解决方案查看是否开启加载本地文件 show variables like 'local_infile';开启全局本地文件设置 set global set local_infile=on;加载数据成功 load data local in

select * from a where v between 1 and 5;相当于 v>=1 且 v<=5

ALTER TABLECOMMITCREATE INDEXCREATE PROCEDURECREATE TABLECREATE USERCREATE VIEWDELETEDROPINSERTINSERT SELECTROLLBACKSAVEPOINTSELETESTART TRANSACTIONUPDATE

报错：[root@hadoop01 percona]# mysqladmin -u root password ‘root’mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'停止mysql的服务...

WHEREHAVING过滤行过滤分组分组前过滤分组后过滤

sql语句的书写顺序:select >> from >> where >> group by >> having >> order by注意：1. select和from是必须的；2. where和having不能同时使用;3. having和group by联合使用；sql语句的解析顺序 :from >> wh...

建立一个城市数据库，共github找的一份sql,然而并不想要多于的字段，于是通过正则表达式截取并删除。由于想了很久，记录一下~正则表达式\,\s\'[0-9]+\'正则表达式解析符号解析\,转译逗号\s空格\’转译引号[0-9]+正整数通过正则表达式查找删除不需要的字段...

新建文本文档,输入以下内容mysql --default-character-set=gbk -uroot -proot将后缀名改为.bat