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寄存器

下一篇: 大写多表中的特定列SELECT(MySQL)