Reset the auto increment value for a MySQL table

The following example changes the auto increment value for the table named "applytable" to 100. This means that the next time you insert a record into this table the value of the auto incremental primary key will be 100.

If the highest value for the column is already greater than 100 then it will be set to the highest value plus 1.

ALTER TABLE mytable AUTO_INCREMENT = 100
 
The relevent info are highlighted with red circles in the screenshot below.

Most Popular

php store array in database ?

Array can be stored in database in the form of string.we can use serialize function to make storable representation of array.we can also get back from that string to array using unserialize function.eg. <?php $arr=array("India","Pakistan","Sri Lanka","Bangladesh"); //process of serialization $newString=serialize($arr); //it will produce following output a:4:{i:0;s:5:"India";i:1;s:8:"Pakistan";i:2;s:9:"Sri Lanka";i:3;s:10:"Bangladesh";} //process of unserialization $arr=unserialize($newString); print_r($arr); //it will produce following output Array ( [0] => India [1] => Pakistan [2] => Sri Lanka [3] => Bangladesh ) ?>
Keep reading

The difference between React vs AngularJs

Image
React and AngularJs are currently using Travel and News companies. Main reason difference between AngularJs and ReactJs is AngularJS 1. AngularJs is MVC framework library. It is used for Two-way data binding. 2. AngularJs is an App development framework. ReactJS 1. React Js is a Library. It is used for One-way data binding. 2. ReactJs is an interface development framework. AngualrJs is a Javascript Framework. Where we can add HTML tags with Scrip tag. It is a Library written in Javascript. AngularJs developed by GOOGLE. AngularJs similar to Backbone or JavascriptMVC. It is a complete solution for rapid development. Following are some Features of AngularJs. 1. REST Easy: RESTful action quick communication between server to the client. 2. Extends HTML: AngularJS extends HTML with ng-directives. The ng-app directive defines an AngularJS application. The ng-model directive binds the value of HTML controls (input, select, textarea) to application data. The ng-bi...
Keep reading

PART 2 : Php Add Edit Delete Update Example for freshers

1. Use Part 1 instruction for table and database   2. Create  register.php <?php $con = mysql_connect("localhost","root",""); if (!$con){   die('Could not connect: ' . mysql_error()); } mysql_select_db("sampletest", $con); if($_GET['type'] == 'delete'){     $delquery = "delete from user where id='" . $_GET['id'] . "'";     mysql_query($delquery); }else if($_GET['type'] == 'update'){     $selquery = "select * from user where id='" . $_GET['id'] . "'";     $rsquery = mysql_query($selquery);     $arrquery = mysql_fetch_array($rsquery); } if($_POST['submitbutton'] == 'Add'){     $name= $_POST['name'];     $email= $_POST['email'];     $phone= $_POST['phone'];     $query= $_POST['query'];     $query = "insert into user (name, email, phone, query) values ('".$name."...
Keep reading