Insert Into Help.

Hameed · #1 (**permalink**) 11-29-04, 11:48

Dear all,
i have a table consists of one column, this column is integer and auto increment.
i need to add a new record unsing SQL statement.

need help plz.
thanks

guelphdad · #2 (**permalink**) 11-29-04, 14:29

Can you explain the use of such a table? You could probably put the auto increment column on a table where you are actually storing data.

If you NEED to use the table as is you can do

Code:

INSERT into tablename values(NULL)

that will insert a new value into your table.

Hameed · #3 (**permalink**) 11-30-04, 08:04

This statment didn't work.

healdem · #4 (**permalink**) 11-30-04, 09:05

What is the table used for, are you sure you haven't misread your homework assignment?

guelphdad · #5 (**permalink**) 11-30-04, 13:03

What do you mean didn't work. Did a value not get added? Did you replace the name of the table with your table name? Other than that you should type it exactly as i have. if you do that and it still doesn't add a value make sure it is an auto increment table like you think it is.

Internet Services

Web Development

Digital Marketing

Consumer Tech