Category : Database

MySQL and PHP – insert NULL rather than empty string

Normally, you add regular values to mySQL, from PHP like this: function addValues($val1, $val2) { db_open(); // just some code to open the DB...

Continue Reading →

Run Multiple query in a single Scheduled Event in MYSQL

Running a Scheduled Event in Mysql Database is pretty easy, read the tutorial from my previous article here.  From previous article we can see that...

Continue Reading →

Tutorial How to ADD Column Header in MySQL CSV Outfile

As you know from previous article, standard query used to export mysql database to an excel csv file has no column header inside. To put column...

Continue Reading →

Complete Tutorial ABOUT MySQL Scheduled Event

This post is a rewritten article posted by mysqltutorial.org in this link. i found the post is very useful and can be easily implemented. UPDATE:...

Continue Reading →

How To Produce Dynamic Filename Using MySQL OUTFILE (Example: Date)

In previous article i have introduced you how to Export MySQL Database to an Excel File using a single simple query. Many people asks how to produce...

Continue Reading →

QUERY to Export MySQL Database to an Excel File

If you already have a table and want to export it to an Excel file, then you can simply use below script and apply it as query...

Continue Reading →