You're reading from The MySQL Workshop A practical guide to working with data and managing databases with MySQL

Product type Paperback

Published in Apr 2022

Publisher Packt

ISBN-13 9781839214905

Length 726 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (2):

Thomas Pettit

Scott Cosentino

View More author details

Table of Contents (22) Chapters

Preface

1. Section 1: Creating Your Database

2. Chapter 1: Background Concepts FREE CHAPTER

3. Chapter 2: Creating a Database

4. Chapter 3: Using SQL to Work with a Database

5. Chapter 4: Selecting, Aggregating, and Applying Functions

6. Section 2: Managing Your Database

7. Chapter 5: Correlating Data across Tables

8. Chapter 6: Stored Procedures and Other Objects

9. Chapter 7: Creating Database Clients in Node.js

10. Chapter 8: Working with Data Using Node.js

11. Section 3: Querying Your Database

12. Chapter 9: Microsoft Access – Part 1

13. Chapter 10: Microsoft Access – Part 2

14. Chapter 11: MS Excel VBA and MySQL – Part 1

15. Chapter 12: Working With Microsoft Excel VBA – Part 2

16. Section 4: Protecting Your Database

17. Chapter 13: Getting Data into MySQL

18. Chapter 14: Manipulating User Permissions

19. Chapter 15: Logical Backups

20. Other Books You May Enjoy

Appendix

Querying tables in MySQL

To get data out of MySQL, we use a SELECT query. A basic SELECT query has the following format:

SELECT <items> FROM <table>

Here, <items> can be many different kinds of things. It can be a wildcard (*) character, which returns all columns from a table, a list of columns, or even something that's not in the table at all but should still be in resultset – for example, a constant such as production or number. The FROM <table> part is optional, but it is there in most cases.

The SQL language is a declarative language, which means that the focus is more on the results that are obtained rather than how they are obtained. This is why we describe in a SELECT statement what the returned data should look like (for example, what fields it should have). We don't instruct the database to open the data file and navigate through the data structures. Based on the instructions we give for what the results should look like,...