Re: Syntax error in INSERT

Hi, I suppose you have to use a NULL value: INSERT INTO CallBacks (LearnerID,CallDate,CallTime) VALUES (2113,NULL,NULL)I [EMAIL PROTECTED] wrote: > > Hi, > I have the following statement causing an error near "," > sNewCallBackSQL = "INSERT INTO CallBacks (LearnerID,CallDate,CallTime) V

CREATE TABLE and CHECK clausole

Dear subscribers, MySQL seems to support the CHECK() clausole in the implementation of CREATE TABLE statement, but MySQL (Ver 11.15 Distrib 3.23.39, for pc-linux-gnu) returns a syntax error on such a command. For example: mysql> CREATE TABLE example (var INTEGER, CHECK(var BETWEEN 0 AND 1)); ERRO