List:General Discussion« Previous MessageNext Message »
From:Becoming Digital Date:June 1 2003 2:53pm
Subject:Re: Inserting data?
View as plain text  
You need a constraint on the data to be inserted into the second table.  Care to
share what that is supposed to be?

Edward Dudlik
Becoming Digital
www.becomingdigital.com


----- Original Message -----
From: <trogers@stripped>
To: <mysql@stripped>
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
table2?

(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
statement. :)

Thank you,
Ted Rogers


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




Thread
indexes question(Daniel Rossi)1 Jun
  • Re: indexes questionDan Nelson1 Jun
    • Re: indexes questiondaniel1 Jun
      • Re: indexes questionDan Nelson1 Jun
  • Inserting data?trogers1 Jun
    • Re: Inserting data?Becoming Digital1 Jun
      • Re: Inserting data?trogers1 Jun
        • Re: Inserting data?Becoming Digital2 Jun
          • Re: becoming unconfusedtrogers2 Jun
            • Re: becoming unconfusedBecoming Digital2 Jun
              • Re: becoming unconfusedtrogers2 Jun
              • Re: becoming unconfusedtrogers2 Jun
          • Re: Inserting data?Nils Valentin2 Jun