SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl_invisible_example ( id INT ,name varchar(50) ) ENGINE = InnoDB; ALTER TABLE tbl_invisible_example ADD COLUMN dob date INVISIBLE; describe tbl_invisible_example; SHOW COLUMNS FROM tbl_invisible_example; SHOW CREATE TABLE tbl_invisible_example; insert into tbl_invisible_example values (1,'Rachel','1974-01-01'); --Fail insert into tbl_invisible_example (id,name,dob) values (1,'Rachel','1974-01-01'); --Fail SELECT * FROM tbl_invisible_example; SELECT id,name,dob from tbl_invisible_example; ALTER TABLE tbl_invisible_example ADD COLUMN age INT AS (TIMESTAMPDIFF(YEAR, dob, CURDATE())); select id,name,dob,age from tbl_invisible_example;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear