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.
|