LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 04-18-2010, 11:01 PM   #1
puppymagic
Member
 
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, 11:14 PM   #2
paulsm4
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:

http://dev.mysql.com/doc/refman/5.0/...unt-limit.html

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
 
  


Reply


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 10:30 AM
adding constant (number) to a number in all rows skuz_ball Programming 2 05-20-2008 10:57 PM
data with same number of rows and coloumns C/C++ fs11 Programming 2 04-29-2008 11:17 PM
Maximum number of fonts Thetargos Linux - Software 2 02-04-2006 09:01 PM
maximum number of HDs gr00ve Linux - Hardware 2 09-05-2004 07:43 AM


All times are GMT -5. The time now is 10:43 PM.

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