Help with self join - cannot get it to work (2 replies)
(MySQL.com) Hello
I need to create a self join a table.
CREATE TABLE ovp.test (
id INT NOT NULL AUTO_INCREMENT,
date DATETIME,
machine_name VARCHAR(250),
image_name VARCHAR(250),
disk_used_percentage DOUBLE(16,2) default NULL,
PRIMARY KEY (id)
);
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:15:12
