Želim skopirati del podatkov iz ene MySQL tabele v drugo, rad bi dodal pogoj, v kateremu določim id-je vrstic v obeh tabelah, ki ju želim upariti.
Tukaj je osnovna poizvedba:
INSERT INTO `yuoht_ucm_content` (
`core_body`,
`core_created_user_id`,
`core_created_by_alias`,
`core_created_time`,
`core_modified_user_id`,
`core_modified_time`,
`core_publish_up`,
`core_publish_down`,
`core_images`,
`core_urls`,
`core_metakey`,
`core_metadesc`,
`core_metadata`
)
SELECT
`introtext` AS `core_body`,
`created_by` AS `core_created_user_id`,
`created_by_alias` AS `core_created_by_alias`,
`created` AS `core_created_time`,
`modified_by` AS `core_modified_user_id`,
`modified` AS `core_modified_time`,
`publish_UP` AS `core_publish_up`,
`publish_down` AS `core_publish_down`,
`images` AS `core_images`,
`urls` AS `core_urls`,
`metakey` AS `core_metakey`,
`metadesc` AS `core_metadesc`,
`metadata` AS `core_metadata`
FROM `yuoht_content`
Rad bi dodal še pogoj, nekaj v stilu:
WHERE `yuoht_content`.`id` = 172 AND `yuoht_ucm_content`.`core_content_id` = '2'
Torej hočem, da se skopirajo podatki iz tabele yuohtcontent iz vrstice z id-jem 172 v tabelo yuohtucm_content v vrstico z id-jem 2.
Pa mi nekako ne rata sestaviti delujoče poizvedbe s pogojem.