常用查询语句:
1、select...(内容)...from...(表单)...where...(限制条件)...
SELECT a,*
FROM formtable_1
WHERE requestId = '1'
2、inner join...on... :连接其他表
SELECT *
FROM formtable_a a
INNER JOIN formtable_ b ON a.id = b.mainid
WHERE a.lsh='abc' AND b.id='8'
3、order by:排序
SELECT * FROM 表 a
WHERE 条件='1'
ORDER BY a.日期
* asc 升序 desc 降序
4、in
SELECT workcode,status,* from 表 where workcode='' and status in (1,2,3,4)
查询 status 为 1,2,3,4的信息