Mysql基础

mysql: 多表 select e.id,e.name,d.name from emp e inner join dept p on e.dept_id=d.id;
select e.id,e.name,d.name from emp e left join dept p on e.dept_id=d.id;
select e.id,e.name,d.name from emp e right join dept p on e.dept_id=d.id;
条数： select count(1) from emp;
分页：
select * from table WHERE … LIMIT 10; #返回前10行
select * from table WHERE … LIMIT 0,10; #返回前10行
select * from table WHERE … LIMIT 10,20; #返回第10-20行数

增：insert into tablename()values();
删: delete * from tablename where id=？
查：select * from tablename where id=？
改：update tablename set name="",age="" where id=?

外键的添加方式:
方式一:
dept_id int references dept(id)
方式二:
constraint FK_dept foreign key(dept_id) references dept(id)
方式三:
在建表之后添加外键约束
alter table emp add foreign key(dept_id) references dept(id)