Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Database comment/description in MySQL

Tags:

mysql

Is posible to save extra text information (comment, desctiption, etc...) about databases in MySQL.

Something like:

SELECT TABLE_COMMENT FROM information_schema.TABLES

but for database, not table?

like image 347
sirsimon Avatar asked Nov 10 '22 19:11

sirsimon


1 Answers

No you cant. Mysql allows comments only for tables and columns. You would need to store it somewhere else (maybe create something like information_schema with comments).

like image 135
Dukecz Avatar answered Nov 14 '22 22:11

Dukecz