Category Archives: mysql

Update Across Joined Tables in MySQL

I had to do a MySQL update on records that were retrieved from a two-table join today. I shouldn’t have been surprised to find that I needed a different syntax than I know from MS SQL, where I would write, … Continue reading

Posted in MS SQL, mysql, Transact SQL | Tagged , , , , | Leave a comment

Tracing MySql Transactions

Anyone who has had to troubleshoot or support systems built on a SQL Server database knows and loves the Profiler Tool, which allows you to see all of the queries submitted to a database. Web page database interaction tends to … Continue reading

Posted in Linix/Apache, mysql, php, Web Apps | Tagged , , , , , , , , | Leave a comment

Simultaneous MySQL DB Connections in PHP

I recently added a copy function to one of the web applications that I’ve developed. In addition to letting the user copy records to a new set of records in the same system, I decided to also allow them to … Continue reading

Posted in mysql, php, Web Apps | Tagged , , | Leave a comment