after reading the MySQL manual it would seem that most of the time, locking a table is not required cause it already does it automatically. is this true? if i have an app that does simple INSERTs, do i need to lock the table to ensure no problems, or will MySQL take care of itself if it happens to get 2 INSERTS for the same table at once? now, if it turns out that it's not required, is it a good idea to do it anyway? and a final question, what's a good book on databse design? thanks
airyk
airyk