Submit My Question - Recent Questions - Recent Answer

Msdn China Tech >> PowerBuilder >> 基础类

如何写sql在mysql中,一个字段(int)自动加1,用create table回复马上给分.

如何写sql在mysql中,一个字段(int)自动加1,用create table回复马上给分.

[54 byte] By [wel_comes] at [2007-12-13]

«« 为什么程序老这么慢,急!
»» 这里还有 99分,,大家快来

# 1

create table tablename(
columnname int identity...);

lmby-鹿门布衣 at 2007-10-27 >

top of Msdn China Tech,PowerBuilder,基础类...

# 2

CREATE TABLE dbo.c1
(c1 char(13) NOT NULL,
xuhao int IDENTITY NOT NULL
, CONSTRAINT p_c1
PRIMARY KEY NONCLUSTERED
(c1));

flymeng-lj at 2007-10-27 >

top of Msdn China Tech,PowerBuilder,基础类...

# 3

identity...是什么意思,
identity(1,1) 不好用.

create table tablename( id int(11) not null primary key identity(1,1));不好用.

wel_comes at 2007-10-27 >

top of Msdn China Tech,PowerBuilder,基础类...

PowerBuilder Hot Topic

PowerBuilder New Topic