recently when wanting to delete an entire table and reset my auto increment values. While
keeping it in a transaction.
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]> To: "'Arthur Radulescu'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: autoincrement column Date: Thu, 8 Apr 2004 12:50:58 -0700
Try truncate table. It essentially drops the table and recreates it.
-- DVP
> -----Original Message-----
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08, 2004 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: autoincrement column
>
> Before switching to version 4.0.18 of MySQL the command "delete from
> table"
> was also reseting the autonincrement column value... It seems that this is
> not happening anymore after we have installed this version...
>
> Any idee about this problem? Is there any other way to reset this?
>
>
> Arthur
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Limited-time offer: Fast, reliable MSN 9 Dial-up Internet access FREE for 2 months! http://join.msn.com/?page=dept/dialup&pgmarket=en-us&ST=1/go/onm00200361ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
