Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Mysql command to move a value from 1 table to another table

Quote Reply
Mysql command to move a value from 1 table to another table
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.