Hi .
I'm having trouble with the AUTO INCREMENT statement in SQL.
I've built the table :
CREATE TABLE tenants(
apartment_number_first_floor INT AUTO_INCREMENT,
family_name VARCHAR (12) DEFAULT NULL,
sur_name VARCHAR (8) DEFAULT NULL,
telephone_number INT(3) NOT NULL,
PRIMARY KEY (apartment_number_first_floor)
);
when inserting a row:
INSERT INTO tenants VALUES(' ',' ');
The IDE doesn't accept the column count:
ER_WRONG_VALUE_COUNT_ON_ROW: Column count doesn't match value count at row 1
So i tried filling the rows just to check if the IDE will run the statement
INSERT INTO tenants VALUES(103,'שקלובין','מרתה',203);
but the IDE refuses to increment
Any ideas?
Thanks