Geocoding, MySQL | June 30, 2009

Professional GeoCoding Service

If you have more than a couple thousand records you want to geocode all at once we found a great service from USC’s GIS department that allows you to geocode records in an Access database.  It’s not terribly fast but we were able to geocode nearly 200,000 records in a couple of days. Just make sure your computer isn’t set to go to sleep an hour after you step away from the computer…. :/

https://webgis.usc.edu/Default.aspx

MySQL |

Deleting from multiple tables in mySQL

DELETE users.*, profiles.*
FROM users u, profiles prof
WHERE u.id = prof.user_id
AND u.created < '2009-01-01'

MySQL | June 3, 2009

Finding and Clearing Orphans

DELETE orphan_table FROM orphan_table
LEFT JOIN user_table
ON orphan_table.user_id = user_table.id
WHERE user_table.id IS NULL;

Buy clomid online
Buy zovirax online
Buy cipro online
Buy nexium online
Buy diflucan online
Buy lasix online
Buy neurontin online
Buy synthroid online
Buy flagyl online
Buy nolvadex online

American Crime full movie The Deer Hunter download movie Practical Magic download movie The Great Escape download movie Empire of the Sun download movie Austin Powers: International Man of Mystery download movie Charlie Bubbles download movie The Deer Hunter download movie Practical Magic download movie The Great Escape download movie Empire of the Sun download movie Austin Powers: International Man of Mystery download movie Charlie Bubbles download movie