create database school default charset=utf8; -- 創(chuàng)建數(shù)據(jù)庫
create database if not exists xuexiao default charset=utf8;
use school;-- 使用數(shù)據(jù)庫
create table studentInfo(
name varchar(20),
sex char,
age int,
address varchar(50)

);
show tables; -- 顯示表格
-- 插入數(shù)據(jù)
-- 1字段和數(shù)據(jù)一一對(duì)應(yīng) 2 字段如果和創(chuàng)建時(shí)一致，那么可以省略
insert into studentInfo (name ,sex ,age ,address) values ("zhangsan",'n',18,"henan");
insert into studentInfo values ("zhangsanfeng",'n',58,"henansheng");
insert into studentInfo (sex ,address,age ,name ) values ("女","河南省峨眉",28,"滅絕師太");
select *from studentInfo;-- 查詢所有數(shù)據(jù)

create table studentInfo2(
name varchar(20),
sex char not null default'男',
age int not null default 18,
address varchar(50)

);
-- 可以根據(jù)需要省略有默認(rèn)值的字段
insert into studentInfo2 (name , address) values ("周芷若","峨眉")
insert into studentInfo2 (name , sex , age , address) values ("周芷若",'女',20,"峨眉")
insert into studentInfo2 values ("周芷若",'女',20,"峨眉")
-- 一次插入多行數(shù)據(jù)
insert into studentInfo2 values ("周芷若",'女',20,"峨眉"), ("趙梅",'女',20,"蒙古"), ("趙梅",'女',20,"蒙古"), ("趙梅",'女',20,"蒙古");

select *from studentInfo2;-- 查詢所有數(shù)據(jù)

create table studentInfo3(
id int primary key auto_increment,
name varchar(20),
sex char not null default'男',
age int not null default 18,
address varchar(50)

);
insert into studentInfo3 (id ,name,sex ,age,address)values(1,'鐵牛','男',20,"梁山");
insert into studentInfo3 (name,sex ,age,address)values('鐵牛','男',20,"梁山"); -- 自動(dòng)增長(zhǎng)的字段，插入數(shù)據(jù)時(shí)可以不寫

select *from studentInfo3;