Foreign Keys to AUTO receive referenced Primary Keys in MySQL.. Is it possible?
Hi there... I just registered here since I found all the answers from the users here to be quite helpful, this seems like a great place to get help (hard to find..)
I have a minor problem with MySQL: I want to be able to construct my database so that the Foreign Key automatically receive the Primary Key value when I add new data to my database. This is for different projects but I'll use my personal CD-database as an example...
Lets say I add a cd to the DB, it will get an ID(int) and according to what type of cd it is (game, movie, app, series) I want to add more information to the appropriate table (game, movie, app, series).
I can figure out how to do this with PHP variables but isn't there a way that I can build my DB in such a way that that won't be necessary? At school I use Sybase PowerBuilder which has this function in a nice GUI :P but they never tought us how to do this in script/sql..
So if someone could help me I'd be very greatful. (Also building a PHP/MySQL intranet site for a company now as a school project, and this would come in handy for that as well..)
Re: Foreign Keys to AUTO receive referenced Primary Keys in MySQL.. Is it possible?
I don't think this is possible because MySQL does not support relationships between tables. You will have to make use of a programming language (PHP) to do this.
Originally posted by snek_one
I can figure out how to do this with PHP variables but isn't there a way that I can build my DB in such a way that that won't be necessary?