Web host music
150 Part II . SQL Essentials Figure 8-23: Here the Tee function has saved session data in the file. Printing output in HTML format Though using the CLI in non-interactive mode is generally the more useful approach, sometimes you may want to run a simple query and then copy and paste its output into a Web page as HTML output. To do so, use the -Hor –htmlswitch (or put the word htmlin your MySQL configuration file under the [mysql]section). Suppressing column names At times I ve found it useful to run a query without having the column names print in the output. From within the CLI, this technique can sometimes prevent some confusion by keeping the output from wrapping around on-screen. As with the switch that produces HTML output, this function may be best used in non-interactive mode though it s sometimes useful in interactive mode as well. To suppress column names, start the MySQL CLI with the -N or –skip-columnnames switch. To make this suppression permanent, add skip-column-namesto your MySQL configuration file in the [mysql] section. Using batch mode to produce tab delimited output The MySQL CLI also operates in a batch mode that suppresses traditional feedback from the CLI and presents query output in tab-delimited format (see Figure 8-24). If you enter batch mode and get an error message, the session is immediately terminated. You are sent back to the shell with an echo of the error message (as shown in Figure 8-25).
Note: If you are looking for cheap and reliable webhost to host and run your web application check Vision coldfusion web hosting services