Update MySQL table using subquery, Excel data

Import Data From Excel

If you’re a developer like me who builds custom database-driven Web sites and Web applications, you don’t necessarily create a user-maintainable content management system (CMS) for absolutely everything you build. In this article, I’m going to show you a simple and practical low-tech solution for adding content from your clients for database-driven content for which you did not build a CMS. The only tools you need for this solution are Microsoft Excel and SQL (in my case, the MySQL flavor).
Ok. I’m hooked… let me read the full article →