Guest User

Untitled

a guest
Jan 19th, 2018
282
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. UPDATE rad SET `IDType` = '1', `XB` = '1096513935', `Name` = 'R2', `Identifier` = '3', `IDGPS` = '3', `IDSect` = '5', `Initial` = '0', `IDModif` = '99', `DateModif` = NOW() WHERE IDRad = '3'
  2.  
  3. ERROR 1242 (21000): Subquery returns more than 1 row
  4.  
  5. select * from rad where IDRad = 3;
  6.  
  7. +-------+--------+--------+-------+------+------------+------------+---------+-------------+---------------------+
  8. | IDRad | IDSect | IDType | IDGPS | Name | Identifier | XB | Initial | IDUserModif | DateModif |
  9. +-------+--------+--------+-------+------+------------+------------+---------+-------------+---------------------+
  10. | 3 | 1 | 1 | 3 | R2 | 3 | 1096513935 | 0 | 99 | 2018-01-19 01:14:01 |
  11. +-------+--------+--------+-------+------+------------+------------+---------+-------------+---------------------+
Add Comment
Please, Sign In to add comment