SQL基础操作语言

1 .create database mydb;

2 .create database testdb;
use testdb;
create table temp(
id int,
name varchar(32),
deptld int,.
salary float);

3 . create table t_user1(
userld int primary key,
name varchar(32),
password varchar(11),
phone varchar(11),
email varchar(32));

create table t_user2(
name varchar(32),
phone varchar(11),
email varchar(32),
primary key (name phone));

4.create table t_class(
id int primary key,
name varchar(22));

create table t_student(
id int primary key,
name varchar(22),
classld int,
constraint fk_stu_class1 foreign key(classld) references t_student(id));

5.create table t_user(
id int primary key auto_increment,
usename varchar(32) not null unique,
sex varchar(4) default’男’)
default charset = utf8;