www.allitebooks.com Summary of Contents Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi 1. Getting Started with MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2. Storing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 3. Retrieving and Updating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 4. Working with Multiple Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 5. Connecting from Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 6. Programming the Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 7. Backups and Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 www.allitebooks.com www.allitebooks.com JUMP START MYSQL BY TIMOTHY BORONCZYK www.allitebooks.com iv Jump Start MySQL by Timothy Boronczyk Copyright © 2015 SitePoint Pty. Ltd. Product Manager: Simon Mackie English Editor: Ralph Mason Technical Editor: Peter Nijssen Cover Designer: Alex Walker Notice of Rights All rights reserved. No part of this book may be reproduced, stored in a retrieval system or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews. Notice of Liability The author and publisher have made every effort to ensure the accuracy of the information herein. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors and SitePoint Pty. Ltd., no