Search
 
SCRIPT & CODE EXAMPLE
 

SQL

delete and start from 1 primary key muysql

alter table yourTableName AUTO_INCREMENT=1; 
truncate table yourTableName; 

//After doing the above two steps, you will get the primary key beginning from 1
Comment

PREVIOUS NEXT
Code Example
Sql :: Serilog Table Configurations for MSSQLSERVER SINK 
Sql :: hierarchal database table 
Sql :: edad en oracle 
Sql :: 5000/208 
Sql :: Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted 
Sql :: sql update from two different database 
Sql :: oracle 11g default profile values 
Sql :: Oracle Function execution 
Sql :: oracle execute immediate quotes 
Sql :: spfile oracle 
Sql :: mysql wait_timeout 
Sql :: create relationship with betwen two tables in postgersql 
Sql :: how to run parallel queries in sql server with entity framework 
Sql :: executescalar in sql server 
Sql :: the most common use php method 
Sql :: mysql order specific records at the top 
Sql :: database restoring error 
Sql :: how to drop check constraint in sql 
Sql :: missing index on mssql rds database 
Sql :: SQL Hello, [firstname] [lastname] 
Sql :: tsql default value when no value returned by query 
Sql :: sql insert multiple rows from another table 
Sql :: modify xml in sql server 
Sql :: mysql page segment 
Sql :: ms sql convert hijri to gregorian 
Sql :: C# check if mysql query modified rows 
Sql :: MySQL Quartiles in SQL query 
Sql :: apikey in pl sql 
Sql :: sql get frist of month 
Sql :: IN from in sql 
ADD CONTENT
Topic
Content
Source link
Name
1+8 =