How to login in MYSQL through window command line?
Run > CMD cd c:\xampp\mysql\bin mysql.exe -u root
Most Popular
Random post generate in wordpress
You have to first know default args of wordpress <?php $args = array( 'numberposts' => 5 , 'offset' => 0 , 'category' => , 'orderby' => 'post_date' , 'order' => 'DESC' , 'include' => , 'exclude' => , 'meta_key' => , 'meta_value' =...
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.