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 |
In which language it is written?
What are the differences between char and varchar data types?
Why we use mysql database?
What is the maximum size of mysql database?
What is the difference between b-tree and hash indexes?
What is the use of mysql_close()?
How to decrement dates by 1 in mysql?
which version of mysql can't support stored procedure??
What does tinyint mean?
Is mariadb faster than mysql?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
What does do in mysql?