SQLite CREATE TABLE

1 개요[ | ]

SQLite CREATE TABLE

SQLite

CPU

0.0s

MEM

4M

0.0s

Copy

CREATE TABLE dept1 (
  dept_id INT(11) NOT NULL,
  dept_name VARCHAR(32) NOT NULL
);
CREATE TABLE dept2 (
  dept_id INT(11) NOT NULL,
  dept_name VARCHAR(32) NOT NULL
);
SELECT name FROM sqlite_master WHERE name LIKE 'dept%';

+-------+
| name  |
+-------+
| dept1 |
| dept2 |
+-------+

2 같이 보기[ | ]