创建数据库
CREATE DATABASE DATABASE_NAME;
create database pet;
选择数据库
USE DATABASE_NAME;
use pet;
查看所有数据库
SHOW DATABASES;
在当前数据库中创建表
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
显示表中列的属性
DESCRIBE TABLE_NAME;
DESCRIBE pet;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------