UPDATE Command

T

tehon3299

Well-known member
Joined
Jan 6, 2003
Messages
155
Location
Liverpool, NY
Will the UPDATE command for SQL work if the table is empty? Basically, if I want to insert a whole bunch of stuff into my table, do I HAVE to use the INSERT command to put stuff in the table then use UPDATE after that or can I use UPDATE to insert stuff right from the beginning?
 
tehon, your posts keep getting moved for a reason. pls pay attention to the forum titles and post them where it makes sense (ie. a database question in the database forum).

Inserts insert data and Updates update existing data.
 
Sorry. How come when I use the update command, it inserts the same thing in every row? It inserts the last thing that is suppose to be inserted, in every row.
 
Your update is not inserting, it is updating every row. I would guess that you have no WHERE clause on your UPDATE, and hence it affects every row. To know why, wed have to see the code that does the UPDATE.

-Ner
 
Back
Top