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.