You can use the below query to get number of rows per partition in a MySQL table.
mysql
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 … Continue reading Mysql Dump in XML format
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 … Continue reading MySQL General query logs
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 : … Continue reading MySQL query with the conditions as ‘NOT LIKE IN’