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.

Join The Discussion