renumber primary index using VB.net
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
Subject
Written By
Posted
renumber primary index using VB.net
January 09, 2022 12:44AM
Sorry, you can't reply to this topic. It has been closed.
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.