Answer / rajan vardawaj

CHAR is a fixed length data type. CHAR(n) will take n
characters of storage even if you enter less than n
characters to that column. For example, “Hello!”

will be stored as “Hello! ” in CHAR(10) column. VARCHAR is a
variable length data type. VARCHAR(n) will take only the
required storage for the actual number

of [...]

Answer / shekoli

Char is a fixed lenth datatype. Ex: char(7), welcome

but varchar is a variable length datatypes, Ex:
varchar(7),welcome (or) come

maximum database size of mysql database

2 Answers  

---

How do I show all mysql databases?

0 Answers  

---

How do I change a procedure in mysql?

0 Answers  

---

How to increment dates by 1 in mysql?

0 Answers  

---

What is the command line end user interface - mysql?

0 Answers  

---

What are Heap tables?

1 Answers  

---

What are triggers mysql?

0 Answers  

---

What is tee command in mysql?

0 Answers  

---

What is ibdata1?

0 Answers  

---

How do you change a password for an existing user via mysqladmin?

2 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  

---

What is a scalar function?

0 Answers  

---