CREATE TABLE employees(
employee_id INT NOT NULL AUTO_INCREMENT,
firstname VARCHAR(30),
lastname VARCHAR(30)
PRIMARY KEY(employee_id)
);
ALTER TABLE employees AUTO_INCREMENT = 30;
What will be the initial value of employee_id?
CREATE TABLE employees(
employee_id INT NOT NULL AUTO_INCREMENT,
firstname VARCHAR(30),
lastname VARCHAR(30)
PRIMARY KEY(employee_id)
);
ALTER TABLE employees AUTO_INCREMENT = 30;
What will be the initial value of employee_id?
Create a free account to access the full topic