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 |
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is a storage engine?
how to Return total number of rows.
What is the usage of "i-am-a-dummy" flag in mysql?
How to increment dates by 1 in mysql?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
How to check server status with 'mysqladmin'?
How do you prevent MySQL from caching a query?
Does adding an index lock a table?
What is mysql connector used for?
What is difference between inner vs self vs cross?