Re: [SQL] Entering data in serial column

2001-09-29 Thread david
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

[SQL] Entering data in serial column

2001-09-29 Thread Devrim GUNDUZ
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