Medical web site
136 Part II . SQL Essentials Figure 8-4: Using the -e switch to execute a query in non-interactive mode Although it is possible to execute other commands with the -eswitch, I don t normally recommend executing DDL (Data Definition Language) commands such as ALTER TABLE with the -e switch. MySQL still prints error messages back to the command line, but I ve found that DDL commands usually require more than one command to be run (for example, a command to describe a table) before alteration can begin. Command recall reusing the command or statement you last typed by pressing the up-arrow on the keyboard is one of the best features of the MySQL CLI. This feature saves countless keystrokes when you make a typographical or spelling error in the middle of a long query and have to run it again. Additionally, command recall makes large and complex queries easier to work with; if you find that the output is not exactly as you want it, simply use the up-arrow and tweak the query when it appears on-screen. Starting the CLI the Basics By now you ve probably already been introduced to the CLI through some earlier chapters or the introduction in this chapter. Don t worry if you haven t read those chapters; the CLI itself makes only a brief appearance there. The command to start the MySQL CLI is contained normally in the bin directory of the MySQL installation. However, it may be located in another directory depending on how you installed MySQL or the operating system you are using. In Linux, I ve seen the command located in /usr/bin, /usr/local/bin, /usr/local/mysql/bin and somewhere in the /varmount.
Note: If you are looking for cheap and reliable webhost to host and run your web application check Vision coldfusion web hosting services