MariaDB Crash Course

MariaDB Crash Course

Ben Forta

Language: English

Pages: 304

ISBN: 0321799941

Format: PDF / Kindle (mobi) / ePub

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches.


MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data.


Learn how to:

  • Retrieve and sort data
  • Filter data using comparisons, regular expressions, and full text search
  • Join relational data
  • Create and alter tables
  • Insert, update, and delete data
  • Leverage the power of stored procedures and triggers
  • Use views and cursors
  • Manage transactional processing
  • Create user accounts and manage security via access control

Data and Goliath

Programming iOS 5: Fundamentals of iPhone, iPad, and iPod touch Development

iPhone: The Missing Manual (9th Edition)

Programming Android

The Datacenter as a Computer: An Introduction to the Design of Warehouse-Scale Machines (2nd Edition)

The Internet Peering Playbook: Connecting to the Core of the Internet














Prod_name FROM products WHERE prod_name REGEXP '[[:digit:]]{4}' ORDER BY prod_name; Output +--------------+ | prod_name | +--------------+ | JetPack 1000 | | JetPack 2000 | +--------------+ Analysis As explained previously, [:digit:] matches any digit, and so [[:digit:]] is a set of digits. {4} requires exactly four occurrences of whatever it follows (any digit), and so [[:digit:]]{4} matches any four consecutive digits. It is worth noting that when using regular expressions there is.

Is called a table. A table is a structured file that can store data of a specific type. A table might contain a list of customers, a product catalog, or any other list of information. * * * New Term: Table A structured list of data of a specific type. * * * The key here is that the data stored in the table is one type of data or one list. You would never store a list of customers and a list of orders in the same database table. Doing so would make subsequent retrieval and access.

Population scripts in Appendix B, “The Example Tables” for examples of this.) * * * * * * Tip: Determining the AUTO_INCREMENT Value One downside of having MariaDB generate (via auto increment) primary keys for you is that you don’t know what those values are. Consider this scenario: You are adding a new order. This requires creating a single row in the orders table and then a row for each item ordered in the orderitems table. The order_num is stored along with the order details in.

Client-server software, 14-15 CLOSE statement, 211 closing cursors, 211 collation sequences, 232-234 columns. See also fields aliases, 84-85 derived, 85 explained, 7-8 fully qualified names, 126 GROUP BY clause, 109 multiple, sorting query results by, 39-40 NULL, 8, 177-178 omitting, 164 padded spaces RTrim() function, 83-84 primary keys, 9-10 retrieving all columns, 30 individual columns, 27-28 multiple columns, 29 unknown columns, 31 subquery result restrictions, 118.

Orderitems, 258 orders, 257-258 overwriting, 177 performance considerations, 131 primary keys, 124, 179-180 productnotes, 259 products, 256-257 relational tables, 123-124 renaming, 185 replacing, 177 rows explained, 8 inserting multiple rows, 165-166 inserting single rows, 161-164 NULL, 8 retrieving, 31-32 updating, 169-171, 183-185 vendors, 256 viewing list of, 23 virtual. See views Tan() function, 96 terminating statements, 28 text functions, 90-92 text searches. See.

Download sample