Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

TStanley's scratchpad

by TStanley (Canon)
on Jun 01, 2004 at 17:37 UTC ( #358303=scratchpad: print w/ replies, xml ) Need Help??

I have a table in a database with the following columns:
############################### # ID # First_Name # Last_Name # ###############################
I need to create a query to select both the First_Name and Last Name and present them as a single entity. What I have for my query so far (which did not work) is as follows:
SELECT (personnel.First_Name,personnel.Last_Name) AS Name FROM personnel;
The error I get from the database (MySQL 5) is:
ERROR 1241 (21000): Operand should contain 1 column(s)
Can someone with better SQL-fu than myself point me in the right direction?

###############################################
The Fisher-Yates shuffle done in Ruby:
def shuffle(array) a=array.length b=a-1 c=(0..b).to_a c.reverse! for d in c e=rand(d+1) next if e==d f=array[d];g=array[e] array[d]=g;array[e]=f end return array end
The Fisher-Yates shuffle done in Python:
import random list=[0,1,2,3,4,5,6,7,8,9] def shuffle(ary): a=len(ary) b=a-1 for d in range(b,0,-1): e=random.randint(0,d) if e == d: continue ary[d],ary[e]=ary[e],ary[d] return ary print shuffle(list)

You youngin' don't know how good you have it
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (16)
As of 2014-07-14 14:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (262 votes), past polls