MySQL Lists are EOL. Please join:

 List: General Discussion « Previous MessageNext Message » From: mos Date: December 19 2005 9:09pm Subject: Re: How to Square a number? View as plain text
```At 02:32 PM 12/19/2005, Elmar von Muralt wrote:
>Mike,
>
>
>temp1 = [Expression]
>temp2 = temp1 * temp1
>
>This should be quick enough, assuming tempN are cast as integers
>
>Elmar

Nope, not quite.<g>
The expression is an expression based on columns in the table, as in:

select ((col1+col2+col3)/col4), ((col5+col6+col7)/col8) ...  table1

So it looks like I'll have to use Power(num,exp) after all to square these
expressions.

Mike

>mos wrote:
>
>>At 08:30 AM 12/19/2005, Peter Brawley wrote:
>>
>>> >        Yes, it's a bit more complicated than that. I'm using an
>>> expression
>>> >so I don't want to have to repeat the whole expression all over again.
>>>
>>>What's wrong with CAST( POWER( <expr>, 2 ) AS SIGNED )?
>>>
>>>PB
>>>
>>>------
>>
>>
>>PB,
>>         Yes it looks like I'll have to use Power() after all. From a
>> programming standpoint, I thought using a floating point function like
>> Power on an integer was inefficient and makes it harder to read the
>> exoression. But I'll give it a try. Thanks. I'm still not sure why the
>> ** operator is not supported because it would reduce the amount of code
>> considerably (I have to square quite a few numbers).  Oh well. :(
>>
>>Mike
>>
>>
>>>mos wrote:
>>>
>>>>At 05:43 PM 12/18/2005, James Harvard wrote:
>>>>
>>>>>Maybe I'm missing something, but can't you just multiply the number by
>
>>>>>itself?
>>>>>
>>>>>select (3 * 3);
>>>>>
>>>>>select (int_col * int_col) as squared from table_name;
>>>>>
>>>>>James H
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>James,
>>>>         Yes, it's a bit more complicated than that. I'm using an
>>>> expression so I don't want to have to repeat the whole expression all
>>>> over again.
>>>>
>>>>Mike
>>>>
>>>>
>>>>
>>>>
>>>>>At 5:36 pm -0600 18/12/05, mos wrote:
>>>>> >How do I square a number in MySQL 4.1? I thought it would be
>>>>> something simple like:
>>>>> >select 3**2
>>>>> >but that produces a syntax error. I can use Pow(3,2) but that
>>>>> produces a float. Is there a Square function?
>>>>>
>>>>>--
>>>>>MySQL General Mailing List
>>>>>For list archives: http://lists.mysql.com/mysql
>>>>>To unsubscribe:
>>>>>http://lists.mysql.com/mysql?unsub=1
>>>>
>>>>
>>>
>>>
>>>--
>>>No virus found in this outgoing message.
>>>Checked by AVG Free Edition.
>>>Version: 7.1.371 / Virus Database: 267.14.1/206 - Release Date: 12/16/2005
>>
>>

```