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