scratchpad
TStanley
I have a table in a database with the following columns:<BR>
<CODE>
###############################
# ID # First_Name # Last_Name #
###############################
</CODE>
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:<BR>
<CODE>
SELECT (personnel.First_Name,personnel.Last_Name) AS Name
FROM personnel;
</CODE>
The error I get from the database (MySQL 5) is:
<CODE>
ERROR 1241 (21000): Operand should contain 1 column(s)
</CODE>
Can someone with better SQL-fu than myself point me in the right direction?<BR><BR>
###############################################<BR>
The Fisher-Yates shuffle done in Ruby:<BR>
<CODE>
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
</CODE>
The Fisher-Yates shuffle done in Python:<BR>
<CODE>
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)
</CODE>
<br />[id://76234]