1.创建数据库
webases
2.使用数据库
use webases;
3.定义表
create table UserTable (
USERID INT(4) PRIMARY KEY AUTO_INCREMENT NOT NULL,
UNAME VARCHAR(20) NOT NULL,
UPASSWARD VARCHAR(20) NOT NULL
)
4.插入数据
INSERT INTO UserTable(UNAME,UPASSWARD) values("daniel","123");
5.检索数据
SELECT * FROM UserTable;