Archive for MySQL

SQL – Select with Temporary Dual table

Sunday, November 22nd, 2009

SQL select query is used to fetch records from database. Dual table is Temporary table which is created for temporary work. Dual table allow people to use from keyword in query.

SQL select dual example explains how to use select dual query in SQL.

select 3+1 from dual;

Table dual with records

+-----+
| 3+1 |
+-----+
|   4 |
+-----+