MySQL Forums
Forum List  »  Newbie

Re: 0 rows effected with UPDATE Query
Posted by: Jay Mackey
Date: February 17, 2018 10:29AM

Peter, here are the results(wish I could use an attachment)

| Table | Create Table | sensorconfig |
CREATE TABLE 'sensorconfig' ('SCID' int(11) NOT NULL AUTO_INCREMENT,
'Mpw' varchar(20) DEFAULT NULL,
'Status' varchar(10) DEFAULT NULL,
'Location' varchar(10) DEFAULT NULL,
'UID' int(11) DEFAULT NULL,
'SID' int(11) DEFAULT NULL,
'Date' date NOT NULL,
'Sensors' varchar(10) DEFAULT NULL,
'DelayTime' varchar(10) DEFAULT NULL,
PRIMARY KEY ('SCID'),
KEY 'UID' ('UID'),
KEY 'SID' ('SID'),
CONSTRAINT 'sensorconfig_ibfk_1' FOREIGN KEY ('UID') REFERENCES 'users' ('UID'),
CONSTRAINT 'sensorconfig_ibfk_2' FOREIGN KEY ('SID') REFERENCES 'sensors' ('SID'),
) ENGINE=InnoDB AUTO-INCREMENT=17 DEFAULT CHARSET=utf8 |

Options: ReplyQuote


Subject
Written By
Posted
February 14, 2018 11:11PM
Re: 0 rows effected with UPDATE Query
February 17, 2018 10:29AM


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.