タグ: SQL

bbe

Select

/* 全件取得 */
select * from (tablename)

/* Where条件 一致*/
select * from (tablename)
 where (colname) = '0001'

/* Where条件 あいまい検索*/
select * from (tablename)
 where (colname) like '%01%'

Insert

insert into (tablename) (
 (col1)
,(col2)
,(col3)
)values(
 (value1)
,(value2)
,(value3)
)

Update

/* 全件更新 */
update (tablename) set
  (col1) = (value1)

/* Where条件 */
update (tablename) set
  (col1) = (value1)
 where (col2) = (value2)

Delete

/* 全件削除 */
delete from (tablename)

/* Where条件 */
delete from (tablename)
 where (col1) = (value1)