Ubuntu Unleashed 2019 Edition: Covering 18.04, 18.10, 19.04

Apache Tomcat Apache Tomcat is a common and frequently used open source Java servlet container that imple ...

CHAPTER 28 Administering Relational Database Services IN THIS CHAPTER A Brief Review of Database Basics Choo ...

openSUSE, and Wikipedia (all of which now use MariaDB). The good news is that anything you learn about ...

A Brief Review of Database Basics Database services under Linux that use the software discussed in t ...

form of structured storage that is suitable for large and high-traffic uses. These databases have been ...

FIGURE 28.1 In this visualization of how an RDBMS stores data, the database stores four records (rows) ...

For example, suppose you run a small company that sells widgets and you have a computerized database of ...

RDBMS structure enables you to work with that data, you are ready to learn how to input and output data ...

the best type to use for the others is INT. You should notice something else about the cd_collection table: ...

After you create the tables, you can put data into them. You can insert data manually with the INSERT stateme ...

look up, sort, and generate reports on that data. Basic data retrieval is done with the SELECT stateme ...

(||). The following command is the PostgreSQL equivalent of the preceding MySQL command: Click here to view c ...

TIP One of the most common errors among new database programmers is confusing logical AND and logical OR. For examp ...

Newer versions of PostgreSQL have improved in terms of speed (when it comes to disk access, sorting, ...

NOTE MySQL’s data locking methods are discussed in more depth at https://dev.mysql.com/doc/. You can find more ...

compliant, whereas InnoDB tables are. Note that ACID compliancy is no easy task: All the extra precautions ...

tables and creates a MySQL root user. CAUTION The MySQL data directory needs to be owned by the user th ...

In this command, replace secretword with whatever you want to be the password for the root user. You ...

database. Column level—These rights allow access to a single column within a database’s table. NOTE Listing all the ...

matthew@seymour:~$ mysql -h shuttle2 -u foobar -p animals Enter password: Welcome to the MySQL monitor. Co ...