SQL基本代码

#查看有什么库     SHOW DATABASES

#创建数据库
CREATE DATABASE great_list;
USE gregs_list;

#创建表
CREATE TABLE my_contacts
(last_name VARCHAR(30),
first_name VARCHAR(20),
emil VARCHAR(50),
gender CHAR(1),
birthday DATE,
profession VARCHAR(50),
location VARCHAR(50),
status VARCHAR(20),
interest VARCHAR(20),
seeking VARCHAR(100));

#查看表 DESC
#删除表 DROP TABLE my_contacts

#插入数据
INSERT INTO my_contacts
(last_name,first_name,emil,gender,birthday,
profession,location,status,interest,seeking)
VALUES
('JSON','CRMMY','dasjk@qq.com','F','1998-11-22',
'Techer','chian','Single','play games','friend');

INSERT INTO my_contacts
(first_name,emil,profession,location)
VALUES
('Pat','dhhugu@qq.com','farmer','liuzhou');

#查找数据
SELECT *FROM my_contacts;

#用DEFAULT 1.00 填补空白，给指定值