Hi There,
If you omit the column names, the values are assumed to follow the order
of the column names in the table definition. So if you have the columns
with default values at the end of the table definition, then you don't
need to insert a value for them. Same as in C.
It is better practice
Hi all,
Let's say I have a table named "info" having the following fields:
name char(40),
surname char(40),
address char(40),
id serial
Now, since id is a serial, while inserting data into info I write:
INSERT INTO info (name,surname,address) VALUES ('$name','$surname',
'#address');
Is there