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 do you understand by mysql terminal?
How do I quit mysql?
How to return query output in xml format?
If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is data type for image in mysql?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What you can use regular expression for in mysql?
What is prepared statement in mysql?
Do you need a license for mysql?
What is mysql optimization?
How to dump one database for backup.