TStanley's scratchpad

Public Scratchpad

I have a table in a database with the following columns:

###############################
# ID # First_Name # Last_Name #
###############################
[download]

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;
[download]

The error I get from the database (MySQL 5) is:

ERROR 1241 (21000): Operand should contain 1 column(s)
[download]

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
[download]

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)
[download]

You youngin' don't know how good you have it