On 11/12/22 19:05, Andrew Voumard wrote:
What about:

grep -v 'SET SQL_MODE' < test.sql >test-removed.sql


sed -i 's/SET SQL_MODE/-- SET SQL_MODE/g' test.sql


...turned out to work. It does read line (not whole file) by line so it is very quick but writes to a tmp file and then renames it back.

Thanks for all of the assistance and ideas.

Piers


_______________________________________________
luv-main mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to