SQLite/テーブルã®ã‚³ãƒ”ー - ブーストプãƒã‚°ãƒ©ãƒ テーブルã®ã‚³ãƒ”ー æ—¢å˜ãƒ†ãƒ¼ãƒ–ルã¨åŒã˜æ§‹é€ ã€ãƒ‡ãƒ¼ã‚¿ã‚’æŒã¤æ–°ã—ã„テーブルを作る ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—用途やã€å…¨ãƒ‡ãƒ¼ã‚¿ã®å…¥åŠ›ã‚ˆã‚Šã‚‚変更箇所ãŒã‚’ UPDATE ã—ãŸæ–¹ãŒæ—©ã„å ´åˆãªã©ã«ä¾¿åˆ© å…¨ãåŒã˜ãƒ†ãƒ¼ãƒ–ルを作æˆã™ã‚‹ ç¾åœ¨ã®ãƒ†ãƒ¼ãƒ–ル (å‰å›žã®ç¶šã + 見ã«ãã„ã®ã§ä¸€éƒ¨å‰Šé™¤) sqlite> DELETE FROM t_menu WHERE name LIKE "ãƒãƒŠãƒŠ%"; sqlite> DELETE FROM t_menu WHERE name LIKE "%ãƒãƒŠãƒŠ"; sqlite> DELETE FROM t_menu WHERE name LIKE "メãƒãƒ³%"; sqlite> DELETE FROM t_menu WHERE name LIKE "%メãƒãƒ³"; id name ---- ------------- 1 イãƒã‚´ãƒŸãƒ«ã‚¯ 2 イãƒã‚´ãƒ‘フェ 4 ã¾ã‚‹ã”ã¨ã‚¤ãƒã‚´ åŒã˜ã‚«ãƒ©ãƒ åã€ãƒ‡ãƒ¼ã‚¿ã®ãƒ†
ビューを作æˆã™ã‚‹
rktSQLite : SQLiteã®SQLコマンド CREATE
{{#tags}}- {{label}}
{{/tags}}