Mailing List Archive


Back to the month index Back to the list index
Lorenzo Nazario (surfer@most.it)
Mon, 14 Apr 1997 11:17:33 +0200 

Message-Id: <3351F62D.6CE09F6D@most.it>
Date: Mon, 14 Apr 1997 11:17:33 +0200
From: Lorenzo Nazario <surfer@most.it>
Subject: [mSQL] Importing NULL fields

Hello guys,

a simple question, did anybody try to import from a file that has NULL
fields?

For example, I build a table that has numeric columns; if some of them
are empty (NULL fields) exporting the table with :

       msqlexport -s "," DBNAME TBNAME > export_file

you will find rows that have adiacent colons.

If you try to import with:

        cat export_file | msqlimport -s "," DBNAME TBNAME

the following error occurs:

        parse error at line 1 near ", ,"

PS: in real case I need to import from external files not produced by
msqlexport, in that case I know that may be better to use "MSQLDUMP >
file" and "MSQL < file".

 
thanks in advance for the help
          

-- 
***********************************************************
* Lorenzo Nazario
* M.O.S.T. s.r.l.
* Multimedia Oriented Systems & Technologies
* Via Bezzecca 9 - 10131 Torino ITALIA
* E-mail   surfer@most.it	Web  http://www.most.it
* Tel +39-11-6600202		Fax +39-11-6600246
***********************************************************
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!