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):

Scott Cosentino

Thomas Pettit

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

Exploring the ODBC connection

Be sure you have the Excel sample database installed before attempting to create an ODBC DSN connection.

Important Note

We need to create an ODBC connection to the new database named chinook and name the connection chinook (the same name as the database). Several exercises in this chapter will require this connection. If you need to jog your memory about how to create an ODBC connection, refer to ODBC connections in Chapter 6, Exercise 6.11.

Now that the database is installed and an ODBC DSN has been created, we can start. As we will be working with VBA, we will start with the Developer menu.

The Developer menu

This section will introduce you to the Developer menu and the VBA IDE and explain how an Excel VBA program works within the Excel environment. It is very similar to the Microsoft Access (MS Access) environment, but of course, there are differences you need to be aware of to work in the environment. There are also some differences...

The rest of the chapter is locked

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

Table of Contents (22) Chapters

Exploring the ODBC connection

The Developer menu

Unlock this book and the full library FREE for 7 days

Authors (2)

Personalised recommendations for you