MSSql & MySQL - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> MSSql & MySQL

Reply

Search this Thread

#1 (permalink)

Old

04-20-04, 05:50

step4tac

step4tac is offline

Registered User

Join Date: Apr 2004

Posts: 5

Question

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

Reply With Quote

#2 (permalink)

Old

04-20-04, 07:13

r937

r937 is offline

SQL Consultant

Join Date: Apr 2002

Location: Toronto, Canada

Posts: 19,524

mysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Reply With Quote

#3 (permalink)

Old

04-20-04, 08:28

step4tac

step4tac is offline

Registered User

Join Date: Apr 2004

Posts: 5

Thanks ! -- Works like a charm!

Quote:

Originally posted by r937
mysql uses auto_increment instead

read more here: 3.6.9 Using AUTO_INCREMENT

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules