In order to create a database to hold all of the tables that are going to be used, the following command will create a database parts that can hold different tables with in it.
CREATE DATABASE parts;
Nice what if you do a typo? or what if you want to call the database something else? and whats up with the capital letter? In the case of a typo, the whole table has to be dropped, wait dropped? yes its another fancy way of saying to delete the table. If all of this terms come to shock to the system, well welcome to the world of databases, back to drop command it goes as follows.
DROP DATABASE parts;
Forgetting about the capital letter no, MySQL and SQL in general hold up the developers with a certain terminology and mythology to be used, this explains the UPPERCASE letters. After the database is deleted is gone FOREVER its not stored in the worm happy recycle bin its destroyed and now way to get it back. Be careful using the DROP command in SQL.
I always had a passion for the field of STEM (Science, Technology, Engineering, and Math) and I knew I wanted to do something to make a difference in the world. I just didn’t know where to start. I was an immigrant in a new country, grew up in a tough environment, and wasn’t sure how… Read More