Vidyalelo
MySQL · Q526

MySQL

Programming · MySQL · question 526

Q526

What does the AUTO_INCREMENT sequences normally begin at?

A.
0
B.
1
Answer
C.
-1
D.
2

Answer: Option B

Solution

Answer: Option B
Solution:
This question is about AUTO_INCREMENT in MySQL.
AUTO_INCREMENT is a feature that automatically assigns a unique number to each new row you add to a table.
Think of it like a counter that starts at a specific number and increases by 1 every time you add a new row.

The question asks: What is the default starting number for this counter?

Here are the options:
* Option A: 0
* Option B: 1
* Option C: -1
* Option D: 2

The correct answer is Option B: 1.
By default, the AUTO_INCREMENT sequence starts at 1. It then automatically increments by 1 for each new row added to the table.