Introduction

by Gisle Hannemyr

This chapter is an introduction to the MySql notes. It also introduces the conventions and notations I use in this book.

Table of contents

Introduction

This is the first chapter in a very incomplete notes about interacting with MySql. It is not about SQL as such, but about performing some typical task as a database administrator (instead of as a developer).

I'm using MySql 5.1.71 on RHEL6. However. most of the notes should also apply to older versions of MySql.

Who this book is for

This book is general in scope and is written for people interested in learning about being a database administrator when MySql as for the purpose of managing a WCMS.

Conventions

For typographic and other conventions, please see this section in the ebook about Drupal.

Depreciations

MySQL used to accept a four digit datetime (e.g. '2021'), but no longer does and produces the error:

Incorrect TIMESTAMP value '2021'

Instead, use this format: '2021-01-01 00:00:00'.

Reader feedback and errata

Feedback from my readers is always welcome. Let me know what you think about this material – both what you liked and what you disliked. The project is still under development and reader feedback is important to me in order to improve the material.

In particular, if you think you've spotted an error or omission in this material, or an area where the treatment can be improved, please let me know! As long as this draft exists on the web, any errors will be corrected as soon as they are spotted.

You can use this form both to provide general feedback, and to report errors.


Last update: 2021-06-19 [gh].