Top Left Text cha

Website Development Services

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
Refresh

  • No comments found

Leave your comments

Post comment as a guest

0
Your comments are subjected to administrator's moderation.
X