1.

The option that executes all SQL statements in a SQL script irrespective of the number of errors is ____________(a) –ensure(b) –force(c) –violent(d) –runThis question was posed to me during an interview.My enquiry is from Status Variables topic in section System, Status and User Variables of MySQL

Answer»

The correct choice is (b) –force

Best 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