十二、异步_实践

时间：2019-04-28 14:14:57 阅读：118 评论：0 收藏：0 [点我收藏+]

一、线程实践步骤

建立数据表提供两个版本Mysql和sqlserver 两种

create database Shop 
go
use Shop
go

create table Phone
(
	Id int primary key identity(1,1),
	Phone varchar(32),
	PCount int
)


insert into Phone values(‘vivo nex‘,3)

select * from Phone


create table User_X_Phone
(
	Id int primary key identity(1,1),
	PhoneId int,
	UserId varchar(64)
)


select * from Phone
select * from User_X_Phone

truncate table Phone
truncate table User_X_Phone
insert into Phone values(‘vivo nex‘,3)

　　SqlServer版本的

create database Shop 
go
use Shop
go

CREATE TABLE Phone (
	Id int PRIMARY KEY AUTO_INCREMENT,
	Phone varchar(32),
	PCount int
)

INSERT INTO `Phone` (`Id`, `Phone`, `PCount`) VALUES (NULL, ‘vivo nex‘, ‘3‘);

select * from Phone


create table User_X_Phone
(
	Id int PRIMARY KEY AUTO_INCREMENT,
	PhoneId int,
	UserId varchar(64)
)


select * from Phone
select * from User_X_Phone

truncate table Phone
truncate table User_X_Phone
insert into Phone values(‘vivo nex‘,3)

　　MySql版本