Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of Fields limit?

Status
Not open for further replies.
sermac

sermac

Programmer
Jul 27, 2002
238
US
Hi: . . . am programming in vfp7.
VFP.dbf tables are limited to 255 fields and 2g of records.

Not knowing "anything" about mysql. . .

how does it handle "tables.dbf" regarding the number of fields limit and number of records limit?

THX

Bill

 
Sort by date Sort by votes
don't think there is a table limit. file limits are up to 8 terabytes...but mainly o/s dependant

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!
 
Upvote 0 Downvote
Bastien. . .and others:

How many "fields" ("not" records) are you able to put in a table? is there a limit?
 
Upvote 0 Downvote
InnoDB has a limit of 1000 fields per table. Can't see any info on the others.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
370
SkipVought
S
Arun Mahajan
  • Locked
  • Question
How to catch SQL Exception Error number in MySQL 5.6
Replies
0
Views
118
Arun Mahajan
Arun Mahajan
FoxAll
  • Locked
  • Question
Lots of data !
Replies
0
Views
98
FoxAll
FoxAll
P Soman
  • Locked
  • Question
insert data into colums of different tables
Replies
2
Views
157
spamjim
spamjim
Prochotap
  • Locked
  • Question
How to sumarize “sickness time” to the end of order - mysql
Replies
0
Views
89
Prochotap
Prochotap

Part and Inventory Search

Sponsor

Back
Top