I want to remove all create table statements from a mysql script, but the statement runs over multiple lines.
Create table ......NEWLINE... NEWLINE... NEWLINE....;
So I tried this statement, but nothing happens:
sed -i 's/CREATE TABLE(.*\n)*.*;`//' *.sql
Seq only reads one line at a time? How can I fix this?