RE: command line questions

As fat as your first and last question go you can create views. create view somename as select c1,c2,c2 from table (limit 5);

and then

select from somename;

i am not familiar with the windows client but i would expect auto completion there too

olaf

-----Original Message-----
From: Olav Mørkrid [mailto:olav.morkrid@gmail.com] Sent: Sat 7/14/2007 3:38 AM
To: mysql@lists.mysql.com
Subject: command line questions  

hi, i have some questions about the command line of mysql for WIN32:

• does mysql have any macro system that lets you shorten often-used commands, like expanding "n5 mytable" into "select * from mytable order by id desc limit 5"
• how can tab completion be enabled (it does not work by default, even though auto-rehash lists as "true").
• is there any way to make mysql remember command history between each time the command line window is opened and closed?
• say you have a table with 8 columns, where one of them is a long text, then each row runs over multiple lines making the table unreable. to get a nice display, you have to type "select c1, c2, c3, c4, c5, c6, c7" which is boring to write. so is there any way to say "select [all except that wide column] from mytable"? or does mysql possibly an intelligent "fit table to screen width" function (like html tables)?

thanks!

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=steino@ccri.net

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek