Does mysql support object datatypes as in Oracle?
ex..
This is the object (This is the SQL I need)
-- CREATE TYPE PERSON_TYPE AS OBJECT(bodyheight INTEGER, shoesize INTEGER)
This is where I want to use the object.
CREATE TABLE ACTIVITY (
CM_User_ID VARCHAR(40),
name VARCHAR(40),
customer VARCHAR(40),
description VARCHAR(40),
person PERSON_TYPE);
Thanks in advance.
ex..
This is the object (This is the SQL I need)
-- CREATE TYPE PERSON_TYPE AS OBJECT(bodyheight INTEGER, shoesize INTEGER)
This is where I want to use the object.
CREATE TABLE ACTIVITY (
CM_User_ID VARCHAR(40),
name VARCHAR(40),
customer VARCHAR(40),
description VARCHAR(40),
person PERSON_TYPE);
Thanks in advance.