SELECT
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name="table_name";
with the above query you can columns and its datatype
SELECT
column_name,
data_type
FROM
information_schema.columns
WHERE
table_name="table_name";
with the above query you can columns and its datatype