Conventions

In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "Create a /tmp/mariadb/books2.xml file following this structure."

A block of code is set as follows:

   <book id="bk101">
      <author>
         <last>Gambardella</last>
         <first>Matthew</first>
      </author>
      <title>XML Developer's Guide</title>
      <genre>Computer</genre>
      <price>44.95</price>
      <publish_date>2000-10-01</publish_date>
      <description>An in-depth look at creating applications
      with XML.</description>
   </book>

Any command-line input or output is written as follows:

SELECT WEEKDAY(date), COUNT(*)
 FROM product_order
 WHERE YEAR(date) = YEAR(NOW())
 GROUP BY WEEKDAY(date);

New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Clicking the Next button moves you to the next screen."