span>
waitfor delay ’01:02:03’
select * from employee
--例 等到晚上11 点零8 分后才执行SELECT 语句
waitfor time ’23:08:00’
SELECT
select *(列名) from table_name(表名) where column_name operator value ex宿主)
select * from stock_information where stockid = str(nid)
stockname = ''''str_name''''
stockname like ''''% find this %''''
stockname like ''''[a-zA-Z]%'''' --------- ([]指定值的范围)
stockname like ''''[^F-M]%'''' --------- (^排除指定范围)
--------- 只能在使用like关键字的where子句中使用通配符)
or stockpath = ''''stock_path''''
or stocknumber < 1000
and stockindex = 24
not stocksex = ''''man''''
stocknumber between 20 and 100
stocknumber in(上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
