Facing issue while running INSERT query

[BizBoy]

Hi,

I am using database copied from below url.
https://www.w3schools.com/sql/sql_insert.asp

I am using insert query, however when I run this query CustomerID remains blank.
But the website mentions that it should get auto-populated.

Can anyone please guide me about this.


insert into customers(customername, contactname, address, city, postalcode, country)
values('YoYo','YiYi' ,'YeYe','Pune',411037,'India')

Thanks.

 

[ranman256]

In the table,tCustomers, is the ID field set to AutoNum?

 

[BizBoy]

Hi ranman sir, no, it was set to number, not to AutoNum.
Thanks a lot for the help. Have a nice day ahead.