PDA

View Full Version : Querry Code Fix!


Replicators
2-28-06, 02:14 AM
I have installed a mod, which won't allow me to uninstall for some reason, so i have to try and remove stuff from the database manually but having trouble formatting the MYSQL command properly. If any of you are good at MYSQL and could help me get tghis right i would be most gratefull.

DROP FROM `sf_datastore`
(`title`, `data`)
VALUES
('rpg_alignments', ''),
('rpg_battlemusic', ''),
('rpg_categories', ''),
('rpg_classes', ''),
('rpg_clans', ''),
('rpg_elements', ''),
('rpg_genders', ''),
('rpg_ibots', ''),
('rpg_items', ''),
('rpg_races', ''),
('rpg_scenes', ''),
('rpg_types', '');

I know i must of formatted it wrong (Obviously as it don't work)

mitchind
2-28-06, 12:43 PM
Are you on Powweb - if so, just use phpmyadmin - you can DROP (delete) tables or EMPTY them (delete all rows)

I'm not clear from your message as to what you're try to do. Do you want to delete the table or delete all rows in the table.

See the MySQL manual for these very simple commands
http://dev.mysql.com/doc/refman/4.1/en/drop-table.html
http://dev.mysql.com/doc/refman/4.1/en/delete.html