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 the difference between a heap table and temporary table?
What is procedure in mysql?
What is mysql default database?
How do you use auto increment?
What are the functions used to encrypt and decrypt the data present in mysql?
Can you tell a way to know the number of days between the two given dates in php?
What is user in mysql?
Can't connect mysql server on localhost?
What do we use to remove duplicate records while fetching a data in mysql ?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
How do I download a mysql community server?
How to shut down the server with 'mysqladmin'?
What are the advantages of a procedure?
How do I start and stop mysql server?
What is datadir?