Hello!
I am new to MySQL and I have a general question related to db.
What is the usuall way developers resolve in MySQL following task.
Lets say you have a relatively complicated task which cant be done in one query (you could e.g. in Oracle using subqueries, but not in MySQL case) or using JOIN. I can use temprary table or create a table and use it for temporary needs and my concern is folowing: what will happen if two users at about the same time will run code which uses same table. As far I as have understand from documentation you can lock table for writing in that case the second user will have to wait untill first one is done. If you wont lock it - then, I assume, you can get a mess.
May be I missed something, but each ways is not seems to me to be a good choice.
I guess I am not the first one with such a problem and probably smb could give a hint what way is a \"good\" one.
Tnx in advance,
Gost
I am new to MySQL and I have a general question related to db.
What is the usuall way developers resolve in MySQL following task.
Lets say you have a relatively complicated task which cant be done in one query (you could e.g. in Oracle using subqueries, but not in MySQL case) or using JOIN. I can use temprary table or create a table and use it for temporary needs and my concern is folowing: what will happen if two users at about the same time will run code which uses same table. As far I as have understand from documentation you can lock table for writing in that case the second user will have to wait untill first one is done. If you wont lock it - then, I assume, you can get a mess.
May be I missed something, but each ways is not seems to me to be a good choice.
I guess I am not the first one with such a problem and probably smb could give a hint what way is a \"good\" one.
Tnx in advance,
Gost