MySQL Developing And Programming Blog

do not fear. You only need to enter a semicolon on the next line and press Enter to complete your SQL statement. That being said, let s take a look at the output and see what you have: +———-+ | Database | +———-+ | mysql | | test | +———-+ 2 rows in set (0.05 sec) Some nicely formatted ASCII for you. Here you can see that you are listing the databases, seen in the title of the column at the top of the return. You also see that you have two active databases: mysql and test. WARNINGDon t delete the mysql database. This contains all of your system variables, users, andprivileges. The test database was created during your installation procedure and is provided here so you can see that everything is functioning normally. Next, try deleting your test database. Use this command: DROP DATABASE test; Notice here that you are using uppercase (CAPS) to express SQL commands, as we discussed earlier in this chapter. You should know that the actual commands are case insensitive, mean- ing you can use upper, lower, or mixed case. The names of databases, tables, columns, and so on are case sensitive. We express the statements by using uppercase for syntax for readability purposes only. With that out of the way, let s break down your statement. First you have DROP, which tells MySQL you will be dropping something, or removing it. Next you tell MySQL what type of thing you are dropping. In this case you are dropping a DATABASE. Finally, you tell MySQL which database you are dropping: test. You will be returned a single-row message, as follows: Query OK, 0 rows affected (0.36 sec) That s all there is to it. Now that it s gone, however, you need a new one. Use this command: CREATE DATABASE test; Here you have the same format as DROP but you have replaced the command with CREATE. The preceding statement will create a new, empty database named test and print out the following message letting you know everything was successful: Query OK, 1 row affected (0.02 sec)
Note: If you are looking for inexpensive but high quality provider to host and run your jsp application check Astra jsp hosting services