corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » SQL Script


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author SQL Script
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
9th Jul 08 at 09:18   View User's Profile U2U Member Reply With Quote
I have a table called euser

within the table i have a column called sys_eusername and sys_email

what i need is to copy sys_eusername to sys_email and add @something.com after it.

Help me pleasee
Paul
Member
Registered: 16th Apr 02
Location: Oop north.
User status: Offline
9th Jul 08 at 09:33   View User's Profile U2U Member Reply With Quote
update euser set sys_email = sys_eusername + '@something.com'
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
9th Jul 08 at 09:35   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Paul
update euser set sys_email = sys_eusername + '@something.com'


just coming on to say i had sorted but cheers

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
people with sql tables knowledge Drew Geek Day 14 721
7th Dec 04 at 20:31
by Joff		  
Javascript function changing css? Rus Geek Day 1 646
22nd Jun 07 at 10:53
by Rus		  
FAO: Programmers barteh Geek Day 6 779
6th Nov 07 at 14:02
by barteh		  
SQL server Dan Lewis Geek Day 1 295
30th Jan 08 at 17:15
by Dan Lewis		  
System Center Configuration Manager 2007 Pablo Geek Day 13 353
6th Feb 08 at 14:39
by Pablo		  

Corsa Sport » Message Board » Off Day » Geek Day » SQL Script 29 database queries in 0.0112660 seconds