Search

Download this Manual
PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.3Kb
Man Pages (Zip) - 378.3Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb


Search Results
MySQL 9.7 Reference Manual
Displaying 31 to 31 of 31 total results
15.1.11.2 ALTER TABLE and Generated Columns
https://dev.mysql.com/doc/refman/9.7/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to them. ALTER TABLE ...