MariaDB
MariaDB logo

MariaDB[1] is one of the most popular community-developed relational database management systems published under the GNU GPL. MariaDB born as a MySQL fork from former developers after Oracle acquisition.

Readings

  1. Study Guides: MariaDB

Multimedia

Activities

  1. Perform the following tasks:[2]
    • Install MariaDB. For example in MacOS: brew install mariadb
    • Start and configure MariaDB.
    • Backup and restore a database
    • Create a simple database schema
    • Perform simple SQL queries against a database
    • Create a basic table

Install and start MariaDB in MacOS

  • brew install mariadb
  • Start MariaDB:
/usr/local/bin/mysql.server start (command is mysql but you are actually starting MariaDB)
Starting MariaDB
.180619 10:15:19 mysqld_safe Logging to '/usr/local/var/mysql/file.err'.
180619 10:15:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
 SUCCESS! 
  • Check MariaDB is running:
usr/local/bin/mysql.server status
 SUCCESS! MariaDB running (80662)

Create a table: CREATE TABLE

  • Connect to database test, will be created in default MariaDB installation:
mysql test
  • Create a basic table with two columns using the create table [3][4] SQL statement:
create table my_first_table (my_first_column char, my_second_column char);
  • Show tables so we can check our new created table is available:
MariaDB [test]> describe my_first_table;
+------------------+
| Tables_in_test   |
+------------------+
| my_first_table   |
+------------------+
  • Show details about your new table:
MariaDB [test]> describe my_first_table;
+------------------+---------+------+-----+---------+-------+
| Field            | Type    | Null | Key | Default | Extra |
+------------------+---------+------+-----+---------+-------+
| my_first_column  | char(1) | YES  |     | NULL    |       |
| my_second_column | char(1) | YES  |     | NULL    |       |
+------------------+---------+------+-----+---------+-------+
2 rows in set (0.003 sec)

Advanced Features

See also

References


  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.

MariaDB
 



 

Connect with defaultLogic
What We've Done
Led Digital Marketing Efforts of Top 500 e-Retailers.
Worked with Top Brands at Leading Agencies.
Successfully Managed Over $50 million in Digital Ad Spend.
Developed Strategies and Processes that Enabled Brands to Grow During an Economic Downturn.
Taught Advanced Internet Marketing Strategies at the graduate level.


Manage research, learning and skills at defaultlogic.com. Create an account using LinkedIn to manage and organize your omni-channel knowledge. defaultlogic.com is like a shopping cart for information -- helping you to save, discuss and share.


  Contact Us