MySql TABLE data type

Question

MS SQL Server has a TABLE data type which can be used in stored procedures,

Does anybody know if MySQL has an equivalent data type?

I've had a look over the docs but can't seem to find anything, so I presume it doesn't exist, but perhaps somebody has created a workaround

Konrads · Accepted Answer · 2010-06-01 10:24:44Z

2

Neil,

MySQL has no such data type and I believe it is good that it doesn't. To achieve similar results, use CREATE TEMPORARY TABLE construction. Name clashes are avoided by having per connection temporary tables:

A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.)

Hope it helps.

answered Jun 1, 2010 at 10:24

Konrads

2,3064 gold badges31 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Neil Aitken Over a year ago

Thanks. I'm familiar with temporary tables, and did consider them in this case. I was just checking if there was native type that may have a lower overhead. I will see if they work with what i'm attempting here.

Shane LeBlanc Over a year ago

Are you able to send a datatable into a stored procedure like in MSSQL?

Collectives™ on Stack Overflow

MySql TABLE data type

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related