Persisted Computed Column to calculate area?

Question

I have a table (rugs) that has columns for length and width (both 2 place decimals).

I'm trying to create a computed column named area which simply multiplies the length by width to generate the area but hitting syntax errors when running the query.

My attempted code using mySQL was as follows:

alter table `rugs` add `area` as (`length` * `width`) PERSISTED

But it's not liking the syntax, getting a #1064 error

What database are you using? Please tag appropriately. – Gordon Linoff Jan 04 '18 at 16:23 — Gordon Linoff, Jan 04 '18 at 16:23
Please add to the question the errors you are getting. – Alfabravo Jan 04 '18 at 16:25 — Alfabravo, Jan 04 '18 at 16:25

score 1 · Answer 1 · answered Jan 04 '18 at 16:25

1

In MySQL, the syntax is:

alter table rug add area generated always as (length * width) stored;

The documentation explains the syntax.

Your syntax is more appropriate for SQL Server.

answered Jan 04 '18 at 16:25

Gordon Linoff

1,242,037
58
646
786

@RyanMalone . . . Generated columns were introduced in MySQL 5.7.???. Your version may not support them. – Gordon Linoff Jan 06 '18 at 07:03
@RyanMalone . . . Generated columns were introduced in MySQL 5.7.???. Your version may not support them. – Gordon Linoff Jan 06 '18 at 07:03

Persisted Computed Column to calculate area?

1 Answers1

Linked