mssql to mysql query conversion

Question

The below query works fine in mssql. I tried using information_schema instead of sys. But no luck in mysql.

            SELECT c.NAME AS property_name,
                   t.NAME AS datatype
            FROM   sys.columns c
            JOIN   sys.objects o
            ON     o.object_id = c.object_id
            JOIN   sys.types t
            ON     t.user_type_id = c.user_type_id
            JOIN   sys.schemas s
            ON     o.schema_id = s.schema_id
            WHERE  s.NAME ='{0}'
            AND    o.NAME ='{1}

Boris Schegolev · Accepted Answer · 2016-08-17 20:09:51Z

1

Here you go:

SELECT
    COLUMN_NAME AS property_name,
    DATA_TYPE AS datatype
FROM information_schema.columns
WHERE
    TABLE_SCHEMA = {0} AND
    TABLE_NAME = {1}
ORDER BY ORDINAL_POSITION

answered Aug 17, 2016 at 20:09

Boris Schegolev

3,7115 gold badges23 silver badges35 bronze badges

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

1 Comment

user3386325 Over a year ago

Thanks lot for the help.

Collectives™ on Stack Overflow

mssql to mysql query conversion

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related