Jump to content


Photo

Modifying Many Rows in a database at one time in Phpmyadmin?


  • Please log in to reply
3 replies to this topic

#1 alexville

alexville
  • Members
  • PipPipPip
  • Advanced Member
  • 71 posts

Posted 08 April 2006 - 12:20 PM

How do I do that?

#2 IceHawk

IceHawk
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 08 April 2006 - 01:48 PM

Depending on the change you're trying to make you can simply write a query to do it and run it from inside PHPMyAdmin. If you're modifying a lot of rows, that's generally the best way to do it. If you provide more info I can help with the query if needed.
[a href="http://www.devtext.com" target="_blank"]DevText a community for all languages[/a]

#3 alexville

alexville
  • Members
  • PipPipPip
  • Advanced Member
  • 71 posts

Posted 09 April 2006 - 01:05 PM

I want to change a number in every row to 0 insted of what they have now. Does that help?

#4 IceHawk

IceHawk
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 10 April 2006 - 03:04 AM

If you're doing that to every single row in the table regardless of the columns current value then you would just need to do;
update [table] set [column] = 0
[a href="http://www.devtext.com" target="_blank"]DevText a community for all languages[/a]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users