MySQL Forums
Forum List  »  Newbie

Any ideas why this query won't write the new data?
Posted by: Nicholas Rennie
Date: April 06, 2005 09:44AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Any ideas why this query won't write the new data?
April 06, 2005 09:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.