wrCxjbzb

1CREATE DATABASE IF NOT EXISTS test_db;
2
3CREATE TABLE IF NOT EXISTS test_db.users (
4  id INT AUTO_INCREMENT,
5  name VARCHAR(255) NOT NULL,
6  age INT NOT NULL,
7  sex TINYINT NOT NULL DEFAULT 0,
8  PRIMARY KEY (id)
9);
10
11INSERT INTO test_db.users (name, age, sex)
12  VALUES ('taro', 18, 1),
13         ('jiro', 17, 1),
14         ('hanako', 21, 2),
15         ('himawari', 20, 2);