· 6 years ago · May 23, 2019, 12:06 AM
1CREATE DATABASE IF NOT EXISTS test;
2
3USE test;
4
5DROP TABLE IF EXISTS user;
6
7CREATE TABLE user {
8 user_id int(20) NOT NULL,
9 username varchar(255) NULL,
10 created_by varchar(255) NOT NULL,
11 created_date DATE NOT NULL,
12 PRIMARY KEY (user_id)
13};