Sedang Disiapkan

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

Kemahiran: MySQL

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Sitka, United States

ID Projek: #4059654

Dianugerahkan kepada:


I'll have it done in one hour.

$25 USD / jam
(0 Ulasan)

3 pekerja bebas membida secara purata $20/jam untuk pekerjaan ini


Hi, Please see your private msg TY

$20 USD / jam
(14 Ulasan)

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 / jam
(0 Ulasan)