> How can they have no distinction? Suppose I write
> select 'col' from tab;
> select "col" from tab;
> If there is a column tab.col, what am I going to get in each case?
select 'col' from tab;
+-----+
| col |
+-----+
| col |
| col |
| col |
+-----+
3 rows found in set (0.00 sec)
select "col" from tab;
+-----+
| col |
+-----+
| col |
| col |
| col |
+-----+
3 rows found in set (0.00 sec)
MySQL is definitely *not* 100% SQL92 compliant.
Chris