MySql Foreign key

[sajid salim khan]

I m a new bee in mysql i have used sql server 2000 before my question is when creating two tables in sql server 2000 say location and projects table projects having a foreign key referencing the location table when inserting values in location the projects is also updated thats is no need to insert the similar value in the foreign key in projects table why is it not possible in mysql when i insert values in location using insert command and when using select command on projects it does not shows the value in foreign key why should the value be insert in both the tables isn't it possible that when i insert in the location table the projects table pick the value automatically and show it in select result when i query the projects table

[jschell]

There is nothing it TSQL (Microsoft SQL Server "Transactional SQL") that is going to automatically insert foreign key values. You might have used some tool that created TSQL for you, but then it generated TSQL which explicitly inserted the key value.