Try : news_id int(11) auto_increment

-----UrsprŘngliche Nachricht-----
Von: Miguel Cruz [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 23. April 2002 5:16 PM
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Betreff: Re: [PHP] MSSQL help w/ auto_increment

Unfortunately there is a lot of variation from one RDBMS' SQL
implementation to another.

Try something like this:

create table test (
  news_id int identity,
  title varchar(50), blah blah...

miguel

> ----- Original Message -----
> From: "David Orn Johannsson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 23, 2002 10:04 AM
> Subject: [PHP] MSSQL help w/ auto_increment
>
>
> I'm having a problem wiht creating a db in MSSQL, I've only used Mysql
> be for so I tryed the syntax just the same way.
> I'm trying to execute this code:
>
> create table test
> (
>   news_id int not null auto_increment
> ,  title varchar(50) not null
> ,  ndate varchar(50) not null
> ,  headline varchar(150) not null
> ,  fullarticle text not null
> ,  lang varchar(50) not null
> ,  PRIMARY KEY(news_id))
>
> But it gives me an error on the auto_increment, which I assume is wrong
> for MSSQL, I've been searching the web for any results regarding to this
> problem of mine without any luck so I hope you can find it in your heart
> to help me if you can :)
>
> Thaks for your time
>  <http://www.atom.is/> ------------------------
> DavÝ­ Írn Jˇhannssson
> Vefforritari
> ------------------------
> Atˇmst÷­in hf.
> Gar­astrŠti 37
> 101 ReykjavÝk
> ------------------------
> sÝmi: 595-3643
> fax: 595-3649
>  <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
>  <http://www.atom.is/> http://www.atom.is
> ------------------------
>
>
>
>
>


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to