MySQL is a software SQL database management system (English: database management system) or the DBMS is multithreaded, multi-user, with about 6 million installations worldwide. MySQL AB makes MySQL available as free software under the GNU General Public License (GPL). Where everyone is free to use MySQL, but should not be used as a derivative of a commercial nature.

MySQL is actually a derivative of one of the main concepts in the database for a long time, the SQL (Structured Query Language). SQL is a database operation concept, especially for the election or selection and data entry, which allows the operation of the data is automatically done easily. Reliability of a database system (DBMS) can be determined from how the optimizer his way to perform SQL commands, which are made by the user or application programs. As a database server, MySQL can be said to be superior compared to other database servers in a data query. This proved to queries made ​​by a single user, the speed of MySQL query can be ten times faster than PostgreSQL and five times faster than Interbase.

 

Scripting MySQL database :

mysql -u root -p

 

Create Database

mysql> create database test;
Query OK, 1 row affected (0.00 sec)
mysql> use itechno;

 

Create Table

mysql> create table test(nama int(30) not null primary key, alamat varchar(40),
sekolah varchar(40), kelas varchar(100));
Query OK, 0 rows affected (0.72 sec)
mysql> describe test;

+—————+————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+—————+————–+——+—–+———+——-+
| nama | int(30) | NO | PRI | NULL | |
| alamat | varchar(40) | YES | | NULL | |
| sekolah | varchar(40) | YES | | NULL | |
| kelas | varchar(100) | YES | | NULL | |
+—————+————–+——+—–+———+——-+
4 rows in set (0.01 sec)

 

Insert Records

mysql> insert into test values(muqsith, ‘tamalate 4′, ‘smktelkom’, ‘XI Tkj 2′);

 

Alex Smirnov

Senior Java Developer. JAVA, PHP, Cold Fusion, SQL, Air, Flash.

More Posts

Tagged with: