MySQL creates a questionnaire form to implement the questionnaire function

MySQL creates a questionnaire table to implement the questionnaire function

When conducting a questionnaire survey, we usually need to create a questionnaire table to store question and option information, and to be able to count and analyze the answers. MySQL database is a commonly used relational database. This article will introduce how to use MySQL to create a questionnaire form and implement the questionnaire function.

1. Create database and tables

First, we need to create a database in MySQL to store questionnaire-related information. Create a database named "survey" using the following command:

CREATE DATABASE survey;

Next, we need to create a table for the questionnaire information. In this table we will store information about questions and options. Use the following command to create a table named "questions":

USE survey;

CREATE TABLE questions 
(
    id INT AUTO_INCREMENT PRIMARY KEY,
    question_title VARCHAR(255),
    option1 VARCHAR(255),
    option2 VARCHAR(255),
    option3 VARCHAR(255),
    option4 VARCHAR(255)
);

In this table, we define the title of the question and four options. The number and name of the fields can be modified according to the actual situation.

2. Insert questionnaire information

To insert question and option information into the questionnaire table, you can use the following command:

INSERT INTO questions (question_title, option1, option2, option3, option4) 
VALUES ('你喜欢的颜色是？', '红色', '蓝色', '绿色', '黄色');

INSERT INTO questions (question_title, option1, option2, option3, option4)
VALUES ('你喜欢的电影类型是？', '动作片', '喜剧片', '爱情片', '科幻片');

According to the actual situation, you can insert More questions and options.

3. Create answer table

In order to record each user's answer, we also need to create a table for storing answer information. Create a table called "answers" using the following command:

CREATE TABLE answers 
(
    id INT AUTO_INCREMENT PRIMARY KEY,
    question_id INT,
    answer VARCHAR(255)
);

In this table, we store the ID of the question and the user's answer.

4. Insert answer information

When the user completes the questionnaire answer, we need to insert the answer information into the answer table. Use the following command to insert answer information:

INSERT INTO answers (question_id, answer) VALUES (1, '红色');
INSERT INTO answers (question_id, answer) VALUES (2, '动作片');

According to the actual situation, you can insert more answer information.

5. Statistical answer results

By querying and counting the answer table, we can obtain the answer results for each question. The following is a sample code that counts answer results:

SELECT question_id, answer, COUNT(*) as count
FROM answers
GROUP BY question_id, answer;

This query statement will return the number of answers for each question and each answer.

Through the above steps, we can create a questionnaire form in MySQL and implement the questionnaire function. Users can answer questions and obtain answer results through query statements.

Summary

This article introduces how to use MySQL to create a questionnaire form and implement the questionnaire function through sample code. We can easily conduct questionnaires by creating question and answer tables, as well as inserting relevant information and statistical answer results. As a commonly used database management system, MySQL can help us store and process questionnaire data effectively.

The above is the detailed content of MySQL creates a questionnaire form to implement the questionnaire function. For more information, please follow other related articles on the PHP Chinese website!