Add row to table while incrementing primary key

Question

Say I have a table that looks like:

ID Name Age Co 1 Adls 15 US 2 sldkl 14 FR 3 sldke 16 UK 4 sldee 17 IN

I want to add values to the table and have the ID incremented. ID is the primary key, and I set is Identity under column properties to 'Yes' and identity increment to 1.

So basically, I am doing:

Insert Into TableName(Name, Age, Co) Values(slkdje, 19, CH) (sldjklse, 20, AU) (slfjke, 12, PK)

But, I am getting errors that the primary key is null, and therefore this operation in invalid. How would I add the values, but get the primary key values to increment?

There is an AUTO_INCREMENT you can set on a column, see: Auto Increment. — Mark
– Mark, Commented Oct 18, 2018 at 22:33
What does SHOW CREATE TABLE TableName give? Please add to your question... — Nick
– Nick, Commented Oct 18, 2018 at 22:33
There's no 'column properties' in MySQL . You must be using some kind of 'front end' application — Strawberry
– Strawberry, Commented Oct 18, 2018 at 22:37
In SQL Server Management Studio, right click that table, go to "Script Table As" and select "CREATE to". This will give the script for the table creation. Please add that into this post. — Utrolig
– Utrolig, Commented Oct 18, 2018 at 23:08

Sleepyfalcon · Accepted Answer · 2018-10-19 01:09:51Z

here is a great example for what you want here

here is also a sql query that is copy and paste that will show my example.

create table #temp( ID int IDENTITY(1,1) PRIMARY KEY, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int ) insert into #temp(LastName) values('billy'),('bob') select * from #temp drop table #temp;

hope this helps dude.

Collectives™ on Stack Overflow

Add row to table while incrementing primary key

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related