Need help in quiz z MySQL for developing Drupal.

Asked By gustavojakee 10 points N/A Posted on - 02/08/2013

Hi guys,

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.

• Status: Open
• Question Views: 621
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Parisi Petrusic 0 points N/A #198675

Need help in quiz z MySQL for developing Drupal.

Hello,

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.

 

Best Regards,

Parisi

About Parisi Petrusic

Questions
2

Answers
100

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: MySQL Server