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 are string data types?
What is longblob in mysql?
What is append query?
What does mysql flush hosts do?
Why do we use mysql?
Explain the difference between mysql and mysql interfaces in php?
What is mysql community server?
Is mysql better than oracle?
What are the 5 r's of managing behaviors?
How can we change the name and data type of a column of a table?
What is truncate in mysql?
What are the advantages/disadvantages of mysql and php?
Oracle (3259)
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)