User Defined Types

--0-43186713-1248806216=:74391
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,

I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.

This may have been discussed before but I have not been able to find it. In=
SQL Server you are able to define a user-defined type like this:

CREATE TYPE [dbo].[status] FROM INT NOT NULL

This will allow you to then define columns like this:

CREATE TABLE [dbo].[tableName]
(
  =A0 [statusColumn] [dbo].[status]
)

Is there such a thing in MySQL?

Thanks,

Jeff

--0-43186713-1248806216=:74391--

RE: User Defined Types

Nope

-----Original Message-----
From: Jeff Lanzarotta [mailto:delux256-mysql@yahoo.com]
Sent: Tuesday, July 28, 2009 11:37 AM
To: mysql@lists.mysql.com
Subject: User Defined Types

Hello,

I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.

This may have been discussed before but I have not been able to find it. In=
SQL Server you are able to define a user-defined type like this:

CREATE TYPE [dbo].[status] FROM INT NOT NULL

This will allow you to then define columns like this:

CREATE TABLE [dbo].[tableName]
(
[statusColumn] [dbo].[status]
)

Is there such a thing in MySQL?

Thanks,

Jeff

The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: User Defined Types

--0-1584797108-1248806473=:6502
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Darn, oh well.

Thanks for the quick response.

--- On Tue, 7/28/09, Gavin Towey wrote:

From: Gavin Towey
Subject: RE: User Defined Types
To: "delux256-mysql@yahoo.com" , "mysql@lists.mys=
ql.com"
Date: Tuesday, July 28, 2009, 2:39 PM

Nope

-----Original Message-----
From: Jeff Lanzarotta [mailto:delux256-mysql@yahoo.com]
Sent: Tuesday, July 28, 2009 11:37 AM
To: mysql@lists.mysql.com
Subject: User Defined Types

Hello,

I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.

This may have been discussed before but I have not been able to find it. In=
SQL Server you are able to define a user-defined type like this:

CREATE TYPE [dbo].[status] FROM INT NOT NULL

This will allow you to then define columns like this:

CREATE TABLE [dbo].[tableName]
(
=A0 =A0 [statusColumn] [dbo].[status]
)

Is there such a thing in MySQL?

Thanks,

Jeff

The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--0-1584797108-1248806473=:6502--