SQL
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
#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
}}
* RDBMS [#ebd3ff02]
-[[SQL/MySQL]]
-[[SQL/Oracle]]
終了行:
#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
}}
* RDBMS [#ebd3ff02]
-[[SQL/MySQL]]
-[[SQL/Oracle]]
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
