Re: Using AI Tools to Generate Dynamic Text for MySQL Applications

[Ammara ammaraamer]

Yeah, we've dealt with this at tkxel before. Best approach: keep content and styling separate. Store raw AI-generated text in one table, and font/style info (family, weight, size, color) in a separate table or JSON column referencing it. Don't store font files in MySQL, just reference them (CDN/Google Fonts/path).

CREATE TABLE content_items (
id INT PRIMARY KEY AUTO_INCREMENT,
content_text TEXT,
content_type VARCHAR(50)
);

CREATE TABLE content_styles (
id INT PRIMARY KEY AUTO_INCREMENT,
content_id INT,
font_family VARCHAR(100),
font_weight VARCHAR(20),
color VARCHAR(20),
FOREIGN KEY (content_id) REFERENCES content_items(id)
);