Web site traffic
Command Line Interface (CLI) The MySQL Command-Line Interface abbreviated CLI and also known as the command-line tool is the program through which the users handle most of their daily interactions with the database. You access the CLI by issuing the mysql command. This chapter looks at some normal CLI tasks, as well as some that may not be obvious but are still useful. An introduction to the CLI lays the groundwork; before long, you can get your hands dirty with some real functions and try out some uses of the CLI. Introducing the CLI Before the advent of GUIs and third-party tools, the MySQL CLI provided the only way to interact with the database. However the CLI offers advantages over some of its newer counterparts insofar as it is tested and stable, it is lightweight, and it comes standard with most installations of MySQL. The basic syntax for to use the MySQL CLI is as follows: mysql (options) [database] The options for this command help make the MySQL CLI configurable as well as powerful. Should you forget the options and not have this book available, you can get help from the mysql command itself by adding the –helpor -? switches after you type it, as shown in Figure 8-1. 8 88 CHAPTER …. In This Chapter Introducing the CLI Starting the CLI basics Using environment variables in MySQL CLI Choosing when to use the CLI Interactive mode Configuring a useful MySQL CLI environment Avoiding common CLI user errors Listing alternatives to the CLI ….
Note: In case you are looking for affordable webhost to host and run your web application check Vision cheap hosting services