more compound mysql command woes

[Bob Sneidar]

Copy paste the sql into an sql utility like mySQLWorkbench, execute it and see if it shows you an error. I did. I get this for the third line: 

Error Code: 1364. Field 'unqKy' doesn't have a default value

There is your error. 

Bob S


> On Jan 19, 2015, at 20:54 , Dr. Hawkins <dochawk at gmail.com> wrote:
> 
> On Mon, Jan 19, 2015 at 7:11 PM, Peter Haworth <pete at lcsql.com> wrote:
> 
>> What error are you getting?
>> 
> 
> They were all along the lines of
> 
> revdberr,You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'CREATE TABLE dhdbt_dragon_puff_the__001  (unqKy INT NOT NULL, ktyp
> CHAR(1),  kyw' at line 2
> 
> 
> -- 
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode