3 questions - how many rows can mysql handle, how much text can fit...

[spewn]

How many rows and columns can mysql support? does it vary depending on amount of info in each row/column?

also, how much text (characters) can fit in a text field?

and lastly, i have a list of rows and need to display based on most recent date (sorting further by time if multiple entries on same date)...

i have this to sort by a column by a-z or z-a:

"select forms from formList where formID = '' order by formName desc"

obviously this can't help my situation, but maybe it's the direction (similar structure) i should head in?

thanks.

- g

 

[lgarner]

http://dev.mysql.com/doc/mysql/en/table-size.html

might help figure out the max table size, depending on the MySQL version.

I think your select statement is ok, just substitute the column containing the date value in place of "formName