When I execute a script file containing sql statements it fails with an error, mysql ignores the rest of the file. Is there any option to execute the entire file regardless of errors occurrence.
Answer No: 94
If a statement in a script file fails with an error, mysql ignores the rest of the file. To execute the entire file regardless of whether errors occur, invoke mysql with the --force or -f option.