In MySQL you can refer to a column using any of the following forms : Column « Select Query « MySQL Tutorial





col_name
tbl_name.col_name
db_name.tbl_name.col_name










2.7.Column
2.7.1.In MySQL you can refer to a column using any of the following forms
2.7.2.Using the full TABLE.COLUMN reference
2.7.3.Restricting Columns: Ask for only certain columns to be returned
2.7.4.Column filter and Order by clause