Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

is it possible to update 2 tables simultaneously ???

Codes here !

Moderators: macek, egami, gesf

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
sarjanajava
New php-forum User
New php-forum User
 
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm

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
Joan Garnet
Moderator
Moderator
 
Posts: 387
Joined: Sat Aug 03, 2002 2:56 am
Location: Mars

sorry for confusion

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

sorry 4 that problem
User avatar
sarjanajava
New php-forum User
New php-forum User
 
Posts: 41
Joined: Wed Nov 27, 2002 10:59 pm


Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 4 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.