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

Is sql similar to mysql?

0 Answers  

---

How many columns is too many mysql?

0 Answers  

---

I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,

---

Does insert statement lock the table?

0 Answers  

---

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

2 Answers   SigmaTree,

---

How can you see all indexes defined for a table?

0 Answers  

---

What is mysql good for?

0 Answers  

---

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

---

What is pdo :: fetch_assoc?

0 Answers  

---

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

0 Answers  

---

How to run a sql statement?

0 Answers  

---

How do you convert to a different table type?

1 Answers  

---