Be a Supporter!

MySql Database Help

  • 306 Views
  • 1 Reply
New Topic Respond to this Topic
« Return to Programming Forum Forum Index
SimonTomlinson
SimonTomlinson
  • Member since: Jun. 23, 2005
  • Offline.
Forum Stats
Member
Level 01
Blank Slate
MySql Database Help 2005-06-23 21:38:08 Reply

I want to add data to a single column on mysql which effects online ID numbers 1 to 500. I don't want it to effect any other part of the database. What's the command to do this?

Pilot-Doofy
Pilot-Doofy
  • Member since: Sep. 13, 2003
  • Offline.
Forum Stats
Member
Level 37
Musician
Response to MySql Database Help 2005-06-23 21:57:25 Reply

UPDATE table SET field = 'value' WHERE id <= 500