sequences or auto_increment column????

2001-07-27 Thread Siomara Pantarotto

Does anybody know which approach is better with mysql:

Create sequences for tables or an auto_increment columns???

and why???

Siomara



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: sequences or auto_increment column????

2001-07-27 Thread Dennis Salguero

I prefer to use Auto_Increment for ease of use. In addition, I don't think
that MySQL supports sequences outright (like you may be used to with
Oracle). There are some workarounds availabe within the MySQL manual, do a
search with sequences.

Good Luck,

Dennis
**
Beridney Computer Services
http://www.beridney.com

- Original Message -
From: Siomara Pantarotto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 10:04 AM
Subject: sequences or auto_increment column


 Does anybody know which approach is better with mysql:

 Create sequences for tables or an auto_increment columns???

 and why???

 Siomara



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php