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 ;

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

777

---

How to find second highest salary from a table?

720

---

What are the types of queries?

670

---

How many triggers are possible in mysql?

725

---

How do I create a stored procedure in mysql?

660

---

What is 'mysqladmin' in mysql?

729

---

How to convert character strings to dates?

720

---

What is mysql workbench used for?

719

---

Is mysql written in c?

651

---

How do we use % when performing a search query?

698

---

Is mysql free for enterprise?

666

---

What is dblink?

658

---

how can you test for null values in a database? : Mysql dba

672

---

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

698

---

What are stored procedures and functions?

654

---