1.創(chuàng)建數(shù)據(jù)庫
create database user;
2.刪除數(shù)據(jù)庫
drop database user;
3.選擇數(shù)據(jù)庫
use user;
4.創(chuàng)建數(shù)據(jù)表
create table userinfo(
user_id INT UNSIGNED AUTO_INCREMENT,
username VARCHAR(100) NOT NULL,
age VARCHAR(40) NOT NULL,
PRIMARY KEY ( user_id )
)
5.刪除表格
drop table userinfo
- 查詢語句
select * from userinfo
7.插入數(shù)據(jù)
insert into userinfo (username,age) values("veb",20)
8.刪除數(shù)據(jù)
delete from userinfo where user_id=1
9.更新數(shù)據(jù)
update userinfo set username="abc",age="333" where user_id=1
