Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 29, 2006, 4:30 am
rate this thread
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
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
hope this helps
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum