create or replace view view_AllData as select c.name, concat('C',c.contact_id) as ref from contact c
On Tue, Nov 24, 2009 at 6:52 PM, Neil Aggarwal <n...@jammconsulting.com> wrote: > Hello: > > This seems like it should be simple, but I am having trouble > figuring it out. > > I have a table contact which has: > name String > contact_id int > > Lets assume the contact table has this row: > name: Neil Aggarwal > contact_id: 1 > > I want to create a view that has this data > name: Neil Aggarwal > ref: C1 > > I did this: > > create or replace view > view_AllData as > select > c.name > ('C'+c.contact_id) as ref, > from contact c > > but the ref does not have the leading 'C' in > the front of it. > > Any ideas? > > Thanks, > Neil > > -- > Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net > Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo > Unmetered bandwidth = no overage charges, 7 day free trial > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com "May you live every day of your life." Jonathan Swift Larry's First Law of Language Redesign: Everyone wants the colon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org