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 WHERE ...
When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present due to a duplication issue. You can use a simple alteration ...