On Friday, November 6, 2015 at 1:31:59 PM UTC-8, Benson Myrtil wrote: > > I am attempting to run the following within executesql on a MySQL database: > > LOAD DATA LOCAL INFILE '[path]' > INTO TABLE ps_cc > CHARACTER SET UTF8 > FIELDS TERMINATED BY ',' ENCLOSED BY '"' > LINES TERMINATED BY '\r\n' > ( > fk_ps_server_id > ,fk_school_number > ,term_id > ,section_id > ,@date_enrolled > ,@date_left > ,teacher_number > ,section_number > ,course_number > ,course_name > ,expression > ,student_number > ) > SET date_enrolled = STR_TO_DATE(@date_enrolled, '%m/%d/%Y'), > date_left = STR_TO_DATE(@date_left, '%m/%d/%Y') > > However I am getting the following error: 1148 The used command is not > allowed with this MySQL version > > When I paste that same line of code inside of Workbench it executes just > fine. > > Any ideas why? >
There are lots of special characters in that string. Are you running into an issue with how they are escaped? Otherwise, the issue is way beyond me, and we will await the actual DBAs . /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
