Which of the following data types are incorrect in MySQL?
e) None of the above
Suggest the ideal data type for the following fields:
a) First name
d) Life story
When are LOW_PRIORITY-marked writes executed?
a) After ten seconds
b) After the next read
c) When no more reads remain
d) When FLUSH WRITES is called
Temporary tables are automatically deleted when your scripts ends: true or false?
Which of the following statements are true about indexes:
a) They usually speed up queries
b) They take up extra disk space
c) They slow table writes down
d) None of the above
e) All of the above except d)
You can emulate subselects using multiple individual queries: true or false?
Unbuffered queries allow you to start reading in the result of a query before the query has been finished: true or false?
What is SQLite's key advantage over MySQL and other DBMSs?
Using PEAR::DB is usually as fast if not faster than standard database calls: true or false?
Next chapter: Further reading >>
Previous chapter: Summary
Jump to: Databases Introduction Database hierarchy Types of data Date and time Transactions Stored procedures Triggers Views Keys Referential integrity Indexes Persistent connections Temporary Tables Table handlers Round up History MySQL PostgreSQL Oracle Microsoft SQL Server SQL SQL comments Interacting with MySQL Creating tables Making table changes Deleting tables Inserting data Selecting data Extra SELECT keywords Updating data Deleting data MySQL for dummies A working example Multiple WHERE conditions Grouping rows together with GROUP BY MySQL functions Managing indexes Simple text searching using LIKE Advanced text searching using full-text indexes Range matching Working with NULL Default values Using MySQL with PHP Connecting to a MySQL database Querying and formatting Disconnecting from a MySQL database Reading in data Mixing in PHP variables Results within results Advanced formatting Reading auto-incrementing values Unbuffered queries for large data sets phpMyAdmin PEAR::DB Quick PEAR::DB calls Query information Advanced PEAR::DB Impeared performance? SQLite Using SQLite Before you begin Getting started Advanced functions Mixing SQLite and PHP Normalisation Why separate data? So, what is the solution here? Why not separate data? First normal form Second normal form Other normal forms Conclusion Table joins Complex joins Using temporary tables Adjusting the priority queue How to design your tables Picking the perfect data type When MySQL knows best Persistent connections Choosing a table type Transactions MySQL Improved Subselects, views, and other advanced functions Subselects Views Referential integrity Summary Exercises Further reading Next chapter
Home: Table of Contents
Follow us on Identi.ca or Twitter
© Future Publishing Limited, Beauford Court, 30 Monmouth Street, Bath BA1 2BW. All rights reserved. England and Wales company registration number 2008885.