Number of rows per partition in a MySQL table

You can use the  below query to get number of rows per partition in a MySQL table.

Difference between two dates in mysql

You can use MySQL's inbuilt function TIMESTAMPDIFF to get difference between two dates in MySQL. A typical query would be

Mysql Dump in XML format

To take dump in XML format you have to provide an extra option in default mysqldump command. This can be useful in cases where you want to migrate your MySQL database to some other database. You can use below command to take MySQL Database dump in XML format. or For example if you have a database …

MySQL General query logs

MySQL prints each query in General query logs. This can be helpful in application profiling if you want to see how many and which queries are being run in a transaction and when commit/rollback is executed. You can enable MySQL general query logs by running below sql command from root user: By default, logs will be stored at /var/log/query.log …

MySQL query with the conditions as ‘NOT LIKE IN’

While working with MySQL database i needed to write a query which will exclude rows where a column contains one or more words from a set of words. i.e I want to fetch data from student from table where name doesn't contain words shashank,john etc. Initially i was trying to write a query like this  : …