> > ...just realize this might get you more confused than clearing it out > for you, but what the hey. >
Thanks, your answers surely help. But I was also interested in the question how to optimize the whole process. Say: In a php script, I want to delete an employee-record passing his ID to the script. So I have to: Query 1 : Find out his "importance"-value from his ID Query 2 : Delete the record based on ID Query 3: Decrement the other's "importance"-value field I just wanted to make sure if this is the "way to do it" or if I'm missing something. Is this safe with multi user ? Would you use transactions? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
