SQLite INSERT INTO

1 개요[ | ]

SQLite INSERT
SQLite INSERT INTO

SQLite

CPU

0.0s

MEM

4M

0.0s

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;

+---------+--------+
| user_id |  item  |
+---------+--------+
| 1       | item_2 |
| 1       | item_4 |
| 2       | item_5 |
| 2       | item_1 |
| 3       | item_4 |
| 3       | item_2 |
| 3       | item_4 |
| 3       | item_5 |
| 4       | item_3 |
+---------+--------+

2 같이 보기[ | ]