Mysql_命令归类

.连接mysql    mysql -uroot -padmin -hlocalhost

.连接mysqladmin命令行客户端程序 mysqladmin -uroot -padmin -hlocalhost

.启动mysql   mysqld

.关闭  mysqladmin -uroot -padmin -hlocalhost shutdown

.修改密码

set password for 'root'@'localhost' = password('admin')

update mysql.user set password=password('admin') where user=''

flush privileges

delete from mysql.user where user=''

.select version(),current_date,now();

.select user()

.创建数据库库  create database me;使用数据库 use test;显示表 show tables;

.将文本文件装载到表中 LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet lines terminated by '/r/n';

.区分大小写的排序    select songs_name from tb_songs order by binary  songs_name  asc

.使用正则模式匹配  . [ab],[a-b],x*,.*,^,$           select songs_name from tb_songs where songs_name regexp  '^爱'

.当前使用了哪个数据库库  select database()

.所有数据库 show databases;show tables;

.批处理模式下使用mysql  mysql -tvw  -hlocalhost -uroot -padmin < me.sql   [| more ,>mysql.out]

.使用用户变量

select @max_name:=max(songs_name)  from tb_songs;
select * from tb_songs where songs_name=@max_name;

.显示表sql   show create table song

.SELECT year,month,BIT_COUNT(BIT_OR(1<<day)) AS days FROM t1 GROUP BY year,month;