Tag Archives: mysql

Updating Multiple Rows in MySQL

There comes a time when you need to update multiple rows with different values. You can update multiple rows with the same value, but when dealing with different values for different rows, it becomes a difficult task. Yes there are … Continue reading

Posted in Database, MySQL, SQL | Tagged , , , , , , , | Leave a comment

MySQL Backup Strategy

The Story A few months ago, while at home, my supervisor called me. The incident was that our client’s QR System stops working on a certain module. I learn that the possible cause was a table corruption, so the the … Continue reading

Posted in Database, MySQL | Tagged , , , , , , , | Leave a comment

MySQL Query – No Quote For String Fields

One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record on the database. It was originally built on MyISAM table … Continue reading

Posted in Database | Tagged , , , , , , | Leave a comment

MySQLDump In Many Many Ways

Again, there is another need to blog this thing. I encountered this situations where dumping the database using default options does not fit the purpose, so today, we will be playing with mysqldump options for making MySQL backup. Simple Backup … Continue reading

Posted in MySQL | Tagged , | 2 Comments

Importing Huge CSV File to MySQL via PHP

Yes there are several techniques to import CSV to MySQL. I have encountered this task several times already the those previous experiences worked out seamlessly, but this one is a bit complicated and requires a lot of effort in order … Continue reading

Posted in Linux, MySQL, php | Tagged , , , , , | 3 Comments

The way I discovered PHP

I was a VB programmer for 3 years. That was almost two years ago. My obsession was on OpenSource softwares. My first open source software used was SuSE Linux Live Eval 9.1. Then eventually, I installed the SuSE Linux Personal … Continue reading

Posted in Personal Blog | Tagged , , , | Leave a comment