MySQL Query Help

[azlan3522]

I have an SQL query that inserts data into my database. I'm trying to use the mysql function STDDEV_SAMP(), and it doesn't appear to work. Here it is:

$query = "INSERT INTO table (percent, deviation) VALUES ($percent, STDDEV_SAMP(percent))";

I've searched around to see if anyone has used Aggregate functions in an INSERT INTO query, but I haven't found anything that has helped me yet. Note that this is sample code that I'm using to display my problem.

[Muddy_Funster]

shouldn't it be :

$query = "INSERT INTO table (percent, deviation) VALUES ($percent, STDDEV_SAMP($percent))";

with $percent sent to both values?

[azlan3522]

That was demo code, but yes that's what I meant to say. Thanks for the clarification.

[AbraCadaver]

Why even store STDDEV_SAMP($percent) as it is calculated from $percent?  Just store $percent and calculate when you need it.

[Psycho]

<< Moving to MySQL Forum >>

 

What you are doing doesn't make sense, so I'm not sure what you are trying to accomplish. The STDDEV_SAMP() is a GROUP_BY (aggregate) function which assumes a list of values. Since $percent is also stored into the field 'percent', I assume it is a single value. So, there will not be a standard deviation. Please explain what you are trying to do and we might be able to help.

[azlan3522]

I'm sorry for the late response. I figured out the solution. Thank you all for your help, and sorry for the waste of time.