[snip]
I'm working through (my first day) PHP MySQL for Dummies and I'm stuck
on
the primary field for my database.
I want to create a racing pigeon results database that has 6 fields
only.
The results will be imported into the database in bulk from a CSV file
Owner - GBring - Ering - Arrivedtime
I'm working through (my first day) PHP MySQL for Dummies and I'm stuck
on
the primary field for my database.
I want to create a racing pigeon results database that has 6 fields only.
The results will be imported into the database in bulk from a CSV file
Owner - GBring - Ering -
meridklt wrote:
I'm working through (my first day) PHP MySQL for Dummies and I'm stuck
on the primary field for my database.
I want to create a racing pigeon results database that has 6 fields only.
The results will be imported into the database in bulk from a CSV file
Owner - GBring -
Hi,
Try using STDDEV(), which was given for Oracle compatibility by MySQL.
SELECT employee_id, salary, hire_date, STDDEV(salary) Std Deviation of
Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id,
salary, hire_date ORDER BY hire_date;
Thanks,
ViSolve DB Team.
-