Uppercase a specific column in multy table SELECT (MySQL)
I'm trying to show a specific column all in uppercase, but I can´t do while selecting multiples tables. Thanks for your help.
table_1
id - name - last_name
table_2
id - person_id - amount
SELECT * FROM table_1, table_2, UPPER(table_1.name) WHERE table_1.id = table_2.person_id
选定的列首先(表格)
SELECT table_1.*, table_2.*, UPPER(table_1.name) as nameUpper FROM table_1, table_2 WHERE table_1.id = table_2.person_id
链接地址: http://www.djcxy.com/p/72724.html
上一篇: 将一个浮点移动到一个xmm寄存器