Question

sqlserver 建表语句：create table tb_user(uid int primary key,name varchar(20)) Mysql怎么写。详细点哈

Answer 1

create table tb_user
(uid int,
name varchar(20)
)

alter table tb_user
add constraint 主键名
primary key(uid)

Answer 2

use 数据库名
if exists ( select *
from sysobjects
where name = ' tb_user'
and type = 'U')
drop table tb_user
go
create table tb_user
(uid int primary key,
name char(20))

Answer 3

create table tb_user(uid int(10) not null auto_increment primary key,
name varchar(20)) engine = myisam defualt charset=utf8

Answer 4

MYSQL建表语句：
create table tb_user(uid int(10) not null auto_increment primary key,
name varchar(20)) engine = myisam defualt charset=utf8;

Answer 5

create table 数据库名
（
uid int primary key，
uname varchar（20）not null
）