MySQL数据库常用语句

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 ()