re: Accessing last_insert_id problem.

[Jeff Snoxell]

Hi,

I've got that sussed now and am happily using the aquired ref to subsequently play with the record etc. One other related problem and I recon I'm sorted....

How do I reset the auto-increment value?

I'm working with MySQL 3.23.36 so, according to "MySQL, Paul Dubois, New Riders" running the query:

"DELETE FROM my_table_name"

should reset it... but it doesnt'.

What SQL do I use to reset the val.

Ta,

Jeff


---------------------------------------------------------------------
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