how to delete a sql patch of a mod?

[giuly]

hello, many times I download mods that don't have sql uninstall, for example I have this sql install

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Linkconnector Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Linkconnector Configuration', 'Set Linkconnector Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Linkconnector Configuration';

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES
('', 'Linkconnector Account', 'LINKCONNECTOR_ID', '00001', 'Enter your Linkconnector account number', @t4, 1, NOW(), NOW(), NULL, NULL),
('', 'Merchant ID', 'MERCHANT_ID', '1', 'Enter your Linkconnector Merchant ID account number', @t4, 1, NOW(), NOW(), NULL, NULL),
('', 'Campaign ID', 'CAMPAIGN_ID', '1', 'Enter your Linkconnector Campaign ID account number', @t4, 1, NOW(), NOW(), NULL, NULL);


how can I delete it?

And when I will have another mod with only sql install?
Can you give me a guide to how create a sql uninstall file?

Please

[dw08gm]

I also would like solution to this, and also to how one determines whether an sql file has been installed.

I recently had to rebuild my shop and due to interruption have lost track of what I installed.

[giuly]

I also would like solution to this, and also to how one determines whether an sql file has been installed.

I recently had to rebuild my shop and due to interruption have lost track of what I installed.

I am agree on all

[dw08gm]

Bump

Anyone please.

[Ajeh]

More or less you have to go into phpMyAdmin and do the opposite of what the install sql did ...

If it inserts things into the database tables then you need to remove them ...

Be sure to backup your database before attempting the cleanup of something like this ...

[dw08gm]

Thanks Ajeh

I would need to know what the opposing commands are and how to use same.

eg
INSERT?
SET?
CREATE?

Can you point to a good online reference in this regard.

[kuroi]

You can find SQL Tutorials here. But this is not an area into which to go lightly. Manipulating databases is specialist stuff and while Zen Cart files can be easily replaced, data is gone forever unless you have a good backup.

[dw08gm]

Thanks Kuroi

Having baulked at the 3000-odd page Mysql user manual, this is just what I was after - a gradual introduction.