>>>>> "list" == list <list@stripped> writes:
list> mysqlshow doesn't show tables that have underscores in them, ie, the
list> following works:
list> mysqlshow dcse_main computer
list> but this does not:
list> mysqlshow dcse_main index_entity_12
list> and neither does this:
list> mysqlshow testfeest index_entity_12
list> SHOW COLUMS FROM however works correctly when connected to the
list> right database.
list> Create database and tables as in the examples in de description.
list> Use SHOW COLUMNS instead.
The problem is that '_' is a wildcard in SQL, and if you give a wildcard to
mysqlshow, it will use patter matching for what's shown.
From mysqlshow --help:
If last argument contains a shell wildcard (* or ?) then only what's
matched by the wildcard is shown.
If no database is given then all matching databases are shown.
If no table is given then all matching tables in database are shown
If no field is given then all matching fields and fieldtypes in table
In the case of:
mysqlshow testfeest index_entity_12
mysqlshow thinks you are asking for:
Show all table names in testfeest that matches 'index_entity_12'
mysqlshow testfeest i%
If you want the column names, you can use:
mysqlshow testfeest index_entity_12 %
(I know this isn't intuitive, but we haven't come up with anything
better to give both functionalities)