/*
编写脚本文件 xz.sql 先丢弃再创建数据库xz 进入数据库xz 创建保存用户数据的表user, 包含有编码uid 用户名 uname 密码upwd
邮箱email 电话phone 真实姓名 userName 注册时间regTime 是否在线isOnline 插入若干条数据 查询结果
*/
#丢弃数据库
DROP database IF EXISTS xz;
#创建数据库
CREATE database xz;
#进入数据库
USE xz;
#创建数据表
CREATE TABLE user(
uid INT,
uname VARCHAR(10),
upwd VARCHAR(20),
email VARCHAR(20),
phone INT,
username VARCHAR(10),
regTime VARCHAR(20),
isOnline VARCHAR(1)
);
#插入数据
INSERT INTO user VALUES('1','jiew','qwer12345','3124535@qq.com','123456789','weg','1987-10-23','N');
INSERT INTO user VALUES('2','pite','qweafa345','vdn2494@163.com','123456789','weg','1987-10-23','T');
INSERT INTO user VALUES('3','mary','afawerf345','142985234@qq.com','123456789','weg','1987-10-23','T');
INSERT INTO user VALUES('4','Dave','okweafc345','opio009@163.com','123456789','weg','1987-10-23','N');
#查询数据
SELECT*FROM user;