RE: User Defined Types

2009-07-28 Thread Gavin Towey
Nope

-Original Message-
From: Jeff Lanzarotta [mailto:delux256-my...@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 
confidential information. It is intended only for the use of the person(s) 
named above. If you are not the intended recipient, you are hereby notified 
that any review, dissemination, distribution or duplication of this 
communication is strictly prohibited. If you are not the intended recipient, 
please 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=arch...@jab.org



RE: User Defined Types

2009-07-28 Thread Jeff Lanzarotta
Darn, oh well.

Thanks for the quick response.

--- On Tue, 7/28/09, Gavin Towey gto...@ffn.com wrote:

From: Gavin Towey gto...@ffn.com
Subject: RE: User Defined Types
To: delux256-my...@yahoo.com delux256-my...@yahoo.com, 
mysql@lists.mysql.com mysql@lists.mysql.com
Date: Tuesday, July 28, 2009, 2:39 PM

Nope

-Original Message-
From: Jeff Lanzarotta [mailto:delux256-my...@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 
confidential information. It is intended only for the use of the person(s) 
named above. If you are not the intended recipient, you are hereby notified 
that any review, dissemination, distribution or duplication of this 
communication is strictly prohibited. If you are not the intended recipient, 
please contact the sender by reply email and destroy all copies of the original 
message.