SET NAMES UTF8;
DROP DATABASE IF EXISTS family;
CREATE DATABASE family CHARSET=UTF8;
USE family;
#创建表格
CREATE TABLE member(
sid INT PRIMARY KEY AUTO_INCREMENT,
memberName VARCHAT(4),
sex VARCHAT(4),
money FLOAT(4,2),
birthday DATE
);
#向表中插入记录行,SQL中的字符串/日期必须用单引号,数字可用单引号也可以不用!
INSERT INTO member VALUES ()