Hello and Thanks for you help.
I would like to know if someone can help me figure out the right mysql command to move a value from a field in 1 table to another table is the record match. Here is an example.
Table A has 5 column
Lname, Fname, pos, team, points
Table B has
Lname, Fname, pos, team, total_points
I would like to update Table A points column with Table B total_points column only if Lname, and Fname match eachother.
Can anyone help me with this?
Also does anyone know how to make the a calculated number round down. EX. 1.67 round to 1 or 5.12 round down to 5.
Thanks angain.
I would like to know if someone can help me figure out the right mysql command to move a value from a field in 1 table to another table is the record match. Here is an example.
Table A has 5 column
Lname, Fname, pos, team, points
Table B has
Lname, Fname, pos, team, total_points
I would like to update Table A points column with Table B total_points column only if Lname, and Fname match eachother.
Can anyone help me with this?
Also does anyone know how to make the a calculated number round down. EX. 1.67 round to 1 or 5.12 round down to 5.
Thanks angain.