Abstract
So you’re planning your IOT solution and have decided to build into your solution a database server. Perhaps you’ve never used a database system before or maybe you’ve used one as a user but have never had any need to set up one from scratch. Or perhaps you’ve decided to discover what all the fuss is about database systems in general. Whichever the case, you have the core knowledge you need to get started: you know what you want to store and what the data looks like.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Even a rudimentary knowledge of your data and its form is crucial to a successful database configuration.
- 2.
According to GNU ( http://gnu.org/philosophy/free-sw.html ), “Free software is a matter of liberty, not price. To understand the concept, you should think of ‘free’ as in ‘free speech,’ not as in ‘free beer.’”
- 3.
Sometimes called the MySQL monitor, terminal monitor, or even the MySQL command window.
- 4.
If you are a paid customer of Oracle and have a subscription or support agreement for MySQL, contact your sales representative for details.
- 5.
You do read these, don’t you?
- 6.
C. J. Date, The Database Relational Model: A Retrospective Review and Analysis (Reading, MA: Addison-Wesley, 2001).
- 7.
C. J. Date and H. Darwen, Foundation for Future Database Systems: The Third Manifesto (Reading, MA: Addison-Wesley, 2000).
- 8.
- 9.
Now, that’s one trick the professional regurgitator might not be able to do. See https://en.wikipedia.org/wiki/Stevie_Starr .
- 10.
Not including direct, engine-level queries like NoSQL using NDB.
- 11.
- 12.
If you’re a relational database expert like me, ordering concepts like this in database systems and especially SQL makes my skin crawl. So much for the “unordered” concept!
- 13.
See the online reference manual for additional conditions and differences of the multiple row insert command.
- 14.
Hey, it happens. While this is fictional, my wife and I discovered a plant we thought was one thing turned out to be another when it started to bloom.
- 15.
Actually, adhering to best practices for any database design.
- 16.
- 17.
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2016 Charles Bell
About this chapter
Cite this chapter
Bell, C. (2016). MySQL Primer. In: MySQL for the Internet of Things. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1293-6_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1293-6_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1294-3
Online ISBN: 978-1-4842-1293-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books