Hello.
What about using SELECT @@global.xxx? It returns only one column. See: mysql> select @@global.old_passwords; +------------------------+ | @@global.old_passwords | +------------------------+ | 1 | +------------------------+ [EMAIL PROTECTED] wrote: > Hello all, > This may be a little bit off topic for MySQL newsgroup but here > goes.....I'm trying to retrieve variables such as basedir and datadir. > PERL/DBI returns 2 rows for each varialbe. The first is the name and the > second is a value. Is there a way to get PERL/DBI to return each variable as > 1 row. > > Thanks in advance, > George > > __________________________________________________________________ > Switch to Netscape Internet Service. > As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register > > Netscape. Just the Net You Need. > > New! Netscape Toolbar for Internet Explorer > Search from anywhere on the Web and block those annoying pop-ups. > Download now at http://channels.netscape.com/ns/search/install.jsp > -- 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]