· 6 years ago · May 17, 2019, 04:36 PM
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);