SQL の変更点 luckey!!!!

追加された行はこの色です。
削除された行はこの色です。
SQL へ行く。
SQL の差分を削除

#author("2017-05-02T00:29:00+09:00","","")
#author("2017-05-02T00:29:58+09:00","","")
#nofollow
#norelated
* SQL [#fc9d651d]

#contents

* ''コマンド集'' [#ec9df784]
- 検索
#highlighter(MySQL,number){{
 SELECT * FROM POST_TABLE
 WHERE POST_ID = '111'
 AND POST_NM LIKE '品川%'
 OR  POST_ADDR = '111-1111'
}}
- 登録
#highlighter(MySQL,number){{
INSERT INTO POST_TABLE (NO,POST_ID, POST_NM,POST_ADDR)
       VALUES(1,'111','品川区','111-1111')
}}
- 更新
#highlighter(MySQL,number){{
UPDATE POST_TABLE
SET POST_ADDR = '111-1112'
WHERE NO = 1
}}
- 削除
#highlighter(MySQL,number){{
DELETE FROM POST_TABLE WHERE NO = 1
}}
* SQLソフト [#ebd3ff02]
* RDBMS [#ebd3ff02]
-[[SQL/MySQL]]
-[[SQL/Oracle]]