[Tips] solutions to conflicts between field names and reserved MySQL words

We know that the general SQL query statement is written as follows: selectcolfromtable; this is of course no problem, but what if the field name is "from? Selectfromfromtable; if this is the case, an error is inevitable. When the field name conflicts with the reserved MySQL words, you can use the character "'" to enclose the field name: select 'from' fromtable;

We know that the general SQL query statement is written like this: select col from table; this is of course no problem, but what if the field name is "from? Select from table; if this is the case, errors are inevitable. When the field name conflicts with the reserved MySQL words, you can use the character "'" to enclose the field name: select 'from' from table;

We know that the general SQL query statement is written as follows:

Select col from table;

Of course this is okay, but what if the field name is "from?

Select from table;

If this is true, an error is inevitable. When the field name conflicts with the reserved MySQL words, you can use the character "'" to enclose the field name:

Select 'from' from table;

Done.

Original article address: [tips] solutions to conflicts between field names and reserved MySQL words, thanks to the original author for sharing.