Drewser33 Posted October 30, 2009 Share Posted October 30, 2009 Table fields are DeviceID and GuardID. Existing in this table are a large number of rows with the same GuardID (49) and I would like to run an insert query to insert the same amount of rows with the same DeviceID's that will have a GuardID of 843. This is what what makes sense to us but it is not working. INSERT INTO DeviceGuard SELECT DeviceID FROM DeviceGuard WHERE GuardID = 49 , 843 Thanks Link to comment https://forums.phpfreaks.com/topic/179666-solved-cant-get-this-query-help-please/ Share on other sites More sharing options...
Mchl Posted October 30, 2009 Share Posted October 30, 2009 INSERT INTO DeviceGuard (DeviceID, GuardID) SELECT DeviceID, 843 FROM DeviceGuard WHERE GuardID = 49 Link to comment https://forums.phpfreaks.com/topic/179666-solved-cant-get-this-query-help-please/#findComment-947972 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.