Jump to content

Aviram

Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by Aviram

  1. 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

×
×
  • Create New...