ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Multiple statement execution is not enabled by default.

Answer & Solution
Correct Answer: Option A
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.