Click to See Complete Forum and Search --> : Does SQL create fields automatically?


ARozanski
03-22-2009, 07:47 AM
Hi - i would like to know if i use a php form to upload something to a database into a field that doesn't exist, will SQL take the liberty of creating the field on it's own??

Thanks in advance

bluestartech
03-22-2009, 09:50 AM
you will need to use an sql statement seperately to create a new field, e.g.
update table mytable add newfield varchar(50);
It will not be done automatically, all columns need to be defined

ARozanski
03-22-2009, 12:34 PM
thanks a lot! ;-)