how does the INSERT INTO SQL work??

[Guest]

I have a similar post about 8 posts down,

I think the answer has to do with the INSERT INTO statement.
I don't know how to use it though =( =( =( & I can't figure it out to save
my life.

here's my guess on it,
INSERT INTO TableName(Field2, Field3, Field4) VALUES (abc,def,123)

that'll create a new row in the table,
Field1 (column A) will be blank
Field2 = abc
Field3 = def
Field4 = 123
Field5 = (blank)

?

Thanks~

 

[Douglas J. Steele]

You're almost bang on. The only problem is that the SQL you presented will
fail, because you don't have quotes around the strings. You need:

INSERT INTO TableName(Field2, Field3, Field4) VALUES ('abc','def',123)

Other than that, your guess as to what it would do is correct.

 

[Guest]

thx so much doug~

You're almost bang on. The only problem is that the SQL you presented will
fail, because you don't have quotes around the strings. You need:

INSERT INTO TableName(Field2, Field3, Field4) VALUES ('abc','def',123)

Other than that, your guess as to what it would do is correct.