Sql

set @autoid :=0; 
update Table_Name set AutoIncremented_Column = @autoid := (@autoid+1);
alter table Table_Name Auto_Increment = 1;

@Zenonymous

ALTER TABLE mytable CHANGE my_col my_col INT(10) UNSIGNED NOT NULL

PREVIOUS	NEXT

Code Example
Sql :: postgres user permissions
Sql :: mysql multiple order by
Sql :: sql query to select even numbers
Sql :: Write an SQL query to print details of the Workers who have joined in Feb’2014
Sql :: sql order by multiple columns
Sql :: mysql count multiple columns in one query
Sql :: mysql remove records
Sql :: query distinct
Sql :: mysql delete data in table
Sql :: sql currency format
Sql :: create temp table in sql
Sql :: sql period overlap
Sql :: get the location of where postgres database is stored
Sql :: cast datetime to date in sql
Sql :: pgsql is not permitted to log in
Sql :: delete row by id mysql
Sql :: sqlite insert or update
Sql :: mysql dump with table query
Sql :: encrypt and decrypt in sql server
Sql :: add not null constraint sql server
Sql :: function in postgresql
Sql :: Get all index postgres
Sql :: create empty table from existing table
Sql :: oracle default date format
Sql :: mysql find duplicate rows multiple columns
Sql :: SQLITE_BUSY: database is locked
Sql :: truncate table in sql
Sql :: How to find string in substring in sql server
Sql :: create foreign key postgres
Sql :: mysql function to remove multiple spaces from the string