Recently i faced problem “How to upload over 100 MB mysql dump into database”. Obviously it cannot be done using phpMyAdmin, because file is to big, i could open the file and execute query after query, but it would take a lot of time, besides opening such a file is a problem by itself. So i started to search for a solution and i found wonderful solution. Continue reading Big MySQL dump import

How to select rows from MySQL table where certain field is empty is a problem i stuggled against for a while like … 10 minutes…

Continue reading MySQL Select NULL

Hey guys, i am currently finishing my degree at collage and do not have a lot of time to write as you can see. Last month was short on post and i believe that this month will also be short, although i have already long list of topics i want to write about. Anyway i managed to find some time so here something interesting i found recently. Continue reading Shorthand for MySQL JOIN