MySQL conditional expression CASE

MySQL conditional expression CASE MySQL CASE expression is a conditional expression that allows you to construct conditions inside a query such as SELECT or WHERE

Read more

mysql get date interval of 30 days

Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way

Read more

MYSQL Partitioning : What is and HOW To ?

The idea behind partitioning isn’t to use multiple servers but to use multiple tables instead of one table. You can

Read more

What is the best way to reduce the size of ibdata in mysql?

The busiest file in the InnoDB infrastructure is /var/lib/mysql/ibdata1 This file normally houses many classes of information (when innodb_file_per_table is 0) Table

Read more