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:[EMAIL PROTECTED] 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/[EMAIL PROTECTED]
