MySQL Forums
Forum List  »  Italian

Eseguire un operazione inversa
Posted by: skizo skizo
Date: October 26, 2009 09:48AM

Ciao a tutti sono un neofita di tutto quello che riguarda il mondo di Mysql e più che saper eseguire delle query già pronte non sò fare. Utilizzo Phpmyadmin e ho installato un contributo su un carrello elettronico solo che vorrei eliminare, o meglio, fare il contrario di quello che ho fatto con questa query:

CREATE TABLE flash_carousel (
flash_carousel_id int(11) not null auto_increment,
products_id int(11) default '0' not null ,
flash_carousel_date_added datetime ,
flash_carousel_last_modified datetime ,
expires_date datetime ,
date_status_change datetime ,
status int(1) default '1' ,
PRIMARY KEY (flash_carousel_id),
KEY idx_products_id (products_id)
);


INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('39','Flash Carousel', 'Display Flash Carousel', '339', '1');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, last_modified, date_added) values ('Display Flash Carousel', 'FLASH_CAROUSEL_PRODUCTS_DISPLAY', 'true', 'If you want to use osCommerce Flash Carousel, select configuration true.', '39', '1', 'tep_cfg_select_option(array(\'true\', \'false\'),', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Display Maximum Number of Products', 'MAX_DISPLAY_FLASH_CAROUSEL_PRODUCTS', '12', 'Please enter maximum number of product to show in Flash Carousel.', '39', '2', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Flash Carousel xml/image Store Directory', 'FLASH_CAROUSEL_DIRECTORY', 'kampanya', 'Please enter directory name where osCommerce Flash Carousel addon stores files (xml, small image etc.) produced by osCommerce Flash Carousel.', '39', '3', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, last_modified, date_added) values ('Want to Resize Images?', 'FLASH_CAROUSEL_RESIZE_IMAGE', 'false', 'Do you want to resize images which Flash Carousel addon shows? Ideal image dimension 100px X 75px', '39', '4', 'tep_cfg_select_option(array(\'true\', \'false\'),', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, last_modified, date_added) values ('Flash Carousel Style', 'FLASH_CAROUSEL_STYLE', 'style_1::medium', 'Select Flash Carousel addon style that you want to use.', '39', '5', 'tep_cfg_pull_down_flash_styles(', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Flash Carousel Background Color', 'FLASH_CAROUSEL_BACKGROUND_COLOR', '#ffffff', 'You can enter background color for osCommerce Flash Carousel addon.', '39', '6', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, last_modified, date_added) values ('Want to Show Sub-category Pages?', 'FLASH_CAROUSEL_SUBDIRECTORY_SHOW', 'false', 'If you want to use osCommerce Flash Carousel in any sub-category page, select configuration true', '39', '7', 'tep_cfg_select_option(array(\'true\', \'false\'),', now(), now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('Don\'t Show Products Below', 'FLASH_CAROUSEL_MIN_PRODUCT', '0', 'If you select few products maybe osCommerce Flash Carousel can not show nicely. If you specify number of products in here, osCommerce Flash Carousel can not show products below this number (0 ineffective).', '39', '8', now(), now());


Se qualcuno può aiutarmi gliene sarei molto grato. La prima parte, quella di eliminare la tabella flah_carousel fisicamente l'ho già attuata ma non sò proprio come estrapolare il resto senza cancellare tabelle che mi servono.

Ciao

Options: ReplyQuote


Subject
Views
Written By
Posted
Eseguire un operazione inversa
6990
October 26, 2009 09:48AM
2542
October 29, 2009 12:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.