Make web site
156 Part II . SQL Essentials Figure 8-31: Using batch mode to produce output with tab delimiters Cross-Some other commands and statements such as mysqldump or SELECT INTO Reference OUTFILE may be better suited to exporting data. Those commands are discussed in Chapter 10. Creating a Useful MySQL CLI Environment With all the options covered in this chapter, you may be wondering which ones you should use and whether to set the options globally (for all users of the CLI), or only for your user account, or only in your home directory. The answers are flexible, determined by what you need your database application to do. For example, if all users on the computer use the same username to connect to a particular database, you could make that usage a global setting in the MySQL configuration file. Alternatively, if you use a particular username but everyone else uses a different one, you could specify that setting in your local or personal MySQL configuration file. Tip Programmers still debate the matter of which pager command is best for displaying results. For practicality s sake, you may want to avoid the debate by specifying that setting only in a local or personal configuration file. A useful environment for the CLI can be as complicated or as simple as you d like it to be. Ideally, you could produce a configuration file personalized for your use of the MySQL CLI. With a good configuration, you could save time and increase productivity by not having to specify the same options every time you start the CLI. A basic MySQL CLI configuration The following configuration example might be a fine starting point for anyone s use of MySQL. The configuration provides a default pager of less for results that would
Note: If you are looking for reliable webhost to maintain and run your java application check Vision java hosting services