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 :: sql round 2 decimal
Sql :: sql server to uppercase
Sql :: how to drop database name in postgresql
Sql :: sql server last 2 days
Sql :: sort by mysql
Sql :: select distinct postgres
Sql :: orcale index size
Sql :: get clob size oracle
Sql :: how to add month in update sql
Sql :: alternative for LIMIT sql
Sql :: postgres 11 add primary key
Sql :: python dictionary to sql update
Sql :: mysql root permission denied lost
Sql :: mysql: command not found
Sql :: oracle insert into where
Sql :: view table mysql
Sql :: htaccess allow index
Sql :: pl sql
Sql :: rename column mysql
Sql :: to_char oracle
Sql :: sql server select another database
Sql :: sql select if not exists
Sql :: sql run multiple updates in one query
Sql :: sql select inside select
Sql :: mysql on duplicate key update get value from values
Sql :: insert into table from another table
Sql :: mysql if else
Sql :: access no password in mysql mamp
Sql :: postgres extract date from timestamp
Sql :: import mysql database command line