ProfessorK
Instructor
Prof. K
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Moodle anybody?
- Thread starter ProfessorK
- Start date
- Status
Prof. K
- Thread starter
- #3
ProfessorK
Instructor
sure adminme,
what's on your mind?
Prof. K
what's on your mind?
Prof. K
I'm writing sql against mysql 3.23.58, MyISAM tables. I'm new to mysql and not a seasoned sql writer but have managed to get this far in a few days.
Have you used 'create_tables.sql' for pmadb? Will it produce a pma_relation table for this version of MySql?
I read that the create tables script for the Moodle back-end may contain 'key' syntax but cannot be used with MyISAM tables - specifically the foreign key. Would you elaborate on the 'key' types in MySql 3.23? Such as 'key', 'unique key', 'pk'(all moodle tables'pks are ids).
Have you used 'create_tables.sql' for pmadb? Will it produce a pma_relation table for this version of MySql?
I read that the create tables script for the Moodle back-end may contain 'key' syntax but cannot be used with MyISAM tables - specifically the foreign key. Would you elaborate on the 'key' types in MySql 3.23? Such as 'key', 'unique key', 'pk'(all moodle tables'pks are ids).
- Status
Similar threads
- Locked
- Question
- Locked
- Question