I am trying to populate a job_title table but when I try to add
Job_title_code, Job_title, minimum salary, maximum salary. I get an error
that tell me that the colum needs a default value. I want to correct this
error to add this ivalue so can insert the information into the table. Can
anyone help me.
Thanks
Mzsparkle2
On Sun, 29 Jan 2006 04:30:45 +0000, mzsparkle2 wrote:
> I am trying to populate a job_title table but when I try to add
> Job_title_code, Job_title, minimum salary, maximum salary. I get an error
> that tell me that the colum needs a default value. I want to correct this
> error to add this ivalue so can insert the information into the table. Can
> anyone help me.
>
> Thanks
> Mzsparkle2
the reason you're getting that error msg (I believe) is that the data may
be missing in certain fields and mysql likes to know what to stick in the
field in case there is no data in the file.
if you have a gaphical interface to your db, it's pretty easy to bring up
the structure of the table and the then choose a value for default for
each field. for example, you'd like to pick a value of 0 (zero) for all
integer feilds.
hope this helps