UPDATE lot of registers

["Emiliano Boragina" <emiliano.boragina@xxxxxxxxx>]

Hello everyone?

 

I dont know how to update a lot of registers on one table.

 

I have two tables: Students and Signatures

 

STUDENTS has got: id / name / signature

SIGNATURES has got: id / name / classroom

 

I want to use words and not numbers to write the signature on the STUDENTS
table.

I?ve got a long list with signatures, and I must to change one signature...
How do I do update SIGNATURE AND STUDENTS tables o sam time if 100 students
has got the same signature and must update automatically?

 

Thanks a lot

 

+                                                                          _
   // Emiliano Boragina _
   // Diseño & Comunicación //////////////////
+                                                                          _
   // emiliano.boragina@xxxxxxxxx  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _