Vidyalelo
MySQL · Q317

MySQL

Programming · MySQL · question 317

Q317

Multiple statement execution is not enabled by default.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
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.