[SOLVED] How can i...

[wwfc_barmy_army]

Hello.

 

I'm a noob when it comes to MySQL. But i'm in phpMyAdmin and i've got a field in a table (news_limit) and i want to change the value in that to 2 for all of them, but theres 50 of them. What command would i use? I think i have to use the amend command.

 

Thanks. 

[obsidian]

Open up your SQL window and just do something like this:

UPDATE news_limit SET colname = 2;

 

When you do an update with no WHERE clause, it will update every record.

[wwfc_barmy_army]

i need to add something else to that, it's in the newsfeeds table. And the MySQL command it trying to find it in the database and not the table newsfeeds. So it goes databasename -> newsfeeds -> news_limit (column)

 

Thanks for any help

 

 

[Wildbug]

USE databasename;
UPDATE newsfeeds SET news_limit=2;

[wwfc_barmy_army]

Thanks Guys