Jimmyxmu的博客

思维导图

use test; #创建用户表 create table if not exists users(id int primary key auto_increment name varchar(30),age int,status int,score int,acountid int ); #插入数据 insetr into users(name,age,status,score,acountid)values('张三',19,0,40,1001), ('李四',15,1,0,1002); #创建订单表 c

触发器的应用 CREATE DATABASE IF NOT EXISTS TEXT DEFAULT CHARSET utf8; USE TEXT; CREATE TABLE IF NOT EXISTS student(username VARCHAR(50), PASSWORD VARCHAR(50),stuid INT PRIMARY KEY AUTO_INCREMENT, birthday DATE ); SELECT * FROM student; INSERT INTO student(..

CREATE DATABASE IF NOT EXISTS xxl_ca1 DEFAULT CHARSET utf8; USE xxl_ca1; #删掉表 DROP DROP TABLE emp; CREATE TABLE IF NOT EXISTS emp(emp_id INT PRIMARY KEY AUTO_INCREMENT, emp_name VARCHAR(20), salary INT, manager_id INT ); SELECT * FROM emp; #直接索引 CREATE I.