Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

command line questions

From: Olav Mørkrid <olav.morkrid(at)gmail.com>
Date: Sat Jul 14 2007 - 03:38:47 EDT


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=lists@pantek.com
Received on Sat Jul 14 03:39:37 2007

This archive was generated by hypermail 2.1.8 : Thu Aug 02 2007 - 01:57:00 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library