mySQL and defaults

[stephen barncard]

Sometimes invisible characters can creep in when cutting and pasting from
 scripts. BBEdit's 'Zap Gremlins' or Tex-Edit 'Clean Up Document' commands
can fix.

just a thought. it's happened to me.

On 17 March 2011 18:57, Warren Samples <warren at warrensweb.us> wrote:

>
> Hi Bob,
>
> I just tried this myself and find that the NOT NULL doesn't seem to have
> been
> the key since this works, too:
>
> mysql>  CREATE TABLE myTable(ID SMALLINT UNSIGNED NOT NULL,City VARCHAR(40)
> DEFAULT 'Unknown');
>
> Query OK, 0 rows affected (0.04 sec)
>
> So, perhaps there was some other error in your query? Punctuation and
> spelling
> are the usual suspects ;)
>
> Best,
>
> Warren
>


Stephen Barncard
San Francisco Ca. USA

more about sqb  <http://www.google.com/profiles/sbarncar>