Whats wrong with this 1

[Kdawg22]

CREATE TABLE vp_blocks(

id int( 11 ) NOT NULL auto_increment,
title varchar( 50 ) NOT NULL default '',
tag varchar( 50 ) NOT NULL default '',
location varchar( 10 ) NOT NULL default '',
ORDER int( 11 ) NOT NULL default '0',
TYPE varchar( 20 ) NOT NULL default '',
html text NOT NULL ,
FILE varchar( 250 ) NOT NULL default '',
PRIMARY KEY ( id )
) TYPE = MYISAM

I keep getting this error when I try to run that code

You have an error in your SQL syntax near 'ORDER int( 11 ) NOT NULL default '0', TYPE varchar( 20 ) NOT NULL defaul' at line 1

 

[MDXer]

If this is for SQL Server then your issue is the auto_increment. ON SQL Server use identity (1,1) you can have the seed and increment be any value you want.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[ClaireHCM]

Change to
CREATE TABLE vp_blocks(
id int identity(1,1) NOT NULL PRIMARY KEY ,
title varchar( 50 ) NOT NULL default '',
tag varchar( 50 ) NOT NULL default '',
location varchar( 10 ) NOT NULL default '',
[ORDER] int NOT NULL default '0',
TYPE varchar( 20 ) NOT NULL default '',

 text NOT NULL ,
[FILE] varchar( 250 ) NOT NULL default ''
)

1.You cant define the length for INT, it's default to be 4 bytes
2.Primary key could be defined along with the column definition
3.Some field name that you have for this table are reserved by SQL Server, should try to avoid, otherwise put it within square bracket
4.There is no auto_increment in SQL Server, you have to use identity instead