Keywords may be entered in any lettercase. : Introduction « Introduction « MySQL Tutorial






  1. MySQL Tutorial
  2. Introduction
  3. Introduction

The following queries are equivalent:

mysql>
mysql>
mysql> SELECT VERSION();
+---------------------+
| VERSION()           |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)

mysql> SeLeCt vErSiOn();
+---------------------+
| vErSiOn()           |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)

mysql>








1.1.Introduction
1.1.1.Connecting To Your Database
1.1.2.To test whether a connection can even be made, execute the command STATUS.
1.1.3.Keywords may be entered in any lettercase.
1.1.4.You can use mysql as a simple calculator:
1.1.5.Database, table, index, column, and alias names are identifiers.