Great, that's further than I was before...
SO, about the problem of enclosing the fields:
- if I am going to have " and \r and \n in fields, what
should I enclose them with?
- my problem is that when a text field, with html in it,
it makes it into several hundred recs
- maybe a different line/record terminator? can those be
more than one character?
TIA,
Bruce
On Mon, 19 Dec 2005 11:39:06 -0800
Hassan Schroeder <[EMAIL PROTECTED]> wrote:
Bruce Carey wrote:
I posted this earlier, could someone take a look at it?
In the time since you first posted, you could have at
least glanced
at the Fine Manual :-) which shows that:
mysqldump --opt --fields-terminated-by='\t'
--fields-optionally-enclosed-by='#*#*#'
<q>
Any of the field- or line-handling options can specify
an empty
string (''). If not empty, the FIELDS [OPTIONALLY]
ENCLOSED BY
and FIELDS ESCAPED BY values must be a single character.
</q>
FWIW,
--
Hassan Schroeder -----------------------------
[EMAIL PROTECTED]
Webtuitive Design === (+1) 408-938-0567 ===
http://webtuitive.com
dream. code.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]