Answer Posted / shyam

Hi Pravina.. Regarding ur concern in answer #5.. There is no
such limitation on the db size.

It all depends on the table sizes which in turn depends on
the maximum file size the underlying operating system can
handle (for this refer answer# 3 by Vibhor Gupta). As the
table size increases, the db size too increases proportionally.

Of course you will have a drop in the performance if the db
grows in the range of several tera bytes provided you dont
scale your hardware and software correspondingly. That is
when u decide u cannot let the db grow anymore.. Relatively
for u this point may be the one where your db has reached
its maximum size.

Hope this addresses ur query :)

What are date and time data types?

971

---

What is sqlyog?

1013

---

What mysql -u john -p command does?

962

---

can you tell what are the different set operations available in mysql? : Mysql dba

872

---

What are the column comparisons operators?

1223

---

How can we get total number of records by query in mysql?

903

---

What is the difference between primary key and candidate key?

999

---

Can you rename a database in mysql?

994

---

How to get nth highest salary from table in a mysql?

940

---

What does mysql_fetch_assoc do?

952

---

How to run a sql statement?

1009

---

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

995

---

What you can use regular expression for in mysql? Support your answer with an example?

883

---

Explain % and _ inside like statement?

992

---

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

982

---