Creating a Struct in MySQL

Question

I want to create a struct like this in MySQL:

CREATE TYPE EMP_DATA(
    SSN Number(9),
    FirstName VARCHAR(20),
    LastName VARCHAR(20),
    Salary NUMBER(9,2)
);

But it keeps telling me that I have an SQL syntax. I cannot find on the web how to create user-defined types in MySQL. How do I go about doing this?

Answer 1

MySQL does not support User-Defined Datatypes.

The available ones are HERE.