What are some potential issues with using separate tables for different surveys in PHP?

One potential issue with using separate tables for different surveys in PHP is that it can lead to a complex database structure and make it difficult to query data across multiple surveys. One way to solve this issue is to use a single table for all surveys and include a column to differentiate between them. 

// Create a single table for all surveys with a column to differentiate between them
CREATE TABLE surveys (
    id INT AUTO_INCREMENT PRIMARY KEY,
    survey_name VARCHAR(50),
    question VARCHAR(255),
    response VARCHAR(255),
    survey_type ENUM('survey1', 'survey2', 'survey3')
);

Keywords

MySQL database normalization JOIN queries data duplication performance optimization

Related Questions