| Return to iWEBTOOL |
| |
|
| |||||||
 | Welcome to iWEBTOOL Talk, where you talk about
webmaster-related stuff.
1 Register
2 Browse the board
3 Discuss whatever may interest you! | |||||||||||||
 |
| | Thread Tools | Search this Thread | Display Modes |
05-06-2007, 08:51 PM
| #1 |
| Member Join Date: Dec 2006 Location: cage-fights.com
Posts: 195
 |  Changing multiple Table entries? I have over 2000 products listed in my database (MySql) I have to change an option in my table for all the products from 0 to 1. How can I do all of them at one time? I can't seem to find an option to do this in phpMyAdmin. Thanks for the help! |
|
|
| |||||||
|
05-06-2007, 09:56 PM
| #2 |
| Member  Join Date: May 2007
Posts: 125
| Re: Changing multiple Table entries? you can use sql query update table_name set field_name=1 
__________________ |
|
|
|
05-06-2007, 10:07 PM
| #3 | |
| Member Join Date: Dec 2006 Location: cage-fights.com
Posts: 195
| Re: Changing multiple Table entries? Thanks a million! Just ran it and am done. Worked awesome. Quote:
| |
|
|
| (Threads which have no activity for more than 30 days are automatically closed.) |
| Quick Reply | ||
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What do you think how Google PR DB table looks like? | 123_free_links | 10 | 04-30-2007 03:52 PM | |
| Info.Vilesilencer.com not accepting new entries | Alan | Directories | 3 | 04-21-2007 04:04 PM |
| recipe site with 7000 entries | edpudol | Websites for Sale | 0 | 02-11-2007 03:23 PM |
| Table within a table | jumpenjuhosaphat | PHP | 5 | 08-05-2006 11:20 PM |
| New table builder web tool 3w.ezer.com | 123_free_links | Website Reviews | 4 | 06-26-2006 11:26 AM |
Linear Mode
