OT: mysql DB question

Hi there. (I know this is propably not the right forum to ask here, but
the other forums don't help a lot. Please help me.)



I have been using phpMyAdmin for a couple of years now and simply love
it.
I have just created a new DB with 6 fields of which the 1st one is
named: prod_id.
type: smallint

The rest of the fields are the default settings as usual. I have changed
this prod_id to the prim key.

For some reason which I cannot figure out why, does not show under
"extra" as "auto_increment".

I have double chacked the other db's I have created exactly as I have
done this one, and there is says "auto_increment".
When I now try to add a record to the DB, I get this error: "Field
'prodid' doesn't have a default value"

Please advise where I am doing something wrong.

Sincere regards,
Deon

this prod_id to the prim key.
-----------^^

"Field 'prodid' doesn't have a default value"
-------------^

Typo?


--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Deon H" <deonNOSPAM (AT) pess (DOT) co.za> wrote

Hi there. (I know this is propably not the right forum to ask here, but
the other forums don't help a lot. Please help me.)



I have been using phpMyAdmin for a couple of years now and simply love
it.
I have just created a new DB with 6 fields of which the 1st one is
named: prod_id.
type: smallint

The rest of the fields are the default settings as usual. I have changed
this prod_id to the prim key.

For some reason which I cannot figure out why, does not show under
"extra" as "auto_increment".

I have double chacked the other db's I have created exactly as I have
done this one, and there is says "auto_increment".
When I now try to add a record to the DB, I get this error: "Field
'prodid' doesn't have a default value"

Please advise where I am doing something wrong.

Sincere regards,
Deon

"Murray *ACE*" <forums (AT) HAHAgreat-web-sights (DOT) com> wrote in news:gqo6hr$cbm$1
@forums.macromedia.com:

this prod_id to the prim key.
-----------^^

"Field 'prodid' doesn't have a default value"
-------------^

Typo?

Yes, it's a type; my fault. Prim key is prodid.

Deon

Deon H posted in macromedia.dreamweaver

I have been using phpMyAdmin for a couple of years now and simply
love it.
I have just created a new DB with 6 fields of which the 1st one is
named: prod_id.
type: smallint

The rest of the fields are the default settings as usual. I have
changed this prod_id to the prim key.

For some reason which I cannot figure out why, does not show under
"extra" as "auto_increment".

Can you export the structure for this particular Table and paste the
results in here? The stuff beginning with:

CREATE TABLE `tablename` (



--
Mark A. Boyd
Keep-On-Learnin'

Hi Mark.

Thanx for your reply. I managed to solve the problem. There was a checkbox
at A_I which I had to tick. All is running smooth now.

Thanx again.
Deon

Can you export the structure for this particular Table and paste the
results in here? The stuff beginning with:

CREATE TABLE `tablename` (