From: <[EMAIL PROTECTED]> > Sir, > I am a PG student of Indian Institute Of Information techology > And Management Kerala.I had been using your product.I would like to > get an information. > I would like to know the maximum number of rows and columns which > can be inserted into a table in MYSQL. > I hope you will reply to me at the earliest.
According to Crash-Me (http://www.mysql.com/information/crash-me.php), the maximum number of columns allowed in a table is 3398. I don't know about a limit on the number of rows, but it would probably depend more on your filesystem than MySQL. If you can support file sizes greater than 2G or 4G, then there probably is no limit. And for the record, you should *not* direct questions like this to [EMAIL PROTECTED], [EMAIL PROTECTED], or [EMAIL PROTECTED] -- Mike Johnson . : . : . AIM: denonymous http://www.coldcircuit.net ' : ' : ' http://65.96.177.11 "According to one of our readers, the new MacOS X contains another Satanic holdover from the 'BSD Unix' OS mentioned above; to open up certain locked files one has to run a program much like the DOS prompt in Microsoft Windows and type in a secret code: 'chmod 666'." --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
