Re: command line questions

2007-07-14 Thread mos
At 01:38 AM 7/14/2007, Olav Mørkrid wrote: 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 completio

RE: command line questions

2007-07-14 Thread Stein, Olaf
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ørkr