CREATE TABLE tbl (
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
ext VARCHAR(255) NOT NULL,
url VARCHAR(255) NULL
);
INSERT INTO tbl (ext, url) VALUES ("jpg", CONCAT(id, ".", ext));
Простой
