Sql

SET  @num := 0;
UPDATE your_table SET id = @num := (@num+1);
/*set All previous values one by on*/

ALTER TABLE table_name AUTO_INCREMENT = start_value;

PREVIOUS	NEXT

Code Example
Sql :: sql server remove primary key without dropping table
Sql :: sql sum show 0 result
Sql :: postgresql float 2 decimal places
Sql :: FIND AVERAGE SALARY EARNER IN SQL
Sql :: tinydb add table
Sql :: dba_dependencies
Sql :: how to ascending order in sql
Sql :: createdb with postgresql on ubuntu
Sql :: mysql count characters in string
Sql :: mysql select date from datetime
Sql :: sqlalchemy empty table
Sql :: SQL COUNT() With HAVING Clause
Sql :: min max sql
Sql :: sql where time stamp is in between
Sql :: add not null constraint sql server
Sql :: alter table query sql server change column
Sql :: sql select where clause
Sql :: how to run sql server on mac
Sql :: declare value in sql
Sql :: oracle show parameter
Sql :: select last n rows mysql
Sql :: sql last time database was accessed
Sql :: if else in mysql stored procedure
Sql :: mysql timestamp vs datetime
Sql :: add week ending date sql server
Sql :: how to get specific salary in sql
Sql :: sql rename column in select query
Sql :: postgres find missing indexes
Sql :: sql default value if null
Sql :: datagrip execute procedure