Top Left Text cha

Web & App Development

This is useful if you need to copy all the columns of a table into your IDE, for creating a form or query, for example.  It does not include any other columns like the 'SHOW COLUMNS' statement.

SELECT column_name FROM information_schema.columns WHERE table_schema = 'DATABASE-NAME' AND table_name = 'TABLE-NAME';

Add comment

Security code

  • No comments found

Leave your comments

Post comment as a guest

Your comments are subjected to administrator's moderation.