SQL and other databases
bobs at twft.com
Tue Mar 22 14:54:07 EDT 2011
Yes but those are numeric data types. The restriction was on the char types char() and varchar() (if I am not mistaken). TEXT types do not allow defaults at all according to the manual.
On Mar 22, 2011, at 10:29 AM, Peter Haworth wrote:
> Hi Bob,
> I'm slowly putting together a list of differences between SQLite and MySQL. I'm concentrating on things that SQLite allows and MySQL does not. I haven't looked at extra functionality provided by MySQL over and above what SQLite provides since right now I just want to get to the point that my SQLite schema definitions and data manipulation statements work in MySQL
> Before getting to the list, a couple of observations on the issues you've come across.
> I'm not seeing the requirement to have NOT NULL in conjunction with DEFAULT. Here's a snippet which was accepted just fine by mySQL:
> `BandTrakSalesID` int(11) DEFAULT '0',
> `Selected` tinyint(1) DEFAULT '1',
More information about the Use-livecode