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
What is definer in mysql trigger?
What is blob datatype in mysql?
What are the steps involved in query processing?
Explain what is mysql?
What is orm in mysql?
How do I assign a variable in mysql?
How do I show all mysql databases?
What do I do if I forgot my mysql root password?
How to delete a table.
What is the latest mysql?
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
What is cursor in mysql?
How do I clear the command in mysql?
What is an index? How can an index be declared in mysql?
How many triggers are possible in mysql?