I’m always impressed with what you can do with MySQL (my favorite RDBMS), not long ago I needed to add a column in a table and fill it with some random values. Instead of using a PHP (could be C, … Continue reading
MaxMind offers a free cities database, the database contains more than 2.7 mil. locations, you can download it at MaxMind’s website. Once you have downloaded the compressed database, extract the file worldcitiespop.txt and invoke the MySQL client (preferably from the … Continue reading
There is the semicolon “;” that every one knows, and “g” which is just the same: mysql > SELECT * FROM wp_links; mysql > SELECT * FROM wp_linksg Those are exactly the same, and will produce the same result, here … Continue reading
What is a MySQL script file?.. Why use it? A MySQL script file (aka MySQL batch file) is a regular text file containing MySQL statements separeted by terminantors, statements in a MySQL script file can be run from the MySQL … Continue reading