Nils,
>So the task is to recreate the current primary key (c_serial),so that the >current index would start with 1,2,3,4,....
SET @i=0; UPDATE c1 SET c_serial=(@i:[EMAIL PROTECTED]);
PB
-----
Nils Valentin wrote:
Hi MySQL fans ;-),
I was just asked recently with the task to recreate a tables index "gracefully" on a MyIsam table.
This is the table layout: ---- CREATE TABLE `cl` ( `c_serial` int(11) NOT NULL auto_increment, `cname` tinytext NOT NULL, `cl_vals` text NOT NULL, `utime` int(11) NOT NULL default '0', PRIMARY KEY (`c_serial`) ) TYPE=MyISAM ----
So the task is to recreate the current primary key (c_serial),so that the current index would start with 1,2,3,4,....
Currently the numbers are all over the place. To make this simple (for now) there are no dependencies to other tables so the order of the index doesnt really matter, its more for the admins peace of mind ;-)
I tried the obvious first, removing the column completely and adding the primary key, which left me with a lot of "0"s - which is not what I had in mind ;-).
I know this shouldnt be too difficult, but perhaps I am just too long in front of the screen. ;-)
Best regards
Nils Valentin Tokyo / Japan
www.be-known-online.com
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.5 - Release Date: 4/7/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
