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 ;

How do I tune a mysql query?

831

---

What is sharding in mysql?

917

---

How to get data from mysql in php?

848

---

How to insert html code into mysql database using php?

1002

---

What is mysql uuid?

886

---

How can you handle the –secure-file-priv in mysql?

891

---

How do I stop a mysql service?

955

---

How do I delete a row in mysql?

896

---

What is a user defined variable?

852

---

Is mysql good for big data?

891

---

What is myisamchk?

914

---

What is mysqli_select_db?

918

---

What is the difference between the LIKE and REGEXP operators?

984

---

How can I create a database in mysql?

812

---

How to store values to array from mysql database in php?

881

---