Mysql your visual blueprint for creating open source databases- P3

Mysql your visual blueprint for creating open source databases- P3:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database.
Nội dung trích xuất từ tài liệu:
Mysql your visual blueprint for creating open source databases- P3 INTRODUCING MYSQL 1 The Windows version of the MySQL monitor does not support the e command. There are several alternative ways to deal with long MySQL commands if you are using a Windows system. The first is to type the command in a text editor, such as Notepad, select it, and use the Copy command to copy it to the clipboard, and then paste it into the MySQL monitor window. Another alternative is to use the MySQLGUI utility, a graphical interface to MySQL, described in the next section. This utility includes a text box that you can use to enter a command of any length, and then submit it to the server. It also saves the most recent queries you have performed and allows you to easily repeat them. The Windows version of the MySQL monitor can be used to connect to a MySQL server running on a UNIX system, and the UNIX version can connect to a Windows-based server. While there are slight differences in the client programs, they use the same protocols to communicate with the MySQL server.Á Press Ctrl-X and then Y Note: This command will vary s You are returned to the ° Type SHOW TABLES; andto save the file and exit the depending on your editor. MySQL monitor. press Enter.editor. ‡ Type g and press Enter. s The list of tables in the database is displayed, s The monitor executes the including the new table. query and displays the result. 27 MySQLCONFIGURE MYSQLGUI the network; it does not have to be installed on the sameT he MySQL monitor is only one of the clients you can use with a MySQL server. You can use MySQLGUI, a machine as the MySQL server software. graphical MySQL client, as an alternative interface to After you have installed the files, open the directory andMySQL. This utility can do most of the same things as the double-click the mysqlgui.exe file. MySQLGUI promptsMySQL monitor. you for a password for the root user. After you specify thisMySQLGUI was developed by the developers of MySQL, once, you can click the Options button to specify a differentand is available from the Downloads section of the MySQL username for future sessions.Web page at www.mysql.com/. Binary versions of this utility The MySQLGUI utility is also available for Linux and severalare available for Windows and Linux systems. other systems, and the source code is available. See theFor Windows systems, MySQLGUI is distributed as a ZIP file. MySQL Web site for complete instructions for installing orYou will need to use a program such as WinZip to extract compiling MySQLGUI on your system.the files from the archive. WinZip is available from the MySQLGUI allows you to send queries to the MySQL server,following URL: www.winzip.com/. display the server status, and perform other tasks. SeeTo install MySQLGUI, simply copy the files from the ZIP Chapter 6 for information about using MySQLGUI toarchive to a directory on your computer. You can use it perform a query, and see Chapter 9 for information aboutfrom any machine that can reach your MySQL server across server management using MySQLGUI. CONFIGURE MYSQLGUIs When you start MySQLGUI, ⁄ Enter the password and s The main MySQLGUI ¤ Click the Options buttonyou ...