How do I create temporary tables

Temporary tables in MySQL are used to store data temporarily during the session. They are automatically dropped when the session ends or the connection to the database is closed. Temporary tables are useful for storing intermediate results or for complex queries involving large datasets.

    -- Create a temporary table
    CREATE TEMPORARY TABLE temp_table (
        id INT NOT NULL AUTO_INCREMENT,
        name VARCHAR(100),
        PRIMARY KEY (id)
    );

    -- Insert data into the temporary table
    INSERT INTO temp_table (name) VALUES ('John Doe'), ('Jane Smith');

    -- Query data from the temporary table
    SELECT * FROM temp_table;

    -- The temporary table will be dropped automatically after the session ends