469,934 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

insert into different table

E
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what
Jul 20 '05 #1
6 1771
E
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

"E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m...
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #2
E
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

"E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m...
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #3
E
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

"E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m...
I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #4
E
i didnt give enough info. i have info in a text file and have got perl to
print it out and now i want to add them to my database.
my tables look like this
Item (Id int(10) NOT NULL auto_increment, genre, title, price, quantity,
descrb, image, length, numdvd, rating, primary key is Id)
actor ( Id int(10) NOT NULL auto_increment, people_id, chara, primary key is
Id)
director (Id int(10) NOT NULL auto_increment, people_id, primary key is Id)

these represent my items from the text file. I have it to know that $title
means the tile in my text file.
$price, $image, $title, $director, $rating, $num_dvds, $length, $genre,
$$aref[0] (actor), $$aref[1] (character), $stock.
in the actor_item table: the actor matches up with what movies he is in
actor_id item_id
1 1
1 2 this shows same actor but different
movie

so how do i populate the actor_item table?
----- Original Message -----
From: "E" <ep*****@triad.rr.com>
Newsgroups: comp.lang.perl
Sent: Thursday, April 15, 2004 11:59 PM
Subject: script in database

I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

so i was wondering the perl script to do that "E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m... I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #5
E
i didnt give enough info. i have info in a text file and have got perl to
print it out and now i want to add them to my database.
my tables look like this
Item (Id int(10) NOT NULL auto_increment, genre, title, price, quantity,
descrb, image, length, numdvd, rating, primary key is Id)
actor ( Id int(10) NOT NULL auto_increment, people_id, chara, primary key is
Id)
director (Id int(10) NOT NULL auto_increment, people_id, primary key is Id)

these represent my items from the text file. I have it to know that $title
means the tile in my text file.
$price, $image, $title, $director, $rating, $num_dvds, $length, $genre,
$$aref[0] (actor), $$aref[1] (character), $stock.
in the actor_item table: the actor matches up with what movies he is in
actor_id item_id
1 1
1 2 this shows same actor but different
movie

so how do i populate the actor_item table?
----- Original Message -----
From: "E" <ep*****@triad.rr.com>
Newsgroups: comp.lang.perl
Sent: Thursday, April 15, 2004 11:59 PM
Subject: script in database

I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

so i was wondering the perl script to do that "E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m... I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #6
E
i didnt give enough info. i have info in a text file and have got perl to
print it out and now i want to add them to my database.
my tables look like this
Item (Id int(10) NOT NULL auto_increment, genre, title, price, quantity,
descrb, image, length, numdvd, rating, primary key is Id)
actor ( Id int(10) NOT NULL auto_increment, people_id, chara, primary key is
Id)
director (Id int(10) NOT NULL auto_increment, people_id, primary key is Id)

these represent my items from the text file. I have it to know that $title
means the tile in my text file.
$price, $image, $title, $director, $rating, $num_dvds, $length, $genre,
$$aref[0] (actor), $$aref[1] (character), $stock.
in the actor_item table: the actor matches up with what movies he is in
actor_id item_id
1 1
1 2 this shows same actor but different
movie

so how do i populate the actor_item table?
----- Original Message -----
From: "E" <ep*****@triad.rr.com>
Newsgroups: comp.lang.perl
Sent: Thursday, April 15, 2004 11:59 PM
Subject: script in database

I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

so i was wondering the perl script to do that "E" <ep*****@triad.rr.com> wrote in message
news:SZ*******************@twister.southeast.rr.co m... I have two tables and i want join the two of the primary id's in to one
table. the database is mysql.

ex.

Table Item (ID int(10) NOT NULL auto_increment)
Table Actor(ID int(10) NOT NULL auto_increment)

to go in to
Table actor_item(actor_id, item_id)

is it select then insert or what

Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Paul Shaw | last post: by
16 posts views Thread by robert | last post: by
6 posts views Thread by harborboy76 | last post: by
5 posts views Thread by Andrew | last post: by
9 posts views Thread by David Eades | last post: by
6 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.