Sql

SELECT setval(pg_get_serial_sequence('users', 'id'), coalesce(max(id)+1, 1), false) FROM users;

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

SELECT setval('tableName_id_seq', max(id)) FROM gst_codes;

PREVIOUS	NEXT

Code Example
Sql :: python pandas df to postgres json table
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
Sql :: space not removing from column in sql
Sql :: mysql current time
Sql :: SQL DEFAULT Constraint With Alter Table
Sql :: DATE_SUB postgres
Sql :: drop temp table if exists
Sql :: drop primary key oracle
Sql :: SQL Server lock table example
Sql :: remove space in sql server 2012
Sql :: postgres regular expression replace
Sql :: how to change the auto increment in existing table mysql
Sql :: sum query in sql
Sql :: postgresql create role
Sql :: Cast for print sql
Sql :: mssql check if date is greater than today
Sql :: SQL Multiple Cases
Sql :: Create table Statement Syntax in SQL Server
Sql :: mysql backup database
Sql :: launch sql script from docker in mysql
Sql :: mysql age by birthdate
Sql :: query to count the number of rows in a table in sqlalchemy
Sql :: mysql remove auto increment
Sql :: mysql count multiple columns in one query
Sql :: mysql delete data in table
Sql :: sql change data type
Sql :: sql select min row
Sql :: sql not in
Sql :: sqlite insert or update
Sql :: alter or change postgresql sequence counter