is it possible to update 2 tables simultaneously ???

Codes here !

Moderators: macek, egami, gesf

User avatar
sarjanajava
New php-forum User
New php-forum User
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm
Contact:

is it possible to update 2 tables simultaneously ???

Postby sarjanajava » Sun Feb 23, 2003 8:26 am

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:

User avatar
Joan Garnet
Moderator
Moderator
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars
Contact:

Postby Joan Garnet » Sun Feb 23, 2003 1:03 pm

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!

User avatar
sarjanajava
New php-forum User
New php-forum User
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm
Contact:

sorry for confusion

Postby sarjanajava » Fri Feb 28, 2003 10:13 am

sorry 4 that problem


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 2 guests