 | |
#11
 
| |||
| |||
|
Re: Primary Key Not Null.... -
03-15-2011
, 06:58 PM
|
On Tue, 15 Mar 2011 19:54:05 -0400, Jerry Stuckle wrote: On 3/15/2011 5:34 PM, SpreadTooThin wrote: I have a column that is my primary key... it has PK and NN checked off in MySQL Workbench table editor... However software is able to write a record where the columns value is ''... Which isn't NULL I guess.. but what do I do in the table construction You have a database question - try a newsgroup for your database (in this case comp.databases.mysql). You'll get much better answers. *psst* Hey, Jerry? Am I missing something here? |
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================
#12
| |||
| |||
|
|
On 3/15/2011 5:34 PM, SpreadTooThin wrote: I have a column that is my primary key... it has PK and NN checked off in MySQL Workbench table editor... However software is able to write a record where the columns value is ''... Which isn't NULL I guess.. but what do I do in the table construction SQL so that blank isn't valid either? You have a database question - try a newsgroup for your database (in this case comp.databases.mysql). |
reading and responding to it. And where he's already gotten several responses
that were actually useful.
#13
| |||
| |||
|
|
On Tue, 15 Mar 2011 19:54:05 -0400, Jerry Stuckle wrote: On 3/15/2011 5:34 PM, SpreadTooThin wrote: I have a column that is my primary key... it has PK and NN checked off in MySQL Workbench table editor... However software is able to write a record where the columns value is ''... Which isn't NULL I guess.. but what do I do in the table construction You have a database question - try a newsgroup for your database (in this case comp.databases.mysql). You'll get much better answers. *psst* Hey, Jerry? Am I missing something here? I think Jerry has finally lost it completely.  |
#14
| |||
| |||
|
|
In article <ilou6u$qf... (AT) news (DOT) eternal-september.org>, Jerry Stuckle <jstuck... (AT) attglobal (DOT) net> wrote: On 3/15/2011 5:34 PM, SpreadTooThin wrote: I have a column that is my primary key... it has PK and NN checked off in MySQL Workbench table editor... However software is able to write a record where the columns value is ''... Which isn't NULL I guess.. but what do I do in the table construction SQL so that blank isn't valid either? You have a database question - try a newsgroup for your database (in this case comp.databases.mysql). Which is, of course, exactly where he posted the question. And where you're reading and responding to it. And where he's already gotten several responses that were actually useful. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.