Faqts : Business : Databases : MySQL : Shell Commands : mysqlshow

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

19 of 20 people (95%) answered Yes
Recently 10 of 10 people (100%) answered Yes

Entry

Why does mysqlshow not display the contents of a table which has an underscore in it's name?
How do wildcard characters work in mysqlshow?

Feb 25th, 2000 11:22
Nathan Wallace, Michael Widenius


If last argument contains a shell or SQL wildcard (`*', `?', `%' or
`_') then only what's matched by the wildcard is shown.  This may cause
some confusion when you try to display the columns for a table with a
`_' as in this case `mysqlshow' only shows you the table names that
matches the pattern.  This is easily fixed by adding an extra `%' last
on the command line (as a separate argument).