Sql

SELECT setval('the_primary_key_sequence', (SELECT MAX(the_primary_key) FROM the_table)+1);

# Reset the counter of a table named yourTable to start at id # 1453
ALTER SEQUENCE yourTable_id_seq RESTART WITH 1453

PREVIOUS	NEXT

Code Example
Sql :: Triggers Syntax
Sql :: mysql multiple left joins on same table
Sql :: show broken table mysql
Sql :: create table
Sql :: pl sql command line run
Sql :: oracle drop program
Sql :: mysql select non integer values
Sql :: delete all from mysql table
Sql :: Insufficient memory to excute the sql query
Sql :: replace function in sql
Sql :: Remove duplicate old value in mysql
Sql :: find max number in sql
Sql :: mql4 sleep
Sql :: laravel subquery in from clause
Sql :: sql insert
Sql :: what is 1=2 in sql
Sql :: how to insert multiple rows in mysql using laravel
Sql :: equi join in sql
Sql :: float vs decimal sql
Sql :: inner join vs outer join
Sql :: new rails app with mysql
Sql :: mysql create database
Sql :: left join
Sql :: casterar postgres
Sql :: make a socket server to detect changes in mysql
Sql :: order child below the parent in mysqli
Sql :: can we rollback data that are deleted using delete clause?
Sql :: from UCSC MySQL database Use database hg38.
Sql :: insert statement with $1
Sql :: SQL Views for Complex Queries