# pkg install mysql56-server
# echo 'mysql_enable="YES"' >> /etc/rc.conf
# service mysql-server start


Go to Mysql.

# mysql -u root

Show databases.

mysql> show databases;


Create database.

mysql> create database storage;


Show tables.

mysql> show tables;


Create table.

mysql> create table if not exsists disks(
- disk_id int(5) not null auto_increment,
- name_disk varchar(50) default null,
- q_disk int(10) default null,
- primary key(disk_id));


Show columns.

mysql> show columns from disks;


Insert data into table.

mysql> insert into disks(name_disk,q_disk)
values("Seagate",2);


Show data from table.

mysql> select * from disks;