Navicat Premium MySQL

#Sql语句 Create a tableCreate TableUser3 (IDint( One), namevarchar( +), ageint(3), SexChar(1) ); #添加语句Insert  intoUser3 (ID, name,age,sex)Values(1,'Zhang San', About,'male');Insert  intoUser3Values(4,'Harry', +,'male'); #删除Delete  fromUser3; #user3中所有数据全删Delete  fromUser3whereName='Zhang San';Delete  fromUser3whereName='Zhang San'  andAge= About;# andappears between conditions and conditionsDelete  fromUser3whereName='Zhang San' &Age= About;#？？？ Why not?&It's best not to, Java Transit Semantic characters # ModifyUpdateUser3SetSex='female' whereName='John Doe'  andAge= A;UpdateUser3SetSex='female', age=2 whereName='John Doe'  andAge= A; #同时改多个 # querySelectName,id,age,sex fromUser3; #查询所有Select *  fromUser3; #查询所有 orderSelectName fromUser3; #查询所有姓名SelectId,name,age,sex fromUser3whereName='John Doe'  andAge=2;SelectId,name,age,sex fromUser3whereName='John Doe' orAge=2;Select *  fromUser3Order  byIdASC; #按id in ascending orderSelect *  fromUser3Order  byIddesc; #按id descending order

Navicat Premium MySQL