is it possible to update 2 tables simultaneously ???

A

Anonymous

Guest
Hi! i got a problem to update / insert into ..... 2 tables in MySQL

table1
studentID, studentName

table2
studentID, resultStudent

i try to update studentID in table1 and without do anything i also can update StudentID in table2 , it means that it can be generated.

i realize that in MySQL we can't define relationship between tables.
Code: 
 :roll:
 
First off...
why do you post the very same in two consecutive posts???
It creates confussion :?

The answer:
you can update two tables simultaneously
links:
MULTIPLE TRANSACTIONS MYSQL -->
http://php.weblogs.com/mysql_transactions
LOCKING TABLES -->
http://www.mysql.de/articles/ddws/61.html
http://www.canowhoopass.com/weav/wssig/mysql_lock_after.jpg

bye!
 
You must log in or register to reply here.
Back
Top