MariaDB [(none)]>CREATE DATABASES;
删除数据库
MariaDB [(none)]> DROP DATABASE rookery;
创建数据库并指定数据库使用的字符集和存储方式
MariaDB [(none)]> CREATE DATABASE rookery
把rookery设置为默认数据库
MariaDB [(none)]> USE rookery;
创建birds表
MariaDB [rookery]> CREATE TABLE birds (
查询表结构
建立6行数据
Database changed
MariaDB [rookery]> INSERT INTO birds (scientific_name,common_name)
查看表的内容
新建另一个数据库
MariaDB [(none)]> CREATE TABLE birdwathers.humans
新建表
MariaDB [(none)]> CREATE TABLE birdwatchers.humans
(human_id INT AUTO_INCREMENT PRIMARY KEY,
name_first VARCHAR(25),
name_last VARCHAR(25),
email_address VARCHAR(255));
插入4条数据
MariaDB [(none)]> INSERT INTO birdwatchers.humans (formal_title,name_first,name_last,email_address) VALUES ('Mr.','Russell','Dyer','ressell@mysqlresources.com'), ('Mr.','Richard','Stringer','richard@mysqlsources.com'),
('Ms.','Rusty','Osborne', 'resty@mysqlsources.com'),
('Ms.','Lexi','Hollar','alexandra@mysqlresources.com');
使用SHOW CREATE TABLE查看表结构
MariaDB [rookery]> SHOW CREATE TABLE birds \G
*************************** 1. row ***************************
Create Table: CREATE TABLE `birds` (
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_bin
建表bird_families它用于存放鸟的科信息
MariaDB [rookery]> CREATE TABLE bird_families
scientific_name VARCHAr(255) UNIQUE,
brief_descritpion VARCHAR(255) );
建立鸟目表
MariaDB [rookery]> CREATE TABLE bird_orders (
order_id INT AUTO_INCREMENT PRIMARY KEY,
scientific_name VARCHAR(255) UNIQUE,
brief_description VARCHAR(255), order_image BLOB