469,964 Members | 1,499 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

script in database

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)

so i was wondering the perl script to do that
Jul 19 '05 #1
1 1748
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:9S*******************@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)

so i was wondering the perl script to do that

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by mikey_boy | last post: by
5 posts views Thread by Tim Morrison | last post: by
1 post views Thread by Tim Pascoe | last post: by
2 posts views Thread by Bobby | last post: by
5 posts views Thread by news | last post: by
1 post views Thread by Chris Zopers | last post: by
9 posts views Thread by Jerim79 | last post: by
10 posts views Thread by Jerim | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.