Answer / amith

In MyISAM static all the fields have fixed width. The
Dynamic MyISAM table would include fields such as TEXT,
BLOB, etc. to accommodate the data types with various
lengths.

MyISAM Static would be easier to restore in case of
corruption, since even though you might lose some data, you
know exactly where to look for the beginning of the next
record.

Give string types available for column?

0 Answers  

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

0 Answers  

---

How much does mysql cost?

0 Answers  

---

How do I declare a variable in mysql?

0 Answers  

---

Is oracle mysql free?

0 Answers  

---

Does mysql use sql?

0 Answers  

---

What are the difference between and myisam and innodb?

0 Answers  

---

How to display top 50 rows?

0 Answers  

---

What is data directory in mysql?

0 Answers  

---

What is a query in mysql?

0 Answers  

---

Is mysql easy to learn?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  

---