SQL DMLｼ壽ｼ皮ｮ怜ｭ
豈碑ｼ貍皮ｮ怜ｭ
=
>
>=
<
<=
蜷ｦ螳
<>
!=
^=
隲也炊貍皮ｮ怜ｭ
蜆ｪ蜈磯菴
() 竊 NOT 竊 AND 竊 OR
萓具ｼ
SELECT ｽ WHERE 蛻1 = 蛟､1 OR 蛻2 = 蛟､2 AND 蛻3 = 蛟､3
||
SELECT ｽ WHERE 蛻1 = 蛟､1 OR ( 蛻2 = 蛟､2 AND 蛻3 = 蛟､3 )
邂苓｡捺ｼ皮ｮ怜ｭ
| 貍皮ｮ怜ｭ仙錐 | 貍皮ｮ怜ｭ | 謫堺ｽ | 萓 | 邨先棡 | 蜆ｪ蜈磯菴 |
|---|---|---|---|---|---|
| 蜊倬貍皮ｮ怜ｭ | + – | 蜷御ｸ 蜿崎ｻ｢ | +5縲 -10 | 5縲 -10 | 1 |
| 莠碁貍皮ｮ怜ｭ | * / | 荵礼ｮ 髯､邂 | 2*5縲 9/3 | 10縲 3 | 2 |
| + – | 蜉邂 貂帷ｮ | 2+5縲 9-3 | 7縲 6 | 3 | |
| * / + – | 荵鈴勁蜉貂帷ｮ | X + NULL | NULL | ｼ |
譁蟄怜礼ｵ仙粋貍皮ｮ怜ｭ
| 貍皮ｮ怜ｭ | 謫堺ｽ | 萓 | 邨先棡 |
|---|---|---|---|
| || | 譁蟄怜鈴｣邨 | 'AA' || 'BB' | 'AABB' |
| 'AA' || NULL | 'AA' | ||
| NULL || NULL | '' |
髮蜷域ｼ皮ｮ怜ｭ
縲SQL DMLｼ夊､蜷亥撫縺蜷医ｏ縺(UNION)縲榊盾辣ｧ
貍皮ｮ怜ｭ舌ｮ蜆ｪ蜈磯菴
邂苓｡捺ｼ皮ｮ怜ｭ(* / + -)
竊
譁蟄怜礼ｵ仙粋貍皮ｮ怜ｭ(||)
竊
豈碑ｼ貍皮ｮ怜ｭ(= > >= < <=)
竊
髮蜷域ｼ皮ｮ怜ｭ(IN LIKE)縲！S NULL
竊
BETWEEN
竊
豈碑ｼ貍皮ｮ怜ｭｼ壼凄螳(<> != ^=)
竊
隲也炊貍皮ｮ怜ｭ(NOT AND OR)
Follow me!
