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 can we get the number of rows affected by query?

1047

---

How do I run mysql from command line?

1037

---

What does mysql_query return?

1023

---

What are mysql functions?

943

---

What's the latest version of mysql?

981

---

How do I know if mysql is installed on windows?

913

---

How do I start mysql client?

960

---

What is mysql optimization?

905

---

What is pragma serially_reusable and why is it used?

864

---

What is mysql connector used for?

941

---

How can you calculate the sum of any column of a table?

1044

---

How database are managed?

986

---

How do you backup a database in mysql?

1060

---

What is insert query in mysql?

898

---

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1002

---