evilonion Posted February 23, 2008 Share Posted February 23, 2008 hi, i am using phpmyadmin to change data in mysql database for a commerce website (creloaded) the trouble is im trying to chnage all the dates when the products were added, but this is taking ages as each one needs to be done (810 entries) is there a way that i can change the date on ALL products at once? im new to mysql and pretty much know nothing, im just starting to get the hang of phpmyadmin for chnaging bits here and there. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 23, 2008 Share Posted February 23, 2008 An UPDATE statement with an appropriate where clause? Quote Link to comment Share on other sites More sharing options...
evilonion Posted February 23, 2008 Author Share Posted February 23, 2008 forgive me for being a total numpty but how would i go about doing this? when i say im new to mysql i mean the most ive done is change the odd customer email account and details etc when needed. Quote Link to comment Share on other sites More sharing options...
PHP Monkeh Posted February 23, 2008 Share Posted February 23, 2008 You could execute this as your SQL query: UPDATE `products` SET `dateAdded` = '2008-08-28'; Depending on what you want the date changing it to change the value after the = Quote Link to comment Share on other sites More sharing options...
evilonion Posted February 23, 2008 Author Share Posted February 23, 2008 ah you legend thankyou for the quick replies. thats sorted everything out. im using creloaded but unfortunatly they dont have the best support in the world. going to get some books on mysql etc tonight so i can start learning all this for myself. thanks again, youve saved me hours of work Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.