Ne conectam la mysql folosind urmatorul cod:
% mysql -u username_mysql -p
mysql>use baza_de_date;

Creem tabela in care vom introduce date
mysql>CREATE TABLE `tabela_mysql` (
>`id` int(11) NOT NULL,
>`continut` char(255) DEFAULT NULL,
>`name` char(255) DEFAULT NULL,
>`type` char(255) DEFAULT NULL,
>`size` int(11) DEFAULT NULL,
>`nume` char(255) DEFAULT NULL,
>`prenume` char(255) DEFAULT NULL,
>`media` char(255) DEFAULT NULL,
>PRIMARY KEY (`id`)
>) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

Pentru a vedea tabela creata de noi putem folosi describe sau forma scurta din patru litere desc
mysql> desc tabela_mysql ;
+----------+-----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
| continut | char(255) | YES | | NULL | |
| name | char(255) | YES | | NULL | |
| type | char(255) | YES | | NULL | |
| size | int(11) | YES | | NULL | |
| nume | char(255) | YES | | NULL | |
| prenume | char(255) | YES | | NULL | |
| media | char(255) | YES | | NULL | |
+----------+-----------+------+-----+---------+-------+
8 rows in set (0.03 sec)

Pentru a introduce date in tabela noastra vom folosi urmatoarea instructiune de introducerea datelor. Prin aceasta comanta selectam doar coloanele in care dorim sa introducem date. Id pentru ca este cheie primara este introdus automat de catre sistem.
insert into tabela_mysql set continut="fisier",name="Tutorial de Instalare FreeBSD",type="video",size=1024,
nume="Charly",prenume="Root",media="video.flv";

To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u root -p

Create a database on the sql server
mysql> create database [databasename];

List all databases on the sql server.
mysql> show databases;

MAI MULT …