We are developing a VB6 application that uses MySQL as it's database. The tables are InnoDB. <BR><BR>How do we check to see if a record/table is locked before we do a <BR>SELECT * FROM tablename ...

Stored procedures provide PHP programmers with pre-programmed database applications that retrieve and edit MySQL records. Stored procedures let you send parameters to the database program ...