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 |