[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: Giving Back...Well, Maybe
From:       John Kebbel <kebbelj () scripting-solutions ! com>
Date:       2007-04-29 15:43:51
Message-ID: 1177861431.1260.15.camel () kebbelj-laptop
[Download RAW message or body]

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:kebbelj@scripting-solutions.com] 
> 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/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]