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 a shorter way of doing this? I mean, if I had 40 fields in this
table, would I have to write all the fields? I mean, is there a syntax
beginning like
INSERT INTO info VALUES (....
?
Regards and best wishes,
Love, respect,sharing,Linux and PostgreSQL
--
Devrim GÜNDÜZ
Web & System Administrator ---- Web ve Sistem Yoneticisi (www.oper.metu.edu.tr)
devrim@oper.metu.edu.tr
devrimg@tr.net
Phone : +90-535-328-9594 (cellular)
Phone : +90-312-295-9595 (work : 09:00/17:00 on weekdays+Saturday)
Phone : +90-312-286-5906 (home)
http://devrim.oper.metu.edu.tr
------------------------------------------------------------------