Sql

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

PREVIOUS	NEXT

Code Example
Sql :: mysql create user with mysql_native_password
Sql :: uninstall mysql ubuntu 18.04
Sql :: uninstall mysql ubuntu
Sql :: postgresql remove not null constraint
Sql :: dbms_scheduler drop_job
Sql :: mysql list bigger table
Sql :: how to install mysql ubuntu
Sql :: redshift running queries
Sql :: wait delay in sql server
Sql :: SQL order random
Sql :: put line oracle
Sql :: show host mysql
Sql :: display all databases
Sql :: mysql get date diff in months
Sql :: sql add year to date
Sql :: postgresql Insufficient privilege: 7 ERROR: permission denied for table
Sql :: installer postgresql sur ubuntu
Sql :: sqlite rename column
Sql :: mysql show indexes on table
Sql :: create table oracle
Sql :: postgresql print sessions using the database
Sql :: not today mysql
Sql :: restart mysql server ubuntu
Sql :: your password does not satisfy the current policy requirements
Sql :: mysql increment value by 1 in update
Sql :: ver usuarios mysql
Sql :: mysql select table names
Sql :: Starting mysql shell lampp ubuntu
Sql :: oracle user tables
Sql :: psql count where not null