MySQL Forums
Forum List  »  Newbie

SELECT COLUMN_NAME ... into a file for printing
Posted by: Mike Lambert
Date: April 09, 2019 07:26AM

Hi,

How can I get this information either in 1 single row and into a file so that it can be printed and/or read by a program.

SELECT COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'mteams'

Thks,

Mike

Options: ReplyQuote


Subject
Written By
Posted
SELECT COLUMN_NAME ... into a file for printing
April 09, 2019 07:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.