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;