Any ideas why this query won't write the new data?
I've been working on this query for the last couple of days and simply cannot get it to work. Any help would be greatly appreciated.
UPDATE ####_data, csv_import
SET ####_data.node = csv_import.node, ####_data.domain = csv_import.domain, ####_data.environment = csv_import.environment, ####_data.vendor = csv_import.vendor, ####_data.location = csv_import.location, ####_data.floor = csv_import.floor, ####_data.grid_ref = csv_import.grid_ref, ####_data.user_contact = csv_import.user_contact, ####_data.system_owner = csv_import.system_owner, ####_data.serial_number = csv_import.serial_number, ####_data.priority = csv_import.priority, ####_data.revision = csv_import.revision, ####_data.model = csv_import.model, ####_data.cpu_speed = csv_import.cpu_speed, ####_data.cpu_count = csv_import.cpu_count, ####_data.ram = csv_import.ram, ####_data.sysweb_ver = csv_import.sysweb_ver, ####_data.array_connected = csv_import.array_connect, ####_data.roots_home = csv_import.roots_home, ####_data.messages_present = csv_import.messages_present, ####_data.console = csv_import.console, ####_data.short_desc = csv_import.short_desc, ####_data.chassis = csv_import.chassis, ####_data.cluster = csv_import.cluster, ####_data.built_by = csv_import.built_by, ####_data.sysown_email = csv_import.sysown_email, ####_data.app_group = csv_import.app_group, ####_data.app_subgrp = csv_import.app_subgrp, ####_data.app_support = csv_import.app_support, ####_data.boot_up_time = csv_import.boot_up_time, ####_data.support_level = csv_import.support_level, ####_data.maintenance_slot = csv_import.maintenance_slot, ####_data.complexity_rating = csv_import.complexity_rating, ####_data.stability_rating = csv_import.stability_rating, ####_data.secondary_system_owner = csv_import.secondary_owner, ####_data.support_team = csv_import.support_team
WHERE ####_data.node = csv_import.node AND ####_data.domain = csv_import.domain
The output of the query is:
mysql> . c:sql_update.sql
Query OK, 0 rows affected (0.34 sec)
Rows matched: 1483 Changed: 0 Warnings: 0
Thanks.
N.