Jump to content

Two SQL databases: Moving table fields from one to another


transparencia

Recommended Posts

Hello friends,

 

The problem is the following: I have made a partial IMDB database copy (Movie names and the year released) and want to apply it to Joomla. Joomla stores the articles information in a table called Jos_Content using a Title field, Full-text, and other fields, like alias and created_by. The IMDB database has a table called movies which have the Movie Title field and the Year field.

 

What I would like to do is to copy all the movies fields to the Joomla article title fields and the year field to the full text field.

 

IMDB database (movies table) --------» Joomla database (jos_content table)

Movie Title  --------------------------------» Article Title

Year  ----------------------------------------»  Full text field

 

What are the ways to do this?  ::)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.