mysql and staroffice
 

hi,
let me state first that i am just starting with mysql! and databases in general.
i have mysql and staroffice installed and working in gentoo.
i have the obdc(or whichever) driver set up, staroffice is connecting to mysql,
and i can access (sorry about that, but it was a good english word before it became a microsoft product)my mysql database(s).
i built my tables from command line, but inserted my records from
mysqlcc. i find inserting records from command line and mysqlcc sort of clunky, so i thought i'd try thru staroffice.however, i find that with staroffice i can edit my tables, but i cant insert records .
i did some reading in the latest staroffice how to book, and found a blurb or two about this problem being due to 1)permissions
2) primary key or 3) staroffice not being able to insert records in to tables done in other apps! well, 1) my mysql user id is passworded, staroffice asks for and recognizes the user/password(there is only one user) and, since i can edit my tables, it seems to me that this wouldnt be the problem. 2) i set primary keys on my tables when i built them, and in staroffice table edit mode, the primary key symbols are present. so, is it
3)? if so, can anyone provide me with a nice gui frontend for mysql that is good for fast data entry of tons of records? or because i am a mysql newb numbno, should i be using a spreadsheet or editor to record data, and then do some kind of import in to my mysql tables? i am doing up my music cd collection as a database, to catalogue and use for query practice,
so my data is mostly text, but does include track #'s and track length in time format. any suggestions welcomed, any flames will be read and voodoo dolls made for the senders.

Have you checked out phpmyadmin? It's a web based gui front-end for MySQL (runs of your local apache). It's very easy to install and will allow you to either add a huge .sql file in one shot, or will allow you to run individual SELECT statements. It's a pretty sweet tool to use.

Here's a URL you can use to download it: http://sourceforge.net/projects/phpmyadmin/

There are a million more gui front-end tools for MySQL....there are other posts on this board about them.

hi thanks for the suggestion- maybe i'll try it, but i'm not running an apache server, dont really want to. my foray in to mysql is strictly a localhost thing.
i'll try refining my search here and see what i come up with.