is it possible to update 2 tables simultaneously ???

[sarjanajava]

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: Select all

 :roll:

[Joan Garnet]

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/ ... _after.jpg

bye!

[sarjanajava]

sorry 4 that problem