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

How to select first div and change data of its.

Most of the time we need to select first div that time we are just thinking what need to do. But if you think it is very simple just follow below example. Any query reply this post or comments. <head>  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>  <script type="text/javascript">  //runs once page is loaded and ready to be manipulated     $(document).ready(function(){         $('.genre').first().delegate('.album-cover','click',function() {         var str = $(this).text();                str = parseInt(str) + 1;         $(this).clone().addClass('rock').appendTo('.genre:first').html(str);         });     });      </script> </head...
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