MySQL Forums
Forum List  »  Newbie

renumber primary index using VB.net
Posted by: Zeev Goldstein
Date: January 09, 2022 12:44AM

hello,
i'm new to this stuff
using VB.net i would like to renumber the primary index of a table and reset it to 1

found this code

SET @var_name = 0;
UPDATE ws_log SET linenum = (@var_name := @var_name +1);
ALTER TABLE ws_log AUTO_INCREMENT = 1

it works through Heidi
how do i implement it in VB.net?

or if there's any better way i will also appreciate it

many thanks

Options: ReplyQuote


Subject
Written By
Posted
renumber primary index using VB.net
January 09, 2022 12:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.