Thread: crud application please help
hi, can you please guide me in a crud application for one table that have auto increment serial number for each record can you please give what syntax do i have to enter new record without writing manually the id of the record through php connection to postgresql if you can send me an example for one table with two fields it would be more than enough i would appreciate if you gave me a link , book name , tutorial web site ,........ etc thanks in advance hatem gamal 201515604034 hatem@softpro.bz
On 16/05/2011 03:19, hatem gamal elzanaty wrote: > hi, > can you please guide me in a crud application for one table that have > auto increment serial number for each record can you please give what > syntax do i have to enter new record without writing manually the id of > the record through php connection to postgresql if you can send me an > example for one table with two fields it would be more than enough i > would appreciate if you gave me a link , book name , tutorial web site Auto-incrementing columns, or SERIAL types [1]: http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL Default values - look for the DEFAULT keyword: http://www.postgresql.org/docs/9.0/static/sql-createtable.html [1] Note that SERIAL isn't a real type, but just syntactic sugar that creates a sequence and sets the column to pull from the sequence by default. More on sequences: http://www.postgresql.org/docs/9.0/static/sql-createsequence.html Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie