Pmiguelfpereira
9/21/2016 - 3:41 PM

Mysql Querys

Mysql Querys

SQL JOINS

https://www.sitepoint.com/understanding-sql-joins-mysql-database/
Todas Minusculas mas a 1 Maiúsculas 

REf:http://stackoverflow.com/questions/14251380/how-to-lowercase-the-whole-string-keeping-the-first-in-uppercase-in-mysql

UPDATE `Tabela1` SET nome= CONCAT(UCASE(LEFT(nome, 1)), LCASE(SUBSTRING(nome, 2)))