#Sql語(yǔ)句 創(chuàng)建一表格 create table user3(id int(11),name varchar(32),age int (3),sex char(1));#添加語(yǔ)句 insert into user3(id ,name,age,sex)values(1,'張三',99,'男'); insert into user3 values(4,'王五',21,'男'); #刪除 delete from user3;#user3中所有數(shù)據(jù)全刪 delete from user3 where name='張三'; delete from user3 where name='張三' and age=99;#and 出現(xiàn)在條件與條件之間 delete from user3 where name='張三' & age=99;#？？？為何沒(méi)效果 &最好不用，Java中轉(zhuǎn)義字符 #修改 update user3 set sex='女' where name='李四' and age=22; update user3 set sex='女',age=2 where name='李四' and age=22;#同時(shí)改多個(gè) #查詢 select name,id,age,sex from user3;#查詢所有 select * from user3;#查詢所有 順序 select name from user3;#查詢所有姓名 select id,name,age,sex from user3 where name='李四' and age=2; select id,name,age,sex from user3 where name='李四' or age=2;select * from user3 order by id asc;#按id 升序排列 select * from user3 order by id desc;#按id 降序排列

?

轉(zhuǎn)載于:https://www.cnblogs.com/kimsimple/p/5697096.html

總結(jié)

以上是生活随笔為你收集整理的Navicat Premium mysql的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。