数据库增删查改、多表联查、基本操作总结
入职三天,还没上手项目,简单地学习了一下数据库的基本操作以及了解业务逻辑。
数据库的增删查改
- *数据的insert语句 :
insert into table values()
insert into table (column1,column2,column3)values() - 数据的select语句
select * from table (where column = )
select column1,column2 from table (where column = ) - .数据的update语句
update table set column = ? where column = ? - 数据的delete语句
delete from table where column = ?
数据的多表联查
- join联查
select a.column 1,a.column2,b.column1,b.column2,c.cloumn1,c.column2 from A a join C c on a.column = c.column join B b on a.column = b.column - merge into 查询
merge into A a using (select a,b,c,d,e,f from B
union
select a,b,c,d,e,f from C
union
sel