sql query - mySQL

Hi there

can anyone tell me what the syntax of the query is when creating a table and you want a sequential, ascending identifier as one column?

This is somehthing like the identity property in SQLServer, but i want to implement this in MySQL..

any help appreciated, cheers,

[316 byte] By [Shellers] at [2007-9-26 7:05:09]

«« Where can I find a class providing text editor and which isn't swing based
»» soccer animation using java2D

# 1

If you have already downloaded mySQL, look in the documentation. There is a huge HTML file that explains their implementation of SQL. Oh never mind, I'll do it for you... it's under the heading 1.4.1 MySQL Extensions to ANSI SQL92, where it mentions the field attribute AUTO_INCREMENT.

DrClap at 2007-7-1 16:44:08 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

I may as well say thank you, but i might get sarcasim for that too....

Shellers at 2007-7-1 16:44:08 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

sql query - mySQL

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified