과학과 이성에 대한 극히 주관적인 관점

제 예전의 블로그인 http://blog.naver.com/poorpuppet.do 에서 글을 옮깁니다.

이젠 당당히 '예전' 이라고 하는 구나.. 사요나라 네이버 (흥)

http://blog.naver.com/poorpuppet/40011128894
http://blog.naver.com/poorpuppet/40006504304

원 출처 : www.w3schools.com

---

The INSERT INTO Statement

The INSERT INTO statement is used to insert new rows into a table.
Syntax
INSERT INTO table_name VALUES (value1, value2,....)

You can also specify the columns for which you want to insert data:
INSERT INTOtable_name (column1, column2,...)
VALUES (value1, value2,....)

---

The Update Statement

The UPDATE statement is used to modify the data in a table.
Syntax
UPDATEtable_nameSET column_name = new_valueWHERE column_name = some_value

---

The Delete Statement

The DELETE statement is used to delete rows in a table.
Syntax
DELETE FROM table_name
WHERE column_name = some_value

---

ALTER TABLE

The ALTER TABLE statement is used to add or drop columns in an existing table.

ALTER TABLEtable_name ADD column_name datatype
ALTER TABLE table_name DROP COLUMN column_name

Note: Some database systems don't allow the dropping of a column in a database table (DROP COLUMN column_name).

예)
ALTER TABLE company ADD COLUMN tunnel3 varchar(30) AFTER tunnel2