SET NAMES UTF8;
DROP DATABASE IF EXISTS family;
CREATE DATABASE family CHARSET=UTF8;
USE family;
#創(chuàng)建表格
CREATE TABLE member(
? sid INT PRIMARY KEY AUTO_INCREMENT,
memberName VARCHAT(4),
sex VARCHAT(4),
money FLOAT(4,2),
birthday DATE
);
#向表中插入記錄行,SQL中的字符串/日期必須用單引號(hào)仍稀,數(shù)字可用單引號(hào)也可以不用陨舱!
INSERT INTO member VALUES ()