Hi.
select concat(database(),_utf8".",_utf8'table') works fine. It is not clear for me - what is the problem? You can choose charset according to your local settings. Nick Arnett <[EMAIL PROTECTED]> wrote: > I don't see a way to ask MySQL what the "full" name of a table is... the > equivalent of this: > > SELECT CONCAT(DATABASE(), ".", "table_name") > > which would return something like this (assuming the current database is > called "my_database": > > my_database.table_name > > The reason I want this is to ensure that a scripted operation isn't > treating the same table as if it were two different tables. I have a > method that moves records among tables by copying and then deleting. If > the two tables are really the same table, it'll lose the records, since > it will have copied them to the same table, then delete them. > > I can do it the way above, but I'm thinking there might be a better way... > > Thanks! > > Nick > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
