/*create database test00 default character set utf8mb4;
/使用数据库/
USE test01;
/删除数据库/
/DROP DATABASE IF EXISTS test01;/
/创建表/
USE test;
CREATE TABLE student
(
stu_id INT PRIMARY KEY AUTO_INCREMENT,
stu_name VARCHAR(15) NOT NULL,
stu_age INT NOT NULL,
stu_gender VARCHAR(1) NOT NULL,
stu_address VARCHAR(50)
);
/删除表/
DROP TABLE IF EXISTS student;
/添加人/
INSERT INTO student(stu_name,stu_age,stu_gender,stu_address)
VALUES(‘张三’,18,‘男’,‘广州现代信息’),
(‘李四’,19,‘女’,‘广州现代信息’),
(‘王五’,17,‘男’,‘广州现代信息’);
DROP TABLE IF EXISTS fish;
/创建fish表/
USE test01;
CREATE TABLE fish
(
fish_id INT PRIMARY KEY AUTO_INCREMENT,
fish_name VARCHAR(15) NOT NULL,
fish_address VARCHAR(50),
ownner_id INT NOT NULL
);
INSERT INTO fish(fish_name,fish_address,ownner_id)
VALUES(‘银龙鱼’,‘鱼缸’,1),
(‘清道夫’,‘鱼缸’,2),
(‘金龙鱼’,‘游览馆’,3),
(‘鲫鱼’,‘餐厅’,4),
(‘鲤鱼’,‘小鱼缸’,5);
/添加属性/
ALTER TABLE fish ADD COLUMN fish_age INT;
/删除属性/
ALTER TABLE fish DROP COLUMN fish_age;
DROP TABLE IF EXISTS car;
CREATE DATABASE car DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE car;
CREATE TABLE car
(
car_id INT P