Where MyISAM table will be stored and also give their formats of storage?

0 Answers  

---

Is mysql distributed?

0 Answers  

---

How to determine the location of the data directory?

0 Answers  

---

What are the other commands to know the structure of a table using mysql commands except explain command?

0 Answers  

---

How to get a version of mysql?

0 Answers  

---

Explain the architecture models of SQL Server?

0 Answers  

---

What is mysql aggregate functions? Explain

0 Answers  

---

Where is the mysql data directory?

0 Answers  

---

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  

---

What are mysql functions?

0 Answers  

---

What are mysql queries?

0 Answers  

---

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

---