· 6 years ago · Aug 31, 2019, 05:10 PM
1DROP DATABASE IF EXISTS a4;
2
3CREATE DATABASE a4;
4
5USE a4;
6
7CREATE TABLE article (
8 id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
9 PRIMARY KEY(id),
10 regDate DATETIME NOT NULL,
11 writer CHAR(100) NOT NULL,
12 title CHAR(100) NOT NULL,
13 `body` TEXT NOT NULL
14);
15
16SHOW TABLES;
17
18SELECT *
19FROM article;