What does your CREATE TABLE statement look like? That's where the error would be.
-----Original Message----- From: Tom Strom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 9:18 AM To: [EMAIL PROTECTED] Subject: MySQL on Valueweb Server - Max number of fields Hello there, I have recently started fiddling with bringing data online so it can be searchable from our web site, but am running into problems. I have a table with about 3900 records. The table consists of 7 fields (columns), and goes like this : Id, name, address, address cont'd, city, state, phone#. I save the file in DBase III format and, using WinMySqlPro, create a table from the DBIII file. However, MySql will only set up a table with 6 fields, not 7, and when uploading the table, only add 6-field records. And, when I use a DBase table with 6 fields, mySql creates one with 5 fields.???!???! I have tried to create a table with only one record in it, but that changes nothing. It still will only set up 6-field table. Can any one PLEASE help me? Valueweb does not offer support. Tom Strom --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
