Personnaly, i have found autoincrement fields to be rock solid.
I use'em all over the place on a 1 Gb database, web based.
Don't do it manually . You'll end up doing the same thing
that mysql gives you for free.
Christopher Lambrou,
CGL Computer Services, Inc.
Empire State Building,
PMB 16J Suite 3304
New York, NY 10118
Tel: (212) 971-9723
Fax: (212) 564-1135
URL: http://www.cglcomputer.com
Email: [EMAIL PROTECTED]
On 5/3/2001 15:57:38, you said:
>Hello!
>I have a database with about 10 tables in it. In every table I have a
>RECORD_ID
>field so that I can at least uniquely identify a row if I need to, also its
>used in relationships. The question is should I use the AUTO_INCREMENT for
>this, or should I manually generate this value, getting the next highest
>number, then putting it in there. Is there any known replication problems if
>I use AUTO_INCREMENT??? Would I be safer in just doing this manually myself
>in my code?? This is going to be a web-based app, so many users will be
>using the db at the same time.
>Thanks!
>
>Patrick
>
>---------------------------------------------------------------------
>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
>
>
---------------------------------------------------------------------
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
