--- Rhino <[EMAIL PROTECTED]> wrote: > > > 2. What happens when you do 'select count(*)' on > > > your new table? > > > > I'm not familiar with that command. If I type > select > > count (*) into the "query" box on phpMyAdmin, it > says > > count(*) = 0 Or is this a type of table query I do > on > > my webpage? > > > Sorry, I used a bit of shorthand there. The standard > SQL query to determine > the number of rows in a table is: > select count(*) > from <table_name> > > This query could be executed several different ways > but the easiest is > probably at your MySQL prompt.
Alright, I learned something new. I performed your count query, and the result is 3569 rows! So I'm guessing that Navicat correctly imported everything, but phpMyAdmin just isn't displaying all the rows. However... > I've never seen Navicat (or heard of it for that > matter): does it give you a > positive message to the effect that you have > successfully loaded 3000 rows? Navicat gives me nothing but positive messages, though I don't think it specifies the number of rows loaded. However, during the import process, there are a couple panels where you can review your data. I'm not sure if you're necessarily supposed to be able to preview every single row, but in this particular case - table "famarea" - the last row I can see is Andorra. I looked at the csv file and discovered that the last field in Andorra is preceded by three commas, whereas the norm seems to be four commas. However, the row before Andorra is just one comma. I don't know why the number of commas should vary. "oar","Arctic Ocean","oce","arc","oce","Oceanus","oce","oce",,,,10 "oat","Atlantic Ocean","oce","atl","oce","Oceanus","oce","oce",,,,11 "oin","Indian Ocean","oce","ind","oce","Oceanus","oce","oce",,,,12 "opa","Pacific Ocean","oce","pac","oce","Oceanus","oce","oce",,,,13 "oso","Southern Ocean","oce","sou","oce","Oceanus","oce","oce",,,,14 "sca","Caribbean Sea","sea","car","oce","Oceanus","oce","oce",,,,15 "afg","Afghanistan","nat","afg","xeu","Eurasia","con","eur","asi",,,16 "alb","Albania","nat","alb","xeu","Eurasia","con","eur","eur",,,17 "dza","Algeria","nat","dza","xaf","Africa","con","afr",,,,18 "asm","American Samoa","dep","asm","opa","Pacific Ocean","oce","pac",,"ppol","usa",19 "and","Andorra","nat","and","xeu","Eurasia","con","eur","eur",,,20 "ago","Angola","nat","ago","xaf","Africa","con","afr",,,,21 > > > Do you have any tables at > > > all in your MySQL database that have more than > 480 > > > rows? If yes, you've > > > proven that MySQL tables can contain over 480 > rows. I could have sworn that I had a working table from a different database with about 3,000 rows. It's a table of U.S. counties, and I thought I had working pages for every state. I was still experimenting with it, and I can't locate it at the moment. I'll look some more. > A cut and paste of the complete table definition > would be a lot more helpful > than this paraphrase. As I said earlier, the full > table definition and a few > complete rows of the input file are very useful in > determining what might be > wrong. . . . Again, you haven't said > what TYPE of table you are > using. That's why the *complete* table definition > would help. Even better, I put a screenshot online at http://www.geoworld.org/famarea.gif ...unless you're asking for a more technical description from phpMyAdmin. I don't know to get that. Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
