SQLite INSERT INTO

1 개요[ | ]

SQLite INSERT
SQLite INSERT INTO

SQLite

Copy

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;

Loading

2 같이 보기[ | ]