Invalid column ID in my sql query

Question

My query as follows

Insert INTO Accounts_Entity(ID,Entity,Address1,Address2,Address3,Address4,Address5,Signature)
SELECT MAX(CAST(ID as INT)) + ,'HIMT','HIMT2','HIMT3','HIMT4','HIMT5','HIMT6','off'
Accounts_Entity

When i run the above sql query shows error as follows
Invalid column name 'ID'

Table structure as follows (Table Name Accounts_Entity)

Field Datatype

ID bigint
Entity varchar(50)
Address1 varchar(50)
Address2 varchar(50
Address3 varchar(50)
Address4 varchar(50)
Address5 varchar(50)
Signature V archar(50)

please help what is the mistake in my above sql query.

Regards,
Narasiman P.

Upendra Pratap Shahi · Answer

ID column must be auto incremented and then use like below query   insert into yourtable_name ( col1 , col2 , col3 , .. .... col n ) values ( col1value , col2value , col3value , ... colnvalue )

Amitesh Verma · Answer

is ID autoincrement???whats the datatype of ID???

Srinivas Pabballa · Answer

Query syntax for insertion is wrong.   usual syntax for inserting values into a table is   intert into table_name values(value1, value2, value3, ......... value n )   the above query will work when ever you want to insert all the fields of your table and if you want to insert particular column values you have to follow the below syntax.   insert into table_name(col1, col2, col3, .. ....col n) values(col1value, col2value, col3value, ... colnvalue)

Pankaj Kumar Choudhary · Answer

I think you are using insert into command , but syntax of this command is not correct

actual syntax of Insert into command is:

insert into Table_name

select * from Table_Name

and what is use of + operator in your query.

nsert INTO Accounts_Entity(ID,Entity,Address1,Address2,Address3,Address4,Address5,Signature)
SELECT MAX(CAST(ID as INT)) + ,'HIMT','HIMT2','HIMT3','HIMT4','HIMT5','HIMT6','off'
Accounts_Entity