11 GETTING STARTED WITHA DATABASE
What this chapter covers:
- Creating MySQL user accounts
- Creating a new database
- Defining a database table
- Choosing the right column type
- Using MySQL, MySQLI, and PDO to query a database
When I first started working with databases, one of the greatest frustrations was that all the books and online tutorials I consulted assumed that you already knew the basics of database design and construction, or—if you didn't—that you planned to use Microsoft Access. MySQL is very different from Access, which is intended for use in small office environments. MySQL is not only fast and multiplatform; it's capable of handling a high number of simultaneous connections without any perceptible loss of performance. The differences ...