tailieunhanh - 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. | INTRODUCING MYSQL 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. L-Q Press Ctrl-X and then Y to save the file and exit the editor. Note This command will vary depending on your editor. You are returned to the MySQL monitor. fl Type g and press Enter. The monitor executes the query and displays the result. 0 Type SHOW TABLES and press Enter. The list of tables in the database is displayed including the new table. 27 MySQL CONFIGURE MYSQLGUI The MySQL monitor is only one of the clients you can use with a MySQL server. You can use MySQLGUI a graphical MySQL client as an alternative interface to MySQL. This utility can do most of the same things as the MySQL monitor. MySQLGUI was developed by the developers of MySQL and is available from the Downloads section of the MySQL Web page at . Binary versions of this utility are available for Windows and Linux systems. For Windows systems MySQLGUI is distributed as a ZIP file. You will need to use a program such as WinZip to extract the files from the archive. WinZip is available from the following URL .