Hi Peter, thanks a bunch,
I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: > 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 -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
