]]>
すぐ見たいメモ2009-08-25T23:42:19+09:00yukku0423FC2-BLOG
http://yukku0423.blog33.fc2.com/blog-entry-71.html
SQL文メモ SELECTSELECT [列] FROM [表] WHERE [条件];列名を任意に指定したい場合は [列] as '任意の名称'INSERTINSERT INTO [表] ([列1], [列2], ...) VALUES([値1], [値2], ...);UPDATEUPDATE [表] SET [列1] = [値1], [列2] = [値2], ... WHERE [条件];DELETEDELETE FROM [表] WHERE [条件];JOINJOIN [結合する表] ON [結合条件]文字列は''(シングルクォーテーション)で囲む
SELECT [列] FROM [表] WHERE [条件]; 列名を任意に指定したい場合は [列] as '任意の名称'
INSERT INSERT INTO [表] ([列1], [列2], ...) VALUES([値1], [値2], ...);
UPDATE UPDATE [表] SET [列1] = [値1], [列2] = [値2], ... WHERE [条件];