I gang

SQL syntax UPDATE db column values from different db column values

I have a Joomla database with all my aritcles (stories in Geeklog, content in Joomla) imported from a Geeklog database.

Joomla has a table 'jos_content' with a column (catid) that represents the content categories with int(20).

Geeklog has a table 'gl_stories' with a column (tid) that represents my stories categories with varchar(20).

The Geeklog stories have been imported into Joomla, but I left 'catid' column empty. Here is why:

What I have is this:

Geeklog.gl_stories | Joomla.jos_content

tid | catid

_______________ |___________________

topic1 | 1

topic2 | 2

topic3 | 3

How would I UPDATE jos_content catid in Joomla so that it reflected the equivalent categories as Geeklog gl_stories tid?

I already created the categories in Joomla, but the content I imported from Geeklog does not have categories assigned.

I just need the MySQL syntax to populate 'catid' values with 'tid' values as per above.

I hope this explains clearly enough what I need.

It is a minor project, so I'll pay the hourly rate.

Thank you

I need the

Evner: MySQL

Se mere: syntax, Column, sql created, mysql populate table, update database joomla, mysql update values, update values mysql, mysql sql syntax, mysql empty database, joomla table mysql, sql syntax, mysql update table, update joomla joomla, populate joomla, update joomla content database, joomla populate content, joomla populate, hourly rate mysql, joomla populate database, update joomla database, equivalent joomla, mysql update column, populate joomla database, update sql joomla, values database

Om arbejdsgiveren:
( 0 bedømmelser ) Sitka, United States

Projekt ID: #4059654

Tildelt til:


I'll have it done in one hour.

$25 USD / time
(0 bedømmelser)

3 freelancers are bidding on average $20/hour for this job


Hi, Please see your private msg TY

$20 USD / time
(14 bedømmelser)

Dear. I'm interested with your project. Do you mind to choose me? I'll do it for you. I'll wait for your choosing. Thanks.

$15 USD / time
(0 bedømmelser)