You need a constraint on the data to be inserted into the second table. Care to
share what that is supposed to be?
----- Original Message -----
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated. How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field of
(I'll do this and find out after if it actually references the same
data! So, if it doesn't at least I'll have learned the proper SQL
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1