MySQL query table field name, field type

in mysql •  7 years ago 

select column_name,column_comment,data_type

from information_schema.columns

where table_name='tableName' and table_schema='databaseName'

mysql field type
7 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.00
    1 vote
    0
    Authors get paid when people like you upvote their post.
    If you enjoyed what you read here, create your account today and start earning FREE STEEM!