Mysql Getting Started (2) Getting Started (Add Time: 2002-3-25 Hits: 5566)
ABCCS
Getting Started article How to install and test MySQL, you can continue our learning after the environment is built. This article is primarily familiar with a common command. 1. Start the mysql server actually on the previous article how to start MySQL. Two ways: First, use WinMysqladmin if the machine is automatically run, you can go directly to the next step. The second is to run D: mysqlbinmysqld 2 in the DOS mode, enter the MySQL interactive interface in the DOS mode, run: D: mysqlbinmysql appears: mysql's prompt, which has entered the MYSQL interaction mode. If "Error 2003: can't connect to mysql server on 'localhost' (10061)", indicating that your MySQL has not started. 3, exiting the mysql operation interface In MySQL> prompts Enter Quit to exit the interactive interface at any time: mysql> Quit Bye You can also exit with Control-D. 4, first command mysql> select version (), current_date (); ------------------------------- - | Version () | Current_date () | -------------------------------- | 3.23 .25a-debug | 2001-05-17 | -------------------------------- 1 ROW IN Set (0.01 sec) mysql> This command requires the MySQL server to tell you its version number and the current date. Try to operate the above command with different casements to see how the results. The result indicates that the size of the mysql command is consistent. Exercise as follows: mysql> SELECT (20 5) * 4; MySQL> SELECT (20 5) * 4, Sin (pi () / 3); mysql> SELECT (20 5) * 4 As Result, Sin PI () / 3); (AS: Specifying a false name Result) 5, multi-line statement a command can be divided into multi-line input until a semicolon is ";": mysql> select -> user () ->, -> Now () ->; ----------------------------------------- User () | now () | ------------------------------------- - | ODBC @ localhost | 2001-05-17 22:59:15 | ----------------- --------- ---------- 1 ROW IN Set (0.06 sec) mysql> Note the use of the middle comma and the last semicolon.