Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;
Comment

mysql reset auto increment to 1

ALTER TABLE tablename AUTO_INCREMENT = 1
Comment

mysql reset auto increment id

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;
Comment

reset auto increment mysql

ALTER SEQUENCE users_id_seq RESTART WITH 1;
#				|     |
#            TABLE  COLUMN
Comment

reset auto increment in mysql

ALTER TABLE t1 AUTO_INCREMENT = 13;
Comment

how to reset mysql table auto_increment

Reset ID counter in MySQL
Comment

PREVIOUS NEXT
Code Example
Sql :: drop all database tables oracle sql developer 
Sql :: t SQl Checking Your Username 
Sql :: sql insert query 
Sql :: create sqlite database in laravel 
Sql :: Oracle NLS_CHARACTERSET 
Sql :: transalations from sql to Linq count and group by 
Sql :: get first n letter of department name in sql 
Sql :: add timestamp column to existing table ms sql server 
Sql :: mysql number format 
Sql :: strict in postgres SQL 
Sql :: mysql sysdate - 1 day 
Sql :: MSSQL SYNTAX PROCEDURE FUNCTION TRIGGER 
Sql :: sql empty table 
Sql :: how to get table current identity value in sql server 
Sql :: reset identity column values in sql server 
Sql :: SELECT NUMBER OF rows for all tables oracle 
Sql :: mysql backup skip table 
Sql :: mysql db size 
Sql :: sql like 
Sql :: SQL SERVER SELECT BETWEEN DATETIME 
Sql :: how to alter table column name in mysql 
Sql :: To change the database owner in SQL server 
Sql :: postgresql list users 
Sql :: linebreak sql 
Sql :: query saurce oracle 
Sql :: insert data from another table 
Sql :: begin transaction in sql 
Sql :: sql where first letter 
Sql :: sql view where tables have same column name combine results 
Sql :: calculate distance between two latitude longitude points sql 
ADD CONTENT
Topic
Content
Source link
Name
4+5 =