데이터 삽입(INSERT INTO)

설명

INSERT INTO 구문을 사용하면 테이블에 데이터를 삽입할 수 있다.

구문

INSERT INTO table_name [ ( attribute_list ) ] VALUES ( value_list ) [ ; ]
INSERT INTO table_name DEFAULT [ VALUES ] [ ; ]

예제

INSERT INTO athlete (name, gender, nation_code, event) VALUES ('Nam Hyun-Hee', 'W', 'KOR', 'Fencing');

INSERT INTO olympic (host_year, host_nation, host_city, opening_date, closing_date) VALUES (2008, 'China', 'beijing', '2008-08-08','2008-08-24');

CREATE TABLE de_test(
a INT DEFAULT 10,
b INT DEFAULT 20,
c CHAR(1) DEFAULT 'M' );

INSERT INTO de_test DEFAULT;

csql> SELECT * FROM de_test;
csql> ;x
=== <Result of SELECT Command in Line 1> ===
            a            b  c
================================================
           10           20  'M'    
1 rows selected.