Here’s a snippet of SQL code and a procedure for updating a MySQL database table using a subquery and data from Microsoft Excel (or similar). Perhaps you could adapt this solution to your own situation.
Building a Better Web - One Site at a Time.
By Jeff -
Cats: Snippets · Tags: Excel, MySQL, SQL
Here’s a snippet of SQL code and a procedure for updating a MySQL database table using a subquery and data from Microsoft Excel (or similar). Perhaps you could adapt this solution to your own situation.
Web Sites | WordPress Support | Web Applications.
Formally trained in liberal arts and education (I have a B.A. in Government from Harvard and studied Secondary Education at Rutgers Graduate School), I have honed my skills in the communication arts and sciences as a teacher, trainer, instructional designer, writer, photographer, calligrapher, helpdesk manager, database programmer, and multimedia developer.
(I've also been a group counselor, waiter, bartender, bicycle messenger boy, computer salesman, carpenter's helper, financial analyst, and school board president.)
Systems since 1983.
Web sites since 1994.
PHP since 2001.
WordPress since 2007.
Copyright 2026, nSiteful Web Builders, Inc.