12 lines
273 B
SQL
12 lines
273 B
SQL
CREATE DATABASE IF NOT EXISTS test;
|
|
USE test;
|
|
DROP TABLE IF EXISTS test;
|
|
create table test(
|
|
id bigint,
|
|
name varchar (2000),
|
|
tag char(1)
|
|
);
|
|
insert into test values (1, 'Bob', NULL);
|
|
insert into test values (2, 'Jane', NULL);
|
|
insert into test values (3, 'John', NULL);
|