RE: Setting the value for the EDITOR variable
That would apply across all users then, wouldn't it? What if I wanted to set it on a per user basis, but only for the MySQL sessions? Thanks, George> Date: Wed, 28 Jan 2009 00:47:07 -0800> Subject: Re: Setting the value for the EDITOR variable> From: vegiv...@tuxera.be> CC: mysql@lists.mysql.com> > You need to set that in the script that starts your mysql daemon, probably> /etc/init.d/mysql or something similar.> > On Tue, Jan 27, 2009 at 3:44 PM, Xristos Karvouneas> wrote:> > >> > Dear All,> >> > I would like to be able to do that from the cnf file, as I want to have a> > different editor for MySQL commands than the one I use when writing shell> > scripts. When I put the following in the .my.cnf file,> > [shell]> > EDITOR=/usr/local/bin/pico> > export EDITOR> >> > I get no error messages when mysql starts up, but the value of the EDITOR> > variable does not change.> >> > Is there any way I can achieve that from the cnf file?> >> > Thanks,> > Xristos> > _> > Show them the way! Add maps and directions to your party invites.> > http://www.microsoft.com/windows/windowslive/events.aspx> > > > > -- > Celsius is based on water temperature.> Fahrenheit is based on alcohol temperature.> Ergo, Fahrenheit is better than Celsius. QED. _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
Setting the value for the EDITOR variable
Dear All, I would like to be able to do that from the cnf file, as I want to have a different editor for MySQL commands than the one I use when writing shell scripts. When I put the following in the .my.cnf file, [shell] EDITOR=/usr/local/bin/pico export EDITOR I get no error messages when mysql starts up, but the value of the EDITOR variable does not change. Is there any way I can achieve that from the cnf file? Thanks, Xristos _ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/events.aspx
Re: Query Problem
The code for generating the tables is shown below: create table book ( bookid char(12) not null, dimensions char(15), availability char(30), booktype char(20), publisher char(20), isbn char(20), itemsinstock int(3), price float(5,2), title char(50), toc char(24), picture char(36), primary key (bookid)); create table author ( authorid char(12) not null, name char(24), primary key (authorid)); create table authorbook ( bookid char(12) not null references book, authorid char(12) not null references author, primary key(bookid,authorid)); Basically, I want to get it in the format specified in the message, i.e. if the title is the same, I do not want it to be printed again... Any ideas? From: gerald_clark <[EMAIL PROTECTED]> To: Xristos Karvouneas <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Query Problem Date: Tue, 15 Mar 2005 14:49:45 -0600 Xristos Karvouneas wrote: Dear All, I am faced with the following problem: I have got three tables - book,author and authorbook - containing information about books and authors (some books have multiple authors). I want to do a query that would print information like: Title 1 Author 1 Author 2 Title 2Author 3 Author 4 I have written the following: select distinct title, name from authorbook,book,author where authorbook.authorid=author.authorid and book.bookid=authorbook.bookid; You want to add: ORDER BY title,name; You probably are getting them all, but not in the order you expect. hoping that it will do what I want, but I am only getting the first author for each book (probably because of the distinct keyword). Is there any way I can modify the query so that it does what I want it to do? I look forward to hearing from you soon. Thanks in advance. George _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Problem
The code for generating the tables is shown below: create table book ( bookid char(12) not null, dimensions char(15), availability char(30), booktype char(20), publisher char(20), isbn char(20), itemsinstock int(3), price float(5,2), title char(50), toc char(24), picture char(36), primary key (bookid)); create table author ( authorid char(12) not null, name char(24), primary key (authorid)); create table authorbook ( bookid char(12) not null references book, authorid char(12) not null references author, primary key(bookid,authorid)); Basically, I want to get it in the format specified in the message, i.e. if the title is the same, I do not want it to be printed again... Any ideas? From: sol beach <[EMAIL PROTECTED]> Reply-To: sol beach <[EMAIL PROTECTED]> To: Xristos Karvouneas <[EMAIL PROTECTED]> Subject: Re: Query Problem Date: Tue, 15 Mar 2005 12:33:24 -0800 http://www.catb.org/~esr/faqs/smart-questions.html It would help a lot to get answers if you shared the description of all three tables. On Tue, 15 Mar 2005 22:17:52 +0200, Xristos Karvouneas <[EMAIL PROTECTED]> wrote: > Dear All, > > I am faced with the following problem: I have got three tables - book,author > and authorbook - containing information about books and authors (some books > have multiple authors). I want to do a query that would print information > like: > > Title 1 Author 1 > Author 2 > > Title 2Author 3 > Author 4 > > I have written the following: > > select distinct title, name > from authorbook,book,author where > authorbook.authorid=author.authorid and > book.bookid=authorbook.bookid; > > hoping that it will do what I want, but I am only getting the first author > for each book (probably because of the distinct keyword). > > Is there any way I can modify the query so that it does what I want it to > do? > > I look forward to hearing from you soon. > > Thanks in advance. > > George > > _ > Express yourself instantly with MSN Messenger! Download today it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Problem
Dear All, I am faced with the following problem: I have got three tables - book,author and authorbook - containing information about books and authors (some books have multiple authors). I want to do a query that would print information like: Title 1 Author 1 Author 2 Title 2Author 3 Author 4 I have written the following: select distinct title, name from authorbook,book,author where authorbook.authorid=author.authorid and book.bookid=authorbook.bookid; hoping that it will do what I want, but I am only getting the first author for each book (probably because of the distinct keyword). Is there any way I can modify the query so that it does what I want it to do? I look forward to hearing from you soon. Thanks in advance. George _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
