Hello,
it is possible, to format table and column comments with newlines via create and alter statements.
Why don't show adminer these newlines in the table description?
For example:
CREATE TABLE table_test (
def_id int(10) unsigned NOT NULL COMMENT 'DefinitionsId
zweite Zeile im Kommentar
dritte Zeile im Kommentar',
PRIMARY KEY (def_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 comment 'erste Zeile Tabellenkommentar
zweite Zeile Tabellenkommentar
dritte Zeile Tabellenkommentar'
Adminer don't show the newline - see screenshot "adminer_table_description.png".
SchemaSpy (database documentation tool) show the newlines - see screenshot "schemaspy_table_description".
I would be glad if adminer the newlines can also use.
Kind regards,
kbudde
Adminer doesn't support editing comments with newlines but it at least displays them now.