Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 04-18-2010, 10:01 PM   #1
Registered: Mar 2010
Distribution: Slackware
Posts: 63

Rep: Reputation: 4
Unhappy The maximum number of characters and rows in a database?

Is the maximum number of letters a database table column can contain 255?

and is it a bad idea to build a table with about 15 columns? thanks!!
Old 04-18-2010, 10:14 PM   #2
LQ Guru
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

"No" and "No".

The absolutely maximum #/columns or maximum #/rows in a database: "it depends". For example, in MySQL 5.0:

In practice, however, any "reasonable" design for just about any common relational database can scale up as much as you want it to (or to as much disk, CPU and hardware as you can afford - whichever comes first ).

In general, "how many columns in a row" will depend on your DATA MODEL. Not on any limitation in the database.

So how many columns is "enough"?

A good rule of thumb is to "normalize" your database to at least 3NF.

'Hope that helps .. PSM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum number of clients svetlio0o Slackware 4 12-19-2008 09:30 AM
adding constant (number) to a number in all rows skuz_ball Programming 2 05-20-2008 09:57 PM
data with same number of rows and coloumns C/C++ fs11 Programming 2 04-29-2008 10:17 PM
Maximum number of fonts Thetargos Linux - Software 2 02-04-2006 08:01 PM
maximum number of HDs gr00ve Linux - Hardware 2 09-05-2004 06:43 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:24 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration