Relasional Database manajement system with MYSQL

What Is Mysql?

MySQL, the most popular Open Source SQL database, is provided by MySQL AB. MySQL AB is a commercial company that builds is business providing services around the MySQL database. See section 1.2 What Is MySQL AB.

MySQL is a database management system.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL. Since computers are very good at handling large amounts of data, database management plays a central role in computing, as stand-alone utilities, or as parts of other applications.

MySQL is a relational database management system.

A relational database stores data in separate tables rather than putting all the data in one big storeroom. This adds speed and flexibility. The tables are linked by defined relations making it possible to combine data from several tables on request. The SQL part of MySQL stands for "Structured Query Language" - the most common standardized language used to access databases.

MySQL is Open Source Software.

Open source means that it is possible for anyone to use and modify. Anybody can download MySQL from the Internet and use it without paying anything. Anybody so inclined can study the source code and change it to fit their needs. MySQL uses the GPL (GNU General Public License) http://www.gnu.org, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL into a commercial application you can buy a commercially licensed version from us.

Why use MySQL?

MySQL is very fast, reliable, and easy to use. If that is what you are looking for, you should give it a try. MySQL also has a very practical set of features developed in very close cooperation with our users. You can find a performance comparison of MySQL to some other database managers on our benchmark page. See section 12.7 Using Your Own Benchmarks. MySQL was originally developed to handle very large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Though under constant development, MySQL today offers a rich and very useful set of functions. The connectivity, speed, and security make MySQL highly suited for accessing databases on the Internet.

The official way to pronounce MySQL is ``My Ess Que Ell'' (not MY-SEQUEL). But we try to avoid correcting people who say MY-SEQUEL.

HISTORY OF MYSQL

We once started out with the intention of using mSQL to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing we came to the conclusion that mSQL was not fast enough nor flexible enough for our needs. This resulted in a new SQL interface to our database but with almost the same API interface as mSQL. This API was chosen to ease porting of third-party code.

The derivation of the name MySQL is not perfectly clear. Our base directory and a large number of our libraries and tools have had the prefix ``my'' for well over 10 years. However, Monty's daughter (some years younger) is also named My. So which of the two gave its name to MySQL is still a mystery, even for us.

To start learning mysql, that we should do first mengintal phptriad or MySql. In this time because the author is using MySql more easily in the super.
Once we install MySql, now we will do configuration prior to the system can run smoothly. That we must, among other configuration:
1. Httpd.ini found on the C: \ MySql \ apache \ conf. configuration is done on:
a. DocumentRoot (DocumentRoot "C: / MySql / htdocs"): The directory out of which you will serve yourdocuments. By default, all requests are taken from this directory, but symbolic links and aliases may be used to point to other locations.
b. Directory (): This should be changed to whatever you set DocumentRoot to.
2. Php.ini found on the C: \ MySql \ php. Configuration is done on:
a. asp_tags: Allow ASP-style <%%> tags. To enable asp_tags, we simply change asp_tags = off into asp_tags = on and then save.
b. error_reporting = E_ALL & ~ E_NOTICE
1. E_ALL: All errors and warnings (does not include E_STRICT)
2. ~ E_NOTICE: not run-time Notices (these are warnings which often result from a bug in your code, but it's possible that it was intentional (eg, using an uninitialized variable and relying on the fact it's automatically initialized to an empty string).
c. Windows Extensions: Note that ODBC support is built in, so no more is needed for it. Note that many DLL files are located in the extensions / (PHP 4) ext / (PHP 5) extension folders as well as the Separate PECL DLL download (PHP 5). Be sure to appropriately set the extension_dir Directive. Activate the extension = php_mysql.dll to remove the sign ";" the didepannya.
3. In the C: / MySql, enable setup_xampp.bat, mysql_start. Apache_stat.bat and paddle, with double-clicking the file.
4. My.ini found on the C: \ Windows \ system32. Configuration is done on:
a. Basedir
b. Datadir

Once we do the configuration, it is time to start creating databases with mysql. Running mysql for the first time, heck,
1. Open cmd (Command Prompt) how open the menu Run and type in "cmd".
2. Type cd \
3. Mysql are on the MySql \ mysql \ bin, MySql type cd \ mysql \ bin.
4. Daemon do with the first menetikkan mysqld.
5. Login with the root user, how to type mysql-u root-p-h localhost then enter
6. If the password has not been set, then simply press enter, but if it is terset, enter the password. We will get the message "welcome"
7. To know the databases that exist in the root user, type show databases;
8. To use the databases that exist, type the name of database use with end with a semicolon (;), for example: use mysql;
9. To find out what the table are listed in the database that we use, type show tables;
10. To view the columns from a table, type describe or show columns from the table followed by the name we want to see. Example: describe the user; or show columns from the user;
11. To view the contents of a table, select type (the name column out that we want to loamy) from the name tablenya.contoh: select user, password, host from user;
12. Create a new database: create a database (the database name). Example: create a database students;
13. Removing the database, type drop database (database name). Example: students drop databases;
14. Make a table:
create table (name tablenya)
-->(name (type data),
-->nim (type data);
Example: create table students
-->name VARCHAR (255),
-->nim char (10) primary key,
-->address VARCHAR (255));
15. To enter data, type insert into (table name) values ( 'data1', 'data2', 'data3', '....', ...); Example: insert into student values ( 'Michael','06 .11.1033 ', 'Yogyakarta'); or insert into student
-->set name = "Michael",
-->nim = "06.11.1033"
-->address = "Yogyakarta";
16. To change the data, type the update (table name) set (the data will be changed) = ""
Where (the name columns) = "content columns in the existing columns that we will be content";
Example: update students set address = "Ipswich" where nim = "06.11.1033";
17. To change the columns, type alter table (table name) (type conversion);
There are 4 types of conversion, namely:
a. = Add to add columns, for example: alter table student description of the add char (10);
b. = Drop to remove columns, for example: alter table students drop out;
c. = Rename to rename the table, for example: alter table rename mahasiswa1 students;
d. = Modify to change the type of data from a colomns, for example: alter table students modify the name of the text (100);
18. To delete the data in the columns, type delete from (table name) where (name columnsnya) = "data";

source : mysql.com