Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the difference between primary key and candidate key?
In which language it is written?
What is mysql architecture?
How do I restore a mysql database?
How do you connect MySQL database with PHP?
What is mysql_pconnect?
What does mysqli stand for?
Why to use char instead of varchar in the database?
How to Set a root password if there is on root password.
What does blob mean in mysql?
What are features of mysql?
what if you really want to store the timestamp data, such as the publication date of the article?