Search
 
SCRIPT & CODE EXAMPLE
 

PHP

how to auto increment id after delete value in php mysql

SET @num := 0;

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

ALTER TABLE tableName AUTO_INCREMENT = 1;

/*************     OR     ***********/
ALTER TABLE table_name AUTO_INCREMENT=1 
Comment

PREVIOUS NEXT
Code Example
Php :: how check word is in sentence php 
Php :: laravel passport login with username 
Php :: in packagemanifest.php line 131 undefined index name 
Php :: Get page title, excerpt or content by Name of the Page 
Php :: Laravel Read multiple file extensions 
Php :: identify the php function used to get values submitted through a form without using any database? 
Php :: laravel gigapay resend invite to employee 
Php :: check website ssl certificate using php openssl_x509_parse 
Php :: Anzeige von Custom Post Types in den Kategorien und Tags 
Php :: How to hide Directory Browsing in WordPress from server? 
Php :: Laravel route returning error 404 when attempt is made to pass value to controller function 
Php :: laravel {{variable}} not being rendered 
Php :: Ciclo for PHP ejemplos 
Php :: IlluminateValidationRulesRequiredIf 
Php :: gerar aquivo csv php 
Php :: strtolower cyrillic 
Php :: laravel components 
Php :: how to create a modal in php 
Php :: random String Function PHP 
Php :: laravel authentication tutorial 8 
Php :: Write a php program to swap two numbers using temporary variable 
Php :: how to make a timer in php 
Php :: php time passed since date 
Java :: minecraft bedrock file location 
Java :: Java JDK 11 ubuntu 
Java :: how to get witdth of window android 
Java :: java get excectuon time 
Java :: empty character in java 
Java :: java selenium open new tab 
Java :: random.choice in java 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =