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:=@i+1);
>
> 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/
