SQLite INSERT INTO

1 개요

SQLite INSERT

CREATE TABLE purchase ( user_id INT(11), item VARCHAR(32) );
INSERT INTO purchase (user_id, item) VALUES (1, 'item_2');
INSERT INTO purchase (user_id, item) VALUES (1, 'item_4');
INSERT INTO purchase (user_id, item) VALUES (2, 'item_5');
INSERT INTO purchase (user_id, item) VALUES (2, 'item_1');
INSERT INTO purchase (user_id, item) VALUES (3, 'item_4');
INSERT INTO purchase (user_id, item) VALUES (3, 'item_2');
INSERT INTO purchase (user_id, item) VALUES (3, 'item_4');
INSERT INTO purchase (user_id, item) VALUES (3, 'item_5');
INSERT INTO purchase (user_id, item) VALUES (4, 'item_3');
SELECT * FROM purchase;

2 같이 보기

• SQLite DELETE
• SQLite UPDATE
• SQLite SELECT
• SQLite CREATE TABLE
• INSERT