📄 create.sql
字号:
CREATE DATABASE ch02;
USE ch02;
# -----------------------------------------------------------------------
# player_info
# -----------------------------------------------------------------------
DROP TABLE IF EXISTS player_info;
CREATE TABLE player_info (
username VARCHAR(20) NOT NULL,
password VARCHAR(20) NOT NULL,
realname VARCHAR(20) NOT NULL,
PRIMARY KEY (username) );
# -----------------------------------------------------------------------
# player_record
# -----------------------------------------------------------------------
DROP TABLE IF EXISTS player_record;
CREATE TABLE player_record (
username VARCHAR(20) NOT NULL,
grade CHAR(1) NOT NULL,
use_time int,
PRIMARY KEY ( username,grade ) );
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -