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
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
What is regex in mysql?
How to write date and time literals?
How MySQL Optimizes DISTINCT?
What is the data type for file in mysql?
What is clob datatype?
Is blocked because of many connection errors mysql?
How to determine the location of the data directory?
Write a query to fetch duplicate records from a table using mysql?
What is ndb in mysql?
What is dump in mysql?
What are the functions in mysql?
How to get the number of rows selected or affected by a sql statement?
What is mysql data directory?
How to delete an existing column in a table?