Hi, I keep getting error 1100 (table [table name(s) was not locked with LOCK TABLES) but I am definitely locking them with LOCK TABLES...
here's examples of what i'm doing... i have 2 tables i'm trying to work with...jobs and mechanics i do "lock tables jobs read" everything seemed ok so then i do "lock tables mechanics read" again no errors so i guess it worked..now i'm expecting to have my 2 tables locked for read only. No I would try to query them with a JOIN but i keep getting the error so I tried querying each table indiviually but i still get the error: "select * from jobs,mechanics where jobs.mech_id=mechanics.mech_id and status!='completed'" error 1100 "select * from jobs" error 1100 "select * from mechanics" error 1100 "unlock tables" "select * from jobs,mechanics where jobs.mech_id=mechanics.mech_id and status!='completed'" SUCCESS! "select * from jobs" SUCCESS! "select * from mechanics" SUCCESS AGAIN! i have also tried locking the tables with: "lock tables jobs mechanics read" which seems to execute ok, but again when i try to query the tables i get error 1100. does all this indicate a bug in MySQL or am i doing something stupid? thanks for your help --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
