Mysql 语句
mysql 基础语法
登录 mysql -u root -p
备份 mysqldump -uroot -p [数据库名].[表名] > [文件名].sql
还原 source **.sql
显示库 show database
切换库 use databaseName
显示表 show tables
增 insert into table_name (field1,field2.....)values (value1,value2......)
删 delete from table_name where .....
改 update table_name set field1=value1,field2=value2.....
查 select * from table_name where .....
mysql 进阶
distinct 去除重复部分
group by
order by desc/asc
limit 限制
join 连接
union
子查询
例:SELECT * FROM article AS t WHERE 2 = (SELECT COUNT(*) FROM article WHERE article.uid = t.uid)
连接查询:
别名:
SELECT * FROM 表名 [AS] 别名