SQL column name is same as Its function name

Question

There is some Data in the MySQL Workbench. Column name is Left , Right in one table .

 Select PersonNumber,Left,Right,PhotoNumbr from Person.

This query is showing is error. How can I fetch these records ,One thing cannot change column name in table.

use `\`backticks\`` – But those new buttons though.. Mar 09 '22 at 12:25 — But those new buttons though.., Mar 09 '22 at 12:25
Are you using MySQL or SQL Server? – Tim Biegeleisen Mar 10 '22 at 00:16 — Tim Biegeleisen, Mar 10 '22 at 00:16

Tim Biegeleisen · Accepted Answer · 2022-03-24T08:35:21.433

2

Escape in square brackets the column names which are coincident with SQL Server functions:

SELECT PersonNumber, [Left], [Right], PhotoNumbr
FROM Person;

For future reference, do not name your columns using keyword or function names.

edited Mar 24 '22 at 08:35

answered Mar 09 '22 at 12:24

Tim Biegeleisen

It is not working , it is returning LEFT and RIGHT column as column value. – Bachas Mar 09 '22 at 16:50
SELECT PersonNumber, [Left], [Right], PhotoNumbr FROM Person; , after this, Query is working fine – Bachas Mar 09 '22 at 17:04
above mention answer is wrong .Please change it – Bachas Mar 24 '22 at 08:27
yes ,Now it is correct Please close it. – Bachas Mar 24 '22 at 15:44

1 Answers1