Monthly Archives: December 2008

Format of Numerical Values Matters to Your MySQL Database

Posted on December 20, 2008 by LizzyFin

In using databases we tend to move around a lot of data. So much data, in fact, that it’s impossible to verify every single datum in a manual way. What we can and should do is verify that the beginning, … Continue reading →

Posted in mysql, php | Leave a comment

How to Import a Data File into MySQL via phpMyAdmin

Posted on December 19, 2008 by LizzyFin

Sometimes we have a need to read data into an existing database. Knowing how to import a data file into an established table can save you a lot of time. First, we’ll be working with MySQL and to make things … Continue reading →

Posted in mysql, php | 7 Comments

MySQL LOAD FILE Statement Rescues Huge Database File

Posted on December 17, 2008 by LizzyFin

A client needed to use an existing database, which turned out to be a big gargantuan thing, but to be able work with it on the Web I needed to convert it from MS Access to MySQL. Instead of trying … Continue reading →

Posted in mysql | 1 Comment