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 |
How to analyze tables with 'mysqlcheck'?
Differentiate CHAR_LENGTH and LENGTH?
What is striped backup
Why is mysql used?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is longblob in mysql?
Which is better mysql or microsoft sql?
What are the features of mysql?
What is the difference between mysql_fetch_array and mysql_fetch_object?
What is blob datatype in mysql?
Why are function needed?
What is meant by mysqli?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)