1826 posts Time is what you desire most, but waste carelessly.
  • Became a Top 20 Author of the Month
  • Had an item that became a weekly top seller
  • Has sold $250,000+ on Envato Market
  • Elite Author: Sold more than $75,000 on Envato Market
+8 more
Firsh
says

I’m trying to query the comments on a table by this query:

SELECT table_comment FROM information_schema.tables WHERE table_name = 'myspecifiedname'

But it doesn’t seem to work. Any ideas?

What’s this for: I’m storing a ‘nice name’ of the tables (tables are items in the system) without _ and with ( and ) and – characters that if I included them in my table names these chars would mess them up. Or I should just create my own table for these kind of ‘settings’ and table name and nice name pairs? That seems so manual. Entering the nice name to the comments field is so easy..

499 posts
  • Has referred 1+ members
  • Has sold $1,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Located in Canada
+2 more
TutelageSystems
says

Firsh, what is the MySQL error that is being returned (or just zero rows)?

It is working for me perfectly. I am running MySQL 5.0.77

1826 posts Time is what you desire most, but waste carelessly.
  • Became a Top 20 Author of the Month
  • Had an item that became a weekly top seller
  • Has sold $250,000+ on Envato Market
  • Elite Author: Sold more than $75,000 on Envato Market
+8 more
Firsh
says

Well it appears my query was good, the result fetching had an error. I ran the query in SQL maestro and checked the column name (table_comment). For some reason I wasn’t using this when outputting the result. My bad. But thanks for the confirmation that I did it right (I couldn’t find a useful page via google..) I was just tired and overlooked something. Somebody please close the thread.

by
by
by
by
by
by