Alias column for constant time value

     
mysql>
mysql> CREATE   TABLE MATCHES
    ->         (MATCHNO        INTEGER      NOT NULL,
    ->          TEAMNO         INTEGER      NOT NULL,
    ->          EmployeeNO       INTEGER      NOT NULL,
    ->          WON            SMALLINT     NOT NULL,
    ->          LOST           SMALLINT     NOT NULL,
    ->          PRIMARY KEY    (MATCHNO)            );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO MATCHES VALUES ( 1, 1,   6, 3, 1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 2, 1,   6, 2, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 3, 1,   6, 3, 0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 4, 1,  44, 3, 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 5, 1,  83, 0, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 6, 1,   2, 1, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 7, 1,  57, 3, 0);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 8, 1,   8, 0, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES ( 9, 2,  27, 3, 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES (10, 2, 104, 3, 2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES (11, 2, 112, 2, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES (12, 2, 112, 1, 3);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES (13, 2,   8, 0, 3);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT   MATCHNO AS PRIMKEY,
    ->          80 AS EIGHTY,
    ->          WON - LOST AS DIFFERENCE,
    ->          TIME('23:59:59') AS ALMOST_MIDNIGHT,
    ->          'TEXT' AS TEXT
    -> FROM     MATCHES
    -> WHERE    MATCHNO <= 4;
+---------+--------+------------+-----------------+------+
| PRIMKEY | EIGHTY | DIFFERENCE | ALMOST_MIDNIGHT | TEXT |
+---------+--------+------------+-----------------+------+
|       1 |     80 |          2 | 23:59:59        | TEXT |
|       2 |     80 |         -1 | 23:59:59        | TEXT |
|       3 |     80 |          3 | 23:59:59        | TEXT |
|       4 |     80 |          1 | 23:59:59        | TEXT |
+---------+--------+------------+-----------------+------+
4 rows in set (0.00 sec)

mysql>
mysql> drop table matches;
Query OK, 0 rows affected (0.00 sec)

mysql>

Related examples in the same category

1.	Get Current time
2.	Extract the entire time value by using the TIME() function: TIME()
3.	Comparing Times to One Another
4.	TIME type column
5.	Compare time value
6.	Calculates the sum of the two TIME values
7.	Return the total working time, using SUM.

Alias column for constant time value : Time « Date Time « SQL / MySQL

Related examples in the same category