SQL query to change simple table data

[smiley]

Hi there,

I can change image heights etc. in admin>configuration>images.

This makes a simple change in the configuration table of the database.

The example below changes the small image height from 90 to 70.

 

Can anyone tell me what is the SQL query to make the change in the example below using phpMyAdmin instead of the browser admin?

 

INSERT INTO `configuration` VALUES (55, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '90', 'The pixel height of small images', 4, 2, '2004-05-19 08:41:42', '2003-07-17 10:29:22', NULL, NULL);

to

INSERT INTO `configuration` VALUES (55, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '70', 'The pixel height of small images', 4, 2, '2004-05-19 08:41:42', '2003-07-17 10:29:22', NULL, NULL);

 

TIA

[ryanf]

when you go to the certain table in phpmyAdmin, you can click browse to see the stored info, then each line should have a edit and delete button. Click edit and you can change the info from there.

 

Anyway, the code will be:

update 'configuration' set configuration_value='70' where configuration_id='55'

or

update 'configuration' set configuration_value='70' where configuration_title='Small Image Height'

Ryan

[smiley]

Thanks Ryan, :D

Could you recommend where one could learn those queries and / or MySql in general.

[ryanf]

Yeah the mysql manual that is located here

 

Its got lots of good stuff. Chapter 13 is probably want you will want the most. If it's not enough there are tons of books, but I'd look online first, there are lots of free good sources.

[smiley]

Thanks again Ryan, :D

That is a bookmark.