mySQL and defaults

[Bob Sneidar]

Right sorry I discovered this last night too. I think the problem was the Sequel Quotes. For some reason I was replacing not only double quotes with ` but single ones too. Trouble is, you cannot wrap default values in `. Also, the reference manual says that text types did not support DEFAULT. I assumed (much to my chagrin) that varchar was a text type. 

I found that a quick way to tell if my sequel is good is to step through the code until I have my statement, then copy the sequel fom the variable browser into the query editor in MySQLWorkbench. It will put a red X at the first line that has bad syntax. Very handy for troubleshooting Sequel, especially since when I build my Sequel, I try to isolate each statement on it's own line. 

Bob


On Mar 17, 2011, at 6:57 PM, Warren Samples wrote:

> On Thursday, March 17, 2011 02:00:41 PM Bob Sneidar wrote:
>> Oh thanks Warren! That will work famously! Unfortunately I just finished
>> the code that strips all the DEFAULT parameters from all text column
>> definitions LOL! I guess it's back to work undoing my last undo. Still,
>> nice to know it can be done.
>> 
>> Bob
> 
> 
> 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
> 
> _______________________________________________
> 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