In this chapter, we explain how to set up a MySQL database for use on a website.
Key topics covered in this chapter include
Creating a database
Setting up users and privileges
Introducing the privilege system
Creating database tables
Choosing column types in MySQL
In this chapter, we follow through with the Book-O-Rama online bookstore application discussed in the preceding chapter. As a reminder, here is the schema for the Book-O-Rama application:
Customers(CustomerID, Name, Address, City) Orders(OrderID, CustomerID, Amount, Date) Books(ISBN, Author, Title, Price) Order_Items(OrderID, ISBN, Quantity) Book_Reviews(ISBN, Reviews)
Remember that each primary key is underlined and each foreign key is ...