N/APosted on - 02/08/2013
I am a web developer. I am creating a Drupal module to build quiz z MySQL.
I am using two tables with various columns, but I don't know about the relationship between them.
So, I need some help for the SQL coding.
Need help in quiz z MySQL for developing Drupal.
Since your concern is only about two tables, the SQL statements should be fairly simple to write.
But since you are the developer, you should at least know the purpose of each table as well as the purpose of each column in a given table.
If the information is not available please consult with the person who developed the tables or any documentation describing the tables and columns.
If SQL is a new topic for you, I suggest you go over basic tutorials available online, especially on 4 distinct types of statements; select, insert, update, and delete.
With those 4 categories of statements you can write quite effective SQL statements to operate on the 2 tables you need to use.
Here is a link to a basic SQL tutorial online.
Hope it helps.