SQL statements vs. database 2

Add data

Insert into Wyx (XH,NL,XB,SFZH,ZCRQ) VALUES (0422,28, male, 210623198711111111,2016-8-19);

Delete data

Delete from Wyx where name= ();

modifying data

Update table name set Name= ' Liudehua ' Where condition

Querying data

Select distinct xm,xb count (*) from table name where XH in () and name not in () group by BJ have cou NT (*) >5 order by xm desc limit(0,5);

SELECT * FROM A inner join B on a.xh=b.xh inner join C on C.XH=B.XH where condition;

SELECT * from A left join B on A.XH=B.XH where condition;

SELECT * from A right join B on a.xh=b.xh where condition;

SQL statements vs. database 2