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.