When inserting into a table and there are many columns to be inserted
it is hard to synchronize columns to values:
insert into my_table (
a,
b,
c,
...many more columns
)values(
@a,
@b,
@c,
... the corresponding values
)
Is there some reason for the insert syntax to be the way it is in
instead of the much easier to get it right Update syntax?:
update my_table
set a = @a,
b = @b,
c = @c,
...
Regards, Clodoaldo Pinto Neto
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
