Database and How To Create at MySQL version 5.0.1

Now I want to explain about data base. base is storage or something like that, if data, is representation of real-world facts that represent an object. as a union of terms, the database itself can be defined as follows:

group of interrelated data stored together in such a way and without unnecessary repetition or redundansi, to meet a variety of needs.

now we are into direct practice, the operating system that I use is windows 7 professional. First do not forget to install the DBMS software, which I use now is mysql version 5.0.1 after that open the mysql software by clicking Start -> then typing mysql.

if install MySQL using a password, then when will access or use MySQL we have to enter a password, but if not then emptied it or do not have to be filled. Here I use the password "root".

then typing the sql command show databases;. This command is used to display all databases that have been created

Now we will create a database of the contents of the bag sales information system online. First you must  create a database with the command create databases name_database;. in this case name_database is  "penjualantasonline". so the full command create databases penjualantasonline;. after the database is created, then our selection of databases that have been made earlier, using the command use database penjualantasonline;. the function of this command to select the database that we will use, after that to make sure the database is correct, we are typing the command show tables;. The command function to display all the tables that have been created or all of an existing table in the database that has been selected, if the results show that empty table,until this step if succes means what are you doing is true, because the database is created, there are no tables.

for now, until here, the next post will be discussed further on this case, the need for tables and how to make it. good luck