Skip to content
Advertisement

CREATE TYPE on MySQL

I couln’t create a new data type on MySQL. Query is given below

CREATE TYPE PERSON AS OBJECT
(NAME       VARCHAR (30),
 SSN        VARCHAR (9));

How can I do that on MySQL

Advertisement

Answer

You cannot. MySQL doesn’t have user-defined types. (At least, not in current versions.)

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement