Computing

Update one table from another, uses an implicit join

UPDATE table1 AS A, table2 AS B 
    SET A.fieldx = B.fieldz
    WHERE A.field7 = B.field3 and A.field2 = 'not me'  --  etc...

Make the firsct character of the value of a field upper-case

  
UPDATE Valor.creatures_agnosticstats
SET `size` = CONCAT(UCASE(LEFT(`size`, 1)), SUBSTRING(`size`, 2));

desc

desc

desc

desc

desc