Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Getting Started with MariaDB
  • Table Of Contents Toc
Getting Started with MariaDB

Getting Started with MariaDB

By : Daniel Bartholomew
4.4 (8)
Buy this Book
close
close
Getting Started with MariaDB

Getting Started with MariaDB

4.4 (8)
By: Daniel Bartholomew
Buy this Book

Overview of this book

MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available. From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.
Table of Contents (11 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Installing MariaDB
Icon
1. Installing MariaDB
Icon
Choosing a MariaDB series
Icon
Installing MariaDB on Windows
Icon
Installing MariaDB on Mac OS X
Icon
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Icon
Installing MariaDB on Fedora, Red Hat, and CentOS
Icon
Installing MariaDB on other Linux distributions
Icon
MariaDB package security
Icon
After the installation
Icon
Troubleshooting installation issues
Icon
Summary
2
2. Configuring MariaDB
Icon
2. Configuring MariaDB
Icon
The MariaDB filesystem layout
Icon
Modular configuration on Linux
Icon
The anatomy of the MariaDB configuration file
Icon
Activating configuration changes
Icon
Summary
3
3. Securing MariaDB
Icon
3. Securing MariaDB
Icon
Security layers
Icon
Securing MariaDB in 10 seconds
Icon
Connecting safely
Icon
Server security
Icon
Building security
Icon
Internal network security
Icon
Internet security
Icon
Summary
4
4. Administering MariaDB
Icon
4. Administering MariaDB
Icon
User privileges
Icon
Creating users
Icon
Granting, revoking, and showing permissions
Icon
Setting and changing passwords
Icon
Removing users
Icon
Summary
5
5. Using MariaDB – Databases and Tables
Icon
5. Using MariaDB – Databases and Tables
Icon
The mysql command-line client application
Icon
Connecting to MariaDB
Icon
Using USE to select a database
Icon
Using SHOW to list all databases on a server
Icon
Creating and deleting databases
Icon
Data, tables, and normalization
Icon
Creating, altering, and dropping tables
Icon
Summary
6
6. Using MariaDB – Inserting, Updating, and Deleting
Icon
6. Using MariaDB – Inserting, Updating, and Deleting
Icon
Using INSERT
Icon
Using UPDATE
Icon
Using DELETE
Icon
Summary
7
7. Using MariaDB – Retrieving Data
chevron up
Icon
7. Using MariaDB – Retrieving Data
Icon
Retrieving data
Icon
Filtering and searching data
Icon
Summarizing data
Icon
Summary
8
8. Maintaining MariaDB
Icon
8. Maintaining MariaDB
Icon
MariaDB log files
Icon
Optimizing and tuning MariaDB
Icon
Backing up, importing, and restoring data
Icon
Repairing MariaDB
Icon
Summary
9
A. MariaDB Next Steps
Icon
A. MariaDB Next Steps
10
Index
Icon
Index

Retrieving data

The command for retrieving or reading data from our database is called SELECT. Of all the SQL commands, this is the one which we will probably use most often. The syntax is rather complex, or can be, if we choose to use all the various options. However, the basic syntax is quite simple and is as follows:

SELECT <what> FROM <table_name>
    [WHERE <where-conditions>]
    [ORDER BY <column_name>];

In the <what> part, we specify the columns that we want to retrieve data from. The WHERE and ORDER BY lines are how we filter and sort our data, respectively.

Note

Complete documentation of the SELECT command, refer to the following location:

https://mariadb.com/kb/en/select/

Retrieving everything

A common <what> condition is to specify every column. This is done using an asterisk (*). For example, to retrieve everything from our employees table, we could do the following:

SELECT * FROM employees;

Because we have not specified a WHERE clause, everything...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Getting Started with MariaDB
End of Section 7
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon