0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

SQL 4大命令 基本構文

Last updated at Posted at 2022-09-23

・CHARとVARCHARの違い
CHARは固定長 
VARCHARは可変長

・SQL 4大命令
SELECT UPDATE DELETE INSERT

・SELECT文

SELECT 列名・・・  --【例】ITEM,RECEIVE,PAY
FROM テーブル名
(WHERE 修飾)
(その他の修飾) 

・UPDATE文

UPDATE テーブル名
SET 列名1=値1,列名2=値2・・・
(WHERE修飾)--WHEREのない文は全件更新

・DELETE文

DELETE
FROM テーブル名
WHERE 修飾)--WHEREのない文は全データ削除【要注意】

・INSERT文

INSERT INTO テーブル名
                        (列名1、列名2、列名3・・・)
 VALUES     (値1、値2、値3・・・)
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?