Using the Insert into statement

[Kalisto]

I am trying to run a simple insert into query, but keep hitting problems.

I dont want to go into it all at present, but if my table has an auto generated key, how do i insert into an existing table, as i need to supply all parameters when i insert, but the autonumber comes from the DB !

Can anyone who undesrstands me help (I know this must be a common answer with a simple solution)

 

[rac2]

You must list the columns to receive values and insert data only into those columns. It is possible to turn off the autonumber feature to allow inserting values. Normally this is part of an initial load or import process. The method depends on the brand of database you are using, it is not really a feature of SQL, so you need to post in the forum for your database, not in the ANSI SQL database.

 

[Kalisto]

ok, apologies.
using the insert into <table> syntax, what do i use, at present it's values (x) I have tried colums (x=y), and that doesnt work

 

[rac2]

Sorry, did not mean to be curt, only helpful. An example would be

INSERT Soldiers (name, rank, serial_number)
VALUES ('Bob','Private First Class', 987654321)

for a table that also has an autonumber column named soldier_id.

 

[Kalisto]

Thanks, np with ur answer, was mebbe not targetted enough

Thanks again,

K