Mysql_命令归类 91KGE

.连接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;