We sometimes need next auto increment value in a mysql table for various purposes. It can be achieved through querying INFORMATION_SCHEMA database.
mysqldump is a database backup program used to create copy of database or collection databases. When you run mysqldump, it will prompt you for password, on valid password it will create backup copy of the database in given path.
MySQL doesn't have any built in function to count number of occurrences in a string, so we need bit of tweak in our query to achieve make this work.
In MySQL, length and char_length functions are used to find number of characters present in string. So which one is best to use and how it differs?
This is one of the great feature available in MySQL from version 4.1, but most of us forgotten this feature or reluctant to use.
MySQL has various log system that can help a user to debug and improve query performance. So find out how to list last executed queries in MySQL.