Insert Statement
I have taken a backup of a table on a local machine from MySQL V3.23. The following sql was generated:
INSERT INTO `VIA_Query_Select` (`QueryID`,`SelectPartID`,`TagName`,`Expression`,`AliasName`,`Type`,`ReportColumnTitle`,`ReportColumnType`,`ReportColumnFormat`,`ImageMIMEFieldName`,`OptionalCheckedDefault`,`SectionIDField`) VALUES
(136,4,'EstimatedWeeks','Contracts_Contracts.EstimatedWeeks','EstimatedWeeks','always','Estimated Weeks','integer',NULL,NULL,1,NULL),
(136,5,'ProjectBeginDate','Contracts_Contracts.ProjectBeginDate','ProjectBeginDate','always','Project Begin Date','date','format=d/m/Y; blankifnull',NULL,1,NULL),
(137,1,'Date','Allocation_Header.Date','Date','always','Date','date','format=d/m/Y; blankifnull',NULL,1,NULL),
(137,2,'ItemDescription','Contracts_Works.ItemDescription','ItemDescription','always','Item Description','text',NULL,NULL,1,NULL),
(137,3,'DescriptionOfWork','Allocation_Header.ReportDescription','DescriptionOfWork','always','Report Description','text',NULL,NULL,1,NULL),
(137,4,'EmployeeName','CONCAT(Employees_Employees.LastName, \", \", Employees_Employees.FirstName)','EmployeeName','always','Employee Name','text',NULL,NULL,1,NULL),
(137,5,'Position','Lookup_EmployeePosition.Description','Position','always','Employee Position','text',NULL,NULL,1,NULL);
I have then tried to load this onto my hosted database of the same name which is MYSQL v4.1 and get the following error:
MySQL said: 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 ''format=d/m/Y' at line 3
Many other tables have been OK - Does anyone have an idea what this could be?