User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,671 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,036 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 942 | Replies: 2
Reply
Join Date: Mar 2007
Posts: 2
Reputation: Anaa is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Anaa Anaa is offline Offline
Newbie Poster

Question Can i merge an attribute with a calculated value??

  #1  
Mar 9th, 2007
I hav calculated a value(years).Now i want 2 merge it with an attribute of a table.So i want 2 merge ml_y and 2.then i want to find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL???
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Sep 2006
Location: NYC
Posts: 133
Reputation: sn4rf3r is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 2
sn4rf3r's Avatar
sn4rf3r sn4rf3r is offline Offline
Junior Poster

Re: Can i merge an attribute with a calculated value??

  #2  
Mar 12th, 2007
can you post your sql? dont really understand what you are asking.
Reply With Quote  
Join Date: Sep 2004
Posts: 3
Reputation: mmxx66 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
mmxx66 mmxx66 is offline Offline
Newbie Poster

Re: Can i merge an attribute with a calculated value??

  #3  
Mar 22nd, 2007
maybe the concat function is what you need.

select concat('ml_y ','2');
the result: ml_y2

hope it helps, while you post your code.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MySQL Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 2:03 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC