📄 db-7a.html
字号:
<html>
<head>
<title>荐侥阑 荤侩茄 龙狼 </title>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
</head>
<body bgcolor="#FFFFFF" topmargin=5 leftmargin=15>
<p><br>
<font size="4"><b> Query </b></font></p>
<div align="left">
<hr width="70%" align="left">
</div>
<div align="left"></div>
<p> <font size="2"><br>
<b><font size="3">屈侥</font></b><br>
<br>
<font color="#3300CC">SELECT 拿烦疙,拿烦疙,拿烦疙,.....<br>
FROM table疙, table疙, table疙,.... <br>
WHERE 炼扒 (WHERE啊 积帆登搁 葛电 饭内靛)<br>
GROUP BY 1瞒弊缝, 2瞒弊缝 <br>
HAVING 弊缝俊 措茄 炼扒<br>
ORDERY BY 拿烦疙 [ASC | DESC], 拿烦疙 [ASC | DESC]...<br>
COMPUTE 拌魂侥</font><br>
<br>
<br>
USE sawondb<br>
<br>
SELECT sawon_name AS '荤盔疙', dept_no AS '何辑锅龋', sawon_pay AS '鞭咯' FROM sawon<br>
<br>
SELECT '荤盔疙'=sawon_name, '何辑锅龋'=dept_no, '鞭咯'=sawon_pay FROM sawon<br>
<br>
SELECT sawon_name AS '荤盔疙', dept_no AS '何辑锅龋', sawon_pay AS '鞭咯' <br>
FROM sawon ORDER BY sawon_pay DESC -- 鞭咯喊 郴覆瞒鉴<br>
<br>
SELECT sawon_name AS '荤盔疙', dept_no AS '何辑锅龋', sawon_pay AS '鞭咯'<br>
FROM sawon ORDER BY sawon_pay --ASC -- 鞭咯喊 坷抚瞒鉴<br>
<br>
<br>
-- sawon table 俊辑 苞厘苞 林烙父 鞭咯狼 郴覆瞒鉴栏肺 唱鸥郴绢扼 <br>
<br>
SELECT * FROM sawon WHERE sawon_jik='苞厘' OR sawon_jik='措府' <br>
ORDER BY sawon_pay DESC<br>
<br>
<b><font size="3">楷魂磊</font></b><br>
<br>
1. 魂贱楷魂磊 +(怠祭),-(滑祭),*(蚌祭),/(唱窗祭), %(唱赣瘤)<br>
<br>
2. 包拌楷魂磊 =, >, <, >=, <=, <>, <br>
!=鞍瘤臼促, !<农瘤臼促, !>累瘤臼促<br>
<br>
3. 稠府楷魂磊 NOT,AND,OR <br>
<br>
4. 厚背<br>
1) between 10 and 100, 肚绰 not between 10 and 100<br>
<br>
抗> sawon狼 sawon_pay啊 1000何磐 3000鳖瘤<br>
select * from sawon where sawon_pay between 1000 and 3000 <br>
<br>
2) in(蔼1, 蔼2,....) 肚绰 not in<br>
<br>
抗> sawon狼 sawon_jik捞 '措府' or '苞厘' <br>
select * from sawon where sawon_jik in('措府','苞厘')<br>
<br>
3) isnull<br>
<br>
4) like 肚绰 not like <br>
<br>
% : 葛电 巩磊(Like客 窃膊 荤侩)<br>
_(UnderBar) : 1巩磊 秦寸<br>
[ ] : 笼钦救俊 乐绰 巩磊吝俊 1俺<br>
[^] : 笼钦救俊 绝绰 巩磊<br>
<br>
<br>
--------------------------------------- <br>
sawon_name like '辫%' : 辫揪父 免仿窍扼<br>
sawon_no like '[0-9]' : 0何磐 9鳖瘤<br>
sawon_name like 'a[^b]%' : 霉臂磊啊 a肺 矫累窍绊 滴锅掳 巩磊 b啊 酒囱巴<br>
<br>
select * from sawon <br>
where sawon_name like '捞鉴%'<br>
<br>
select * from sawon<br>
where sawon_name like '捞[^鉴]%'<br>
<br>
select * from sawon<br>
where sawon_name like '捞[固,己]%'<br>
<br>
<br>
-- sawon table俊辑 措府客 荤盔父阑 免仿<br>
select * from sawon where sawon_jik in ('措府','荤盔')<br>
select * from sawon where sawon_jik like '[措府,荤盔]%'<br>
<br>
-- sawon table俊辑 措府客 荤盔阑 力寇茄 唱赣瘤 免仿<br>
select * from sawon where sawon_jik not in('措府','荤盔')<br>
select * from sawon where sawon_jik not like '[措府,荤盔]%'<br>
<br>
-- sawon table俊辑 己捞 辫揪客 捞揪甫 免仿<br>
select * from sawon where sawon_name like '辫%' <br>
or sawon_name like '捞%'<br>
-- 肚绰 <br>
select * from sawon where sawon_name like '[辫,捞]%' <br>
<br>
select * from sawon where sawon_name like '[辫捞全]%'<br>
select * from sawon where sawon_name like '[辫捞全][蜡辨]%'<br>
select * from sawon <br>
<br>
-- sawon table俊辑 己捞 捞揪啊 酒囱 荤恩阑 免仿<br>
select * from sawon where sawon_name not like '捞%' <br>
<br>
-- sawon table俊辑 己捞 辫揪, 捞揪, 全揪啊 酒囱 荤恩阑 免仿<br>
select * from sawon where sawon_name not like '辫%' <br>
and sawon_name not like '捞%'<br>
and sawon_name not like '全%'<br>
-- 肚绰<br>
select * from sawon where sawon_name not like '[辫,捞,全]%' <br>
<br>
<br>
-- gogek table俊辑 绊按傈拳锅龋狼 瘤开锅龋啊 032牢 荤恩阑 免仿<br>
select * from gogek where gogek_tel like '032%'<br>
<br>
-- gogek table俊辑 绊按傈拳锅龋狼 霉磊府啊 0 肚绰 3肚绰 2牢 荤恩阑 免仿<br>
select * from gogek where gogek_tel like '[032]%'<br>
<br>
-- gogek table俊辑 绊按傈拳锅龋狼 瘤开锅龋啊 03栏肺 矫累窍绰 荤恩(牢玫,版扁)阑 免仿<br>
select * from gogek where gogek_tel like '03%'<br>
<br>
<br>
-- gogek table俊辑 瘤开锅龋啊 02 肚绰 032 捞搁辑 惫锅捞 6锅何磐 9锅栏肺 矫累窍绰 荤恩阑 免仿<br>
select * from gogek where gogek_tel like '02-[6-9]%'<br>
or gogek_tel like '032-[6-9]%'<br>
<br>
-- sawon table俊辑 荤盔捞抚吝 '捞'磊啊 器窃等 荤恩 免仿<br>
select * from sawon where sawon_name like '%捞%'<br>
<br>
-- sawon table俊辑 荤盔捞抚吝 滴锅掳 臂磊啊 '鉴'磊牢 荤恩 免仿<br>
select * from sawon where sawon_name like '_鉴%'<br>
<br>
-- sawon table俊辑 荤盔捞抚吝 '捞'揪牢单 滴锅掳 臂磊啊 '鉴'磊啊 酒囱 荤恩 免仿 <br>
select * from sawon where sawon_name like '捞[^鉴]%'<br>
</font><font size="2"><br>
</font> </p>
<p align=right>...<a href="JavaScript:clickOn=history.go(-1)"> <FONT SIZE=-1 FACE=HELVETICA>
Prev</FONT></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -