Akina

В голове идея создать varchar ячейку и в неё через запятую всё записывать.

CREATE TABLE words (
    word_id INT AUTO_INCREMENT PRIMARY KEY,
    word VARCHAR(255) UNIQUE NOT NULL
);

CREATE TABLE phrase (
    phrase_id INT NOT NULL,
    FOREIGN KEY (phrase_id) REFERENCES phrases (phrase_id),
    word_id INT NOT NULL,
    FOREIGN KEY (word_id) REFERENCES words (word_id),
    word_position INT,
    PRIMARY KEY (phrase_id, word_position)
);

INSERT ... VALUES ( ... , CAST(REPLACE(@value, ',', '.') AS DOUBLE), ...

SELECT for_output
FROM ( SELECT name AS film_name, name AS for_output
       FROM films
     UNION ALL
       SELECT films.name, comments.comment
       FROM films 
       JOIN comments USING (film_id) ) total
ORDER BY film_name, film_name <> for_output

CREATE PROCEDURE delete_rows()
BEGIN
    SELECT @@autocommit INTO @autocommit;
    SET SESSION autocommit = ON;
    REPEAT
        DELETE FROM bigtable WHERE state=2 LIMIT 10000;
        SELECT SLEEP(1) INTO @tmp;
    UNTIL NOT ROW_COUNT() END REPEAT;
    SET SESSION autocommit = @autocommit;
END

SELECT string_agg(concat(substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ', ceil(random() * 26)::integer, 1),
                         substring('abcdefghijklmnopqrstuvwxyz', ceil(random() * 26)::integer, 1),
                         substring('0123456789', ceil(random() * 10)::integer, 1),
                         substring('!#$%&()*+,-./:;<=>?@[]^', ceil(random() * 23)::integer, 1)
                         ),
                  '' ORDER BY RANDOM()
                  ) 
FROM generate_series(1,8);