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(IDEntityAddress1Address2Address3Address4Address5Signature) SELECT MAX(CAST(ID as INT)) + 'HIMT''HIMT2''HIMT3''HIMT4''HIMT5''HIMT6''off' Accounts_Entity