|
|
|
|
| |
There are ways to set up your account so you don't have to type in connection parameters each time you run mysql. These are discussed in the "Tips for Interacting with mysql" section later in this chapter. The most common method for simplifying the connection process is to store your connection parameters in an option file. You may want to skip ahead to that section right now to see how to set up such a file.
Issuing Queries
After you're connected to the server, you're ready to issue queries. This section describes some general things you should know about interacting with mysql.
To enter a query in mysql, just type it in. At the end of the query, type a semicolon character (';') and press Enter. The semicolon tells mysql that the query is complete. After you've entered a query, mysql sends it to the server to be executed. The server processes the query and sends the results back to mysql, which displays the result for you.
The following example shows a simple query that asks for the current date and time:
mysql> SELECT NOW();
---------------------
NOW()
---------------------
2002-09-01 13:54:24
---------------------
1 row in set (0.00 sec)
|
|
|
|
|
|
| Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist |
|
