Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command

Answer Posted / manish

create command

Ex.
CREATE TABLE mailing_group (
id int unsigned NOT NULL AUTO_INCREMENT ,
mailing_id int unsigned NOT NULL,
group_type enum('Include', 'Exclude'),
entity_table varchar(64) NOT NULL,
entity_id int unsigned NOT NULL,
PRIMARY KEY ( id ),
CONSTRAINT FK_civicrm_mailing_group_mailing_id FOREIGN
KEY (mailing_id) REFERENCES civicrm_mailing(id) ON DELETE
CASCADE
) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE
utf8_unicode_ci ;

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is definer in mysql trigger?

915


What is blob datatype in mysql?

936


What are the steps involved in query processing?

887


Explain what is mysql?

1039


What is orm in mysql?

913


How do I assign a variable in mysql?

1011


How do I show all mysql databases?

969


What do I do if I forgot my mysql root password?

902


How to delete a table.

930


What is the latest mysql?

959


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1366


What is cursor in mysql?

898


How do I clear the command in mysql?

947


What is an index? How can an index be declared in mysql?

893


How many triggers are possible in mysql?

969