how does the INSERT INTO SQL work??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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~
 
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.
 
thx so much doug~

Douglas J. Steele said:
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.
Click to expand...
 
Back
Top