Re: Fwd: Re: [libreoffice-users] LibreOffice Base and MySQL

Maybe this a really stupid question: but - have you defined the table before trying to
upload the csv-file ? The LOAD DATA procedure I mentioned before assumes that a correctly
defined table (CREATE TABLE tablename (col1,col2,...)) with the correct data types of your
columns exists in the DB.
Regards
H.S.

On Wed, 20 Jan 2016 18:03:15 +0100, Heinrich Stoellinger <hc.stoellinger@aon.at> wrote:

> Hello,
> Maybe I don't understand your problem, but...
> LO lets you store your calc-spreadsheet as a csv-file. I have just tried that out.
> The format is just fine for then loading into a table as I described earlier.
> Regards
> H.S.
>
> On Wed, 20 Jan 2016 17:38:12 +0100, Heinrich Stoellinger <hc.stoellinger@aon.at> wrote:
>
> > Hello again, Ian,
> > FIELDS ENCLOSED BY '"' does of course only apply to character type fields
> > (CHAR, DATE,...), not to numeric values.
> > mysql command client should read mysql command line client...
> > Regards
> > H.S.


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted