书写时注意空格
1.搜索语句中模糊查询以及具体查询 where+like+“=”
SELECT * FROM music WHERE name LIKE'说不%';//模糊查询,可以在其前后加上%
SELECT * FROM music WHERE name ='说不出口'; //具体的查询,同时在上面的like中没有加上%,则也可以看成是详细的查询
2.判断数据库中的空值
SELECT * FROM eventRecord e WHERE e.confirmTime ISNULLAND e.endTime ISNULL; //数据中的值为空,在进行判断的时候可以使用
SELECT * FROM eventRecord e WHERE e.confirmTime<'1380443687848' AND e.endTime ISNULL;
SELECT * FROM eventRecord e WHERE e.confirmTime ISNULL AND e.endTime<'1379058374684';
3.多数据的条数限定
select * from instruction where type='组合命令' limit " + (page - 1) * 20 + ",20; //判断以及页号的判断
4.数据库中数据的插入
INSERT INTO instruction(name,type,state) VALUES('" + instruction.getName() + "','组合命令','" + instruction.getState() + "')
5.从数据库中获取出数据并以当前时间进行最新的排序 where+ order by + desc + limit
select * from infromation where infoPublish=1 order by infoTime desc limit 0,5;
order by用于根据指定的列对结果集进行排序或者默认按照升序排序。
select company,orderNumber from orders order by company
select company,orderNumber from orders order by company,ordernumber;
select company,ordernumber from orders order by company desc,ordernumber asc;
6.删除
7.更新
update person set address='zhongshan 23',city='nanjing' where lastname='wilson';