permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes how to create sequence in mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to create sequence in mysql" Watch "how to create sequence in mysql" New topic

how to create sequence in mysql

krish bhadragiri

Joined: Apr 17, 2007
Posts: 13
please send me the syntax for creating the sequence in mysql and how that sequence be linked to different fields of different tables.
Jeff Ash

Joined: Apr 07, 2007
Posts: 11
MySQL doesn't use sequences. You will use AUTO_INCREMENT fields. The following CREATE TABLE statement shows an example:

PERSON_ID int(10) NOT NULL auto_increment,
FIRST_NAME varchar(50) default NULL,
MIDDLE_NAME varchar(50) default NULL,
LAST_NAME varchar(50) default NULL,

Then when you insert into the table just don't specify a value for the PERSON_ID:

INSERT INTO person (first_name, last_name) VALUES ('John', 'Doe')

Jeff Ash<br /><a href="" target="_blank" rel="nofollow">Excellentia Software</a>
Have you checked out Aspose?
subject: how to create sequence in mysql
It's not a secret anymore!