Mike Noyes, 2001-03-25 13:33 -0800
>[EMAIL PROTECTED], 2001-03-25 12:35 -0800
>>If there are no quoted single-quotes in the author fields, the following
>>should do it:
>>
>>sed -e
>>"/INSERT/s/\((\('[^']*',\)\{4\}\)'\([^']*\)',\([^)]*\)/\1'dummy',\4\)/g"
>
>Why did you use a global when there are multiple INSERT strings in the
>mysqldump? Wont this insert dummy in areas we don't want it?
Ok, I think I get it. To limit the global to the line we want change:
"/INSERT/
to
"/INSERT INTO authors/
Did I get that right?
--
Mike Noyes <[EMAIL PROTECTED]>
http://leaf.sourceforge.net/
_______________________________________________
Leaf-devel mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/leaf-devel