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 ;

Can we write pl sql mysql?

981

---

What happens if you no create privilege in a database?

1178

---

How can you validate emails using a single query?

950

---

How can we get total number of records by query in mysql?

958

---

Is pdo faster than mysqli?

946

---

What is a scalar function?

1038

---

How do you concatenate strings in mysql?

1044

---

Can I use mariadb instead of mysql?

974

---

What is new mysqli?

971

---

What is the use of mysqli_num_rows?

959

---

Can we store images in mysql database?

946

---

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1146

---

How to create trigger in mysql workbench?

1032

---

What are the disadvantages of stored procedures?

1020

---

What is the return type of mysqli_query?

917

---