Sql

SET @num := 0;
UPDATE your_table SET id = @num := (@num+1);
ALTER TABLE your_table AUTO_INCREMENT =1;

PREVIOUS	NEXT

Code Example
Sql :: sqlite print all column names
Sql :: postgres set user as superuser
Sql :: how to see logical reads in sql server
Sql :: set statiscis on in ssms
Sql :: get month of date sql
Sql :: sql throw error
Sql :: sql headers delphi
Sql :: postgres update column with value from another table
Sql :: select from one table where not on the other
Sql :: change default maximum runtime mariadb from phpmyadmin
Sql :: oracle list tablespaces
Sql :: encoding UTF8 has no equivalent in encoding WIN1252
Sql :: sql syntax find few columns
Sql :: mysql find foreign key references
Sql :: sql set no lmit
Sql :: postgresql make each element in array distinct
Sql :: integer limit sql create table
Sql :: oracle list dates between
Sql :: mysql return if it contains
Sql :: sqlite create index
Sql :: add created and updatedAt fields in mysql
Sql :: Sql creating roles
Sql :: set auto increment to 1 mysql
Sql :: sql server 2008 first and last day of month
Sql :: how to delete row in sql
Sql :: return insert results in POSTGRESQL
Sql :: alter table oracle
Sql :: script to add datafile to tablespace
Sql :: sql string starts with
Sql :: sql add months to date