I had the same behavior when I substituted this line using char(10) for the line that used '\n' . The query sent from the file still just prints the '\n' instead of interpreting it.
select Concat('\n', Honorific, ' ' ,First, ' ', Middle, '. ', Last, ' ', Suffix, ' (', spouse, ')', char(10), house, ' ', street, ' ', streetType, char(10), city, ', ', state, ' ', zip, char(10)) as supporter from cert.persons order by last,first limit 3; On Sun, 2007-04-29 at 08:14 -0700, Gordon wrote: > Just one suggestion re the behavior of special characters between file > input and command line input. Try using char(10) {I think that is new > line} instead of \n. That should work in both scenerios. > > -----Original Message----- > From: John Kebbel [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 28, 2007 7:19 AM > To: mysql@lists.mysql.com > Subject: Giving Back...Well, Maybe > > I don't have enough MySQL knowledge to contribute much to this > mailing > list, but as a 23 year veteran teacher, I have some expertise when it > comes to developing methods of instruction (especially > self-instruction). While studying for the MySQl CMDEV exam, I created a > method for MySQL skill-building that may help others trying to master > MySQL systematically. > > I had been building my expertise with queries by redirecting > commands > from a text file into MySQL. When I discovered MySQL comments through > this mailing list, I realized I could store my learning by putting an > active command I was testing at the top line of my text document, and my > previously tested commands below them inside a commented out area. This > morning I went a step further when I realized I could embed XHTML coding > inside MySQL comments and have a dual-purpose page, a page that (1) lets > me test queries by redirecting them to MySQL on my local computer, and > then (2) stores the tested queries inside commented-out areas in a > format I can post on the web. > > The web page format allows me to review what I've done and lets > me > continue my research at home or work by downloading, testing and > expanding, then uploading my new research. > > I hope someone finds the concept useful. What I've accomplished > so far > is at > > http://scripting-solutions.com/certifications/mysql/dothis.html > > Thanks to everyone who has been of help to me here now and in the > future. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]