Basic syntax for "MYSQL" sql

show databases; #查看所有的数据库
Create database Myfirst; #创建一个schemas databases
Use Myfirst; #进入到这个数据库中
Show tables; #查看所有表
CREATE TABLE Myfirst.tableone (ID int NOT NULL primary key,name varchar (a) Not Null,birth Date,sex char (1)); #创建表
Describe Tableone; #查看表结构
ALTER TABLE Tableone add addr varchar () not NULL; #增加一列
ALTER TABLE tableone drop addr; #删除一列
INSERT into Tableone values (' 2 ', ' Flora ', ' 1983-08-24 ', ' M '); #插一条记录
SELECT * from Tableone; #查看表内容

Update tableone set sex= ' F ' where name= ' flora '; #修改
Delete from Tableone where name= ' flora '; #删除

This article from "Happy_candy" blog, declined reprint!

Basic syntax for "MYSQL" sql