Question

SQL数据库用代码创建 怎么创建？

文件名为aaa

Answer 1

create dababase [dababasename]
on primary
(name=N'dataname1',filename=N'maindatabasename.mdf',size='small MB', maxsize='max MB', filegrowth='30%'),
(name=N'dataname2',filename=N'maindatabasename.ndf',size='small MB', maxsize='max MB', filegrowth='30%')
filegroup file-group
log on
(name=N'dataname3',filename=N'maindatabasename.ndf',size='small MB', maxsize='max MB', filegrowth='30%')
(name=N'data_log',filename=N'maindatabasename.ldf',size='small MB', maxsize='max MB', filegrowth='30%')

Answer 2

1.创建数据库study1:

show databases;
create database study1;
use study1;
show tables;

create table emp(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into emp values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from emp;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;
select * from emp;
create table emp2(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));
insert into emp2 values (001,'bai1','male','1999-01-02',10000),
(002,'bai2','male','1989-02-01',20000),
(003,'bai3','male','1999-03-01',30000),
(004,'bai4','male','1963-06-03',50000),
(005,'bai5','male','1998-12-13',40000),
(006,'bai6','male','1967-12-20',45000),
(007,'bai7','male','1999-02-06',60000),
(008,'bai8','male','1987-01-01',70000),
(009,'bai9','male','1986-03-11',80000),
(010,'bai10','male','1999-12-11',88888);

select * from emp2;

update emp set salary =99999 where id=010;
update emp set salary =88888 where id=009;
update emp set salary =77777 where id=008;
update emp set salary =66666 where id=007;
update emp set salary =55555 where id=006;
update emp set salary =44444 where id=005;
update emp set salary =33333 where id=004;
update emp set salary =22222 where id=003;
update emp set salary =11111 where id=002;
update emp set salary =10000 where id=001;
select * from emp2;
create table emp3(
id int,
name varchar(100),
sex char(6),
age int,
salary float(10,2));
insert into emp3 values (1,'bai1','male','10',10000),
(2,'bai2','male','11',20000),
(3,'bai3','male','12',30000),
(4,'bai4','male','13',50000),
(5,'bai5','male','14',40000),
(6,'bai6','male','15',45000),
(7,'bai7','male','16',60000),
(8,'bai8','male','17',70000),
(9,'bai9','male','18',80000),
(10,'bai10','male','19',88888);

select * from emp3;

update emp set salary =30 where id=10;
update emp set salary =31 where id=9;
update emp set salary =32 where id=8;
update emp set salary =34 where id=7;
update emp set salary =35 where id=6;
update emp set salary =36 where id=5;
update emp set salary =37 where id=4;
update emp set salary =38 where id=3;
update emp set salary =39 where id=2;
update emp set salary =40 where id=1;
select * from emp3;
create table emp4(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));
insert into emp4 values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from emp4;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;
select * from emp4;
create table emp5(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));
insert into emp5 values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from emp5;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;
select * from emp5;
2.创建数据库study2;
show databases;
create database study2;
use study2;
show tables;

create table aaa(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into aaa values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from aaa;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;

create table bbb(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into bbb values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from bbb;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;
select * from bbb;

create table ccc(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into ccc values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from ccc;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;

select * from ccc;

create table ddd(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into ddd values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from ddd;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;

select * from ddd;

create table eee(
id int,
name varchar(100),
sex char(6),
birthday date,
salary float(10,2));

insert into eee values (1,'bai1','male','1999-01-02',10000),
(2,'bai2','male','1989-02-01',20000),
(3,'bai3','male','1999-03-01',30000),
(4,'bai4','male','1963-06-03',50000),
(5,'bai5','male','1998-12-13',40000),
(6,'bai6','male','1967-12-20',45000),
(7,'bai7','male','1999-02-06',60000),
(8,'bai8','male','1987-01-01',70000),
(9,'bai9','male','1986-03-11',80000),
(10,'bai10','male','1999-12-11',88888);

select * from eee;

update emp set salary =99999 where id=10;
update emp set salary =88888 where id=9;
update emp set salary =77777 where id=8;
update emp set salary =66666 where id=7;
update emp set salary =55555 where id=6;
update emp set salary =44444 where id=5;
update emp set salary =33333 where id=4;
update emp set salary =22222 where id=3;
update emp set salary =11111 where id=2;
update emp set salary =10000 where id=1;

select * from eee;

Answer 3

create database 数据库名称
on
(
name='aaa',
filename='aaa.dbf',
size=初始大小，
maxsize=存储上限，
filegrowth=增长增量
)
log on
(
name='b',
filename='b.ldf',
size=初始大小，
maxsize=存储上限，
filegrowth=增长增量
)

Answer 4

CREATE DATABASE aaa