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 is the difference between b-tree and hash indexes?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How to include character strings in sql statements?
What is datatype in mysql?
please give me the answer for this: query which generates the second highest integer in the table?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
What is cast in mysql?
How to dump a table to a file with 'mysqldump'?
How can I see mysql database?
what is database white box testing? : Mysql dba
What is the usage of ENUMs in MySQL?
How can you do the fine tunning?
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)