i know this is kinda not directly a flex question but i figure surely someone must use mysql in here for a flex app.....
anyway here goes..... just a quick question....ive got a database of students and i want to somewhat design a relational database so that i can run relational queries. unfortunately i dont know how to construct foreign keys in mysql using phpmyadmin. my idea was to have 4 tables namely students studentid name surname address etc etc enrolment studentid <----foreign key courseid <----foreign key course courseid coursename teachers teacherid teachername the tables above are simplified and will probably contain much more data. my main prblem is that i dont know how to set up foreign keys within phpmyadmin so that i can keep my database relational.