uninstalling SQL files?

[Sid04]

I installed a SQL file with the following lines into my database:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Use scrolling marquee?', 'SCROLL_MARQUEE', 'true', 'Use scrolling marquee?', 1, 83, now(), now(), '', 'tep_cfg_select_option(array(\'false\', \'true\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Text to display', 'TEXT_TO_DISPLAY', 'Put something in here" Camera backpack in stock for $199.00!!', 'Text to display in scroll area', 1, 84, now(), now(), '', '');

 

What would I need to change in the SQL file to be able to run it again and REMOVE what was entered from running the above?

 

Thanks!

[ozcsys]

I installed a SQL file with the following lines into my database:

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Use scrolling marquee?', 'SCROLL_MARQUEE', 'true', 'Use scrolling marquee?', 1, 83, now(), now(), '', 'tep_cfg_select_option(array(\'false\', \'true\'),');
INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('Text to display', 'TEXT_TO_DISPLAY', 'Put something in here" Camera backpack in stock for $199.00!!', 'Text to display in scroll area', 1, 84, now(), now(), '', '');

 

What would I need to change in the SQL file to be able to run it again and REMOVE what was entered from running the above?

 

Thanks!

 

Did you backup your database before making the changes? If so then just do a restore from the backup. If not you can access the database via phpmyadmin or whatever program your hosting company provides and delete the fields that were added.

[Sid04]

is there something that I can replace the "INSERT INTO" with in the SQL file and re-run it to remove the stuff from the dB?

[Jan Zonjee]

is there something that I can replace the "INSERT INTO" with in the SQL file and re-run it to remove the stuff from the dB?

My educated guess is:

delete from table configuration where configuration_key = 'SCROLL_MARQUEE';

Confirm this by doing first:

 select * from configuration where where configuration_key = 'SCROLL_MARQUEE';

If you got only one row and it is the one you want to get rid of, then proceed with the delete.