插入、更新、刪除

SQL Server 入門

John MacKintosh

Instructor

INSERT（插入）

INSERT INTO table_name

INSERT INTO table_name (col1, col2, col3)

INSERT INTO table_name (col1, col2, col3) 
VALUES 
  ('value1', 'value2', value3)

INSERT INTO table_name (col1, col2, col3) 
SELECT 
  column1, 
  column2, 
  column3 
FROM other_table 
WHERE 
  -- conditions apply

UPDATE table 
SET column = value 
WHERE 
  -- Condition(s);

UPDATE table 
SET 
  column1 = value1, 
  column2 = value2 
WHERE 
  -- Condition(s);

DELETE 
FROM table 
WHERE 
  -- Conditions

TRUNCATE TABLE table_name

SQL Server 入門