Minggu, 03 April 2011

SQL (Structured Query Language)




SQL (Structured Query Language) is the language used in
data base. SQL is built on IBM's lab-san Jose in California about 70 years.
Was first developed as a language in the product DB-2 which is the product
IBM's mainstay.


The basic function is to open the SQL data from the database. Who can then
filtered and manipulated according to application needs.
2 groups of commands in SQL:
· Data Nanipulation Language.
· Data Language defination.


Mysql> show tables;
+-------------------------+
| Tables in mysql |
+-------------------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-------------------------+
6 rows in set (0.00 sec)
mysql> select * <enter>
-> from <enter>
-> host <enter>
-> \ g <enter>
Empty set (0.00 sec)
Mysql>_

Tidak ada komentar:

Posting Komentar