create table table1
(
id INT NOT NULL,
date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
name VARCHAR(255) AS (CONCAT('Documnet ', id, ' from ', DATE_FORMAT(date, '%d.%m.%Y %H:%i'))) PERSISTENT
);
Incorrectly displays the name column.
create table table1
(
id INT NOT NULL,
date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
name VARCHAR(255) AS (CONCAT('Documnet ', id, ' from ', DATE_FORMAT(date, '%d.%m.%Y %H:%i'))) PERSISTENT
);
Please login to leave a reply, or register at first.