Thread: MySql gurus
View Single Post

  #1 (permalink)  
Old 16-11-2006, 10:13 PM
louie's Avatar
louie louie is offline
Senior Member
 
Join Date: Jan 2006
Location: Dublin, Ireland
Posts: 2,048
Nominated 5 Times in 3 Posts
Nominated TOTW/F/M Award(s): 1
louie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enoughlouie will become famous soon enough
Send a message via Yahoo to louie Send a message via Skype™ to louie
Default MySql gurus

Ok all mysql gurus, I need help here.

I have a table with few fields:

f_1, f_2, f_3, f_4

I want to run a query in mysql to get all the fields together and update the result into f_1

Update `table` set `f_1`=`f_1`. " ".`f_2`." ".`f_3`." ". `f_4`

is this possible directly on the server using Navicat?
__________________
:. Web Design & Development Web Design Ireland
:. Search Engines Optimization Search Engines Optimization
:. Directory Submission Directory Submission
:. News & Press Release Ireland GiveItSocks.com
:. Used Cars Ireland, Car Parts & Car Audio Cars For Sale, Car Parts & Accessories
:. I Have 2 Find It Directory SEF Directory
Reply With Quote