Navicat Premium mysql

標籤：

#Sql語句  建立一表格create table user3(id int(11),name varchar(32),age int (3),sex char(1));#添加語句insert into user3(id ,name,age,sex)values(1,‘張三‘,99,‘男‘);insert into user3 values(4,‘王五‘,21,‘男‘);#刪除delete from user3;#user3中所有資料全刪delete from user3 where name=‘張三‘;delete from user3 where name=‘張三‘ and age=99;#and 出現在條件與條件之間delete from user3 where name=‘張三‘ & age=99;#？？？為何沒效果 &最好不用，Java中逸出字元#修改update user3 set sex=‘女‘ where name=‘李四‘ and age=22;update user3 set sex=‘女‘,age=2 where name=‘李四‘ and age=22;#同時改多個#查詢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 降序排列

 

Navicat Premium mysql