create command Ex. CREATE TABLE mailing

Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command

Question Posted / manish

5 Answers
9436 Views
Amdocs, MediaSoft, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is primary key auto increment?

946

What is row level locking?

924

How to insert dynamic values in mysql using php?

1137

List some comparisons operators used in mysql?

987

How database are managed?

990

How do I add a column to a table in mysql?

915

How much does mysql enterprise cost?

922

How to use sum function in where clause in mysql?

964

What is back end and front end?

905

What is the difference between now() and current_date()?

982

Explain timestamp?

968

Explain what is mysql?

1035

What is the difference between primary key and candidate key?

1018

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1022

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

970