mysql inner join two tables with int and enum data type

Question

How to join two table table with different data types? in the first table status field type is enum and in second table it is int, how i can join these tables

Could you give an example of what the tables look like? (schemas/contents) — Joachim Isaksson
– Joachim Isaksson, Commented Apr 19, 2012 at 12:42
Really it should just be an INT in both columns. Normally an ENUM would be used for storing strings where there are only specific strings used. — Simon at The Access Group
– Simon at The Access Group, Commented Apr 19, 2012 at 12:42
Just try the with joins on those columns and see if there is any issue. ENUM values are anyways integer and so should not be a issue joining them with a int field (That's a Guess though). — Rahul
– Rahul, Commented Apr 19, 2012 at 12:45

Packet Tracer · Accepted Answer · 2012-04-19 13:42:47Z

1

Enum type is stored by MySQL as an int, so you can do the join as usual. But in case both fields were different you should cast one of them to make their types match if possible (usually with cast functions http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html)

answered Apr 19, 2012 at 13:42

Packet Tracer

3,9244 gold badges28 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

mysql inner join two tables with int and enum data type

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related