Examveda

Multiple statement execution is not enabled by default.

A. True

B. False

Answer: Option A

Solution (By Examveda Team)

This question is about how MySQL handles multiple commands you write in a single query.

Imagine you want to do several things at once, like:
1. Create a new table
2. Add some data to it
3. Update some of the data

You might try writing all three commands in one go, like this:
CREATE TABLE my_table (name VARCHAR(255)); INSERT INTO my_table (name) VALUES ('Alice'), ('Bob'); UPDATE my_table SET name = 'Charlie' WHERE name = 'Bob';

But by default, MySQL doesn't let you run all these commands at once. It expects each command to be separate.

So the answer is Option A: True.

You can enable multiple statement execution if you need it, but it's not the standard behaviour.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous