New to SQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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.


Re: New to SQL

On Sun, 29 Jan 2006 04:30:45 +0000, mzsparkle2 wrote:

Quoted text here. Click to load it

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

Site Timeline