Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Sequences

AUTO_INCREMENT

Report a typo

CREATE TABLE computer(
serial_number INT AUTO_INCREMENT,
manufacturer VARCHAR(30),
cpu_model VARCHAR(30)
);

Which of the following SQL statements will change the initial value of the sequence to 50?

Select one option from the list

ALTER TABLE computer AUTO_INCREMENT = 50;

ALTER TABLE serial_number AUTO_INCREMENT = 50;

ALTER COLUMN serial_number AUTO_INCREMENT = 50;

ALTER COLUMN computer AUTO_INCREMENT = 50;

___

Create a free account to access the full topic