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 ;

What is the use of mysqli_num_rows?

868

---

What is save point in mysql?

898

---

Explain the different types of mysql joins.

852

---

What are the ways in which you can retrieve data in the result set of mysql using php?

915

---

How do I run mysql?

918

---

How to create table with same structure of student table in mysql?

896

---

What is pragma exception?

907

---

Why is it called mysql?

857

---

How can you export the table as an xml file in mysql?

840

---

How do I clear the command in mysql?

891

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1854

---

What are the functions in mysql?

890

---

What is the use of i-am-a-dummy flag in mysql?

950

---

Why do gaps in sequences occur?

892

---

How MySQL Optimizes DISTINCT?

1040

---