List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 24 2001 4:16am
Subject:Re: newbie needs help please
View as plain text  
At 11:07 PM -0500 7/23/01, Kit Kerbel wrote:
>Is the foreign key functional is the newest version of Mysql?  If so, how does

Not according to the MySQL manual:

http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html

>it work.  Also, how would I go about synchronizing an auto_increment 
>field from one table with another table which need to correspond to 
>the first.  One

use SELECT LAST_INSERT_ID() to get the most recent AUTO_INCREMENT value:

http://www.mysql.com/doc/M/i/Miscellaneous_functions.html

>table is for example the User table used for logging in...the other 
>is a Roster table used to hold class rosters.  I need the ID to 
>correlate with each other in both tables.  The User table is 
>autoincrement for ID.
>Thanks.
>Kit


-- 
Paul DuBois, paul@stripped
Thread
newbie needs help pleaseKit Kerbel24 Jul
  • Re: newbie needs help pleasePaul DuBois24 Jul