Hi!

Andras> if you ask from mysqlshow to show me the tables of a database with an Andras> underscore "_" in it's name: Andras> []#mysqlshow samp_db -u user -ppassword Andras> mysqlshow it's taking "_" as a wildcard and returning the database Andras> name, instead of the names of it's tables. Andras> I couldn't find any command-line options to change this behavior, and Andras> "samp_db" is a database name from reference book from Paul DuBois. Andras> I'm using Redhat linux and MYSQL .23, but I don't think this is Andras> platform dependent. Andras> Andras

Try adding an extra '%' to the command line !

From mysqlshow --help:

----- If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown.

-----

From the MySQL manual:

------ If the last argument contains a shell or SQL wildcard (@code{*}, @code{?}, @code{%} or @code{_}) 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 @code{_} as in this case @code{mysqlshow} only shows you the table names that matches the pattern. This is easily fixed by adding an extra @code{%} last on the command line (as a separate argument).

--------

Regards, Monty