When creating a new WeBWorK 2 course, it says "Specify an ID, title,
and institution for the new course. The course ID may contain only
letters, numbers, hyphens, and underscores." Accordingly, I created a
course with the name "ma115-027". Now, it so happens that I need to
change some problem definitions, and it occurred to me that this might
be easiest to do by going into mysql and changing values in the problem
table for the course.
However, in mysql it appears that the hyphen is problematic:
mysql> describe ma115-027_problem;
Should hyphens be excluded from course names?
ERROR 1064: 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 '-027_problem' at line 1
It doesn't appear to be a problem for WeBWorK, but is causing me
trouble when working manually with the table (obviously). I'm thinking
that if I want to change the course name at this point I'll have to
dump the databases to text files, edit those, and reload them.
Any suggestions, comments or tips?
<| Post or View Comments |>