Results 1 to 3 of 3

Thread: MSSql & MySQL

  1. #1
    Join Date
    Apr 2004
    Posts
    5

    Question Unanswered: MSSql & MySQL

    Hi there,

    I am busy converting a MSSql database creation script to a MySQL database creation script.

    Everything is going reasonably well except I can't get MySQL to make the following work.

    CREATE TABLE tTasksMy (
    intTaskID int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
    vchTaskDesc text NULL
    )

    MySQL complains about the IDENTITY (1,1) bit. Anyone have any ideas ?

    Thanks

    J

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    mysql uses auto_increment instead

    read more here: 3.6.9 Using AUTO_INCREMENT
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2004
    Posts
    5
    Thanks ! -- Works like a charm!

    Originally posted by r937
    mysql uses auto_increment instead

    read more here: 3.6.9 Using AUTO_INCREMENT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •