MySQL常用语句


show databases;

use db;

show tables;

desc mytable;

select distinct id,name,score from mytable where score <= 5 or name = "R-15" order by score; (and or in between like limit IS NULL)

insert in to mytable(name,score) values('星际牛仔',9.1);

concat,concat_ws,group_concat,repeat,as;