Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Getting Started with MariaDB

You're reading from Getting Started with MariaDB Explore the powerful features of MariaDB with practical examples

Product type Paperback

Published in Jun 2015

Publisher

ISBN-13 9781785284120

Length 140 pages

Edition 1st Edition

Languages

Java

Tools

MariaDB

Concepts

Database Administration

Author (1):

Daniel Bartholomew

View More author details

Table of Contents (16) Chapters

Getting Started with MariaDB Second Edition

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Installing MariaDB FREE CHAPTER

2. Configuring MariaDB

3. Securing MariaDB

4. Administering MariaDB

5. Using MariaDB – Databases and Tables

6. Using MariaDB – Inserting, Updating, and Deleting

7. Using MariaDB – Retrieving Data

8. Maintaining MariaDB

MariaDB Next Steps

Index

Chapter 5. Using MariaDB – Databases and Tables

From this chapter onwards, we will focus on using the command-line mysql client to perform common tasks. In this chapter, you'll learn about the following:

The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (1)

Daniel Bartholomew

Daniel Bartholomew

Daniel Bartholomew has been using Linux since 1997 and databases since 1998. In addition to this book, he has also written MariaDB Cookbook, Packt Publishing, and dozens of articles for various magazines, including The Linux Journal, Linux Pro, Ubuntu User, and Tux. He became involved with the MariaDB project shortly after it began in early 2009 and continues to be involved to this day. He currently works for MariaDB, Inc. and splits his time between managing MariaDB releases, documentation, and maintaining various bits and pieces that keep the MariaDB project running smoothly.

See other products by Daniel Bartholomew

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Microsoft Power BI Cookbook

Microsoft Power BI Cookbook

Microsoft Power BI is the most sought-after platform for BI professionals' visualization needs. Explore the latest Power BI features, future AI enhancements, and integration with other Power Platform tools via new recipes in this updated edition.

Jul 2024 19h 56m

RAG-Driven Generative AI

RAG-Driven Generative AI

Explore the transformative potential of RAG-driven LLMs, computer vision, and generative AI with this comprehensive guide, from basics to building a complex RAG pipeline

Sep 2024 11h 8m

Building AI Intensive Python Applications

Building AI Intensive Python Applications

Unlock the power of generative AI with LLMs, vector databases, Python, and MongoDB. Build intelligent apps, master retrieval-augmented generation, optimize models, and explore real-world use cases.

Sep 2024 9h 56m

Using Stable Diffusion with Python

Using Stable Diffusion with Python

This book shows you how to use Python to control Stable Diffusion and generate high-quality images. In addition to covering the basic usage of the diffusers package, the book provides solutions for extending the package for more advanced purposes.

Jun 2024 11h 44m

Getting Started with DuckDB

Getting Started with DuckDB

This hands-on book teaches you to analyze large datasets with blazing speed and ease. You will learn how to use DuckDB to quickly load, query, transform, analyze, and visualize data effectively through a series of practical examples.

Jun 2024 12h 44m

Databricks Certified Associate Developer for Apache Spark Using Python

Databricks Certified Associate Developer for Apache Spark Using Python

This guide gets you ready for certification with expert-backed content, key exam concepts, and topic reviews. Additionally, you'll be able to make the most of Apache Spark 3.0 to modernize workloads and more using specific tools and techniques.

Elastic Stack 8.x Cookbook

Elastic Stack 8.x Cookbook

With its practical approach and real-world examples, this essential resource explores the full potential of Elastic Stack for data-driven projects. Learn how to build scalable and efficient data analytics and search solutions using Elastic Stack.

Jun 2024 22h 56m

Google Machine Learning and Generative AI for Solutions Architects

Google Machine Learning and Generative AI for Solutions Architects

Whether you are relatively new to AI/ML or an experienced solutions architect working to address emerging business challenges, this book covers everything you need to design, implement, and manage complex AI/ML workloads on Google Cloud.

Jun 2024 18h 24m

Generative AI with Amazon Bedrock

Generative AI with Amazon Bedrock

This book provides a hands-on approach to building generative AI applications at scale, covering several architectural patterns and use cases to help you solve business problems and innovate within your organization.

Jul 2024 12h 48m