1.

The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________(a) –force(b) –run(c) –ensure(d) –violentThe question was asked in a job interview.This intriguing question originated from Comment Syntax in portion SQL Syntax of MySQL

Answer»

Correct OPTION is (a) –force

Easy explanation: If SQL queries in a FILE are run using mysql in batch mode, mysql either QUITS after the first error. If the –force option is specified all the queries are EXECUTED indiscriminately.



Discussion

No Comment Found

Related InterviewSolutions