没有合适的资源?快使用搜索试试~ 我知道了~
首页MariaDB Crash Course【MariaDB(MySQL开源社区版)数据库快速入门】英文版
MariaDB Crash Course【MariaDB(MySQL开源社区版)数据库快速入门】英文版

MariaDB is an offshoot of MySQL, one of the most popular database management systems in the world. From small development projects to some of the best-known and most prestigious sites on the Web, MySQL has proven itself to be a solid, reli- able, fast, and trusted solution to all sorts of data storage needs.
资源详情
资源评论
资源推荐

ptg7041395

ptg7041395
Crash Course
Ben Forta
Upper Saddle River, NJ • Boston • Indianapolis • San Francisco
New York • Toronto • Montreal • London • Munich • Paris • Madrid
Cape Town • Sydney • Tokyo • Singapore • Mexico City
MariaDB

ptg7041395
Many of the designations used by manufacturers and sellers to
distinguish their products are claimed as trademarks. Where those
designations appear in this book, and the publisher was aware of a
trademark claim, the designations have been printed with initial capi-
tal letters or in all capitals.
The author and publisher have taken care in the preparation of
this book, but make no expressed or implied warranty of any kind
and assume no responsibility for errors or omissions. No liability is
assumed for incidental or consequential damages in connection with
or arising out of the use of the information or programs contained
herein.
The publisher offers excellent discounts on this book when ordered in
quantity for bulk purchases or special sales, which may include elec-
tronic versions and/or custom covers and content particular to your
business, training goals, marketing focus, and branding interests. For
more information, please contact:
U.S. Corporate and Government Sales
(800) 382-3419
corpsales@pearsontechgroup.com
For sales outside the United States, please contact:
International Sales
international@pearson.com
Visit us on the Web: informit.com/aw
Library of Congress Cataloging-in-Publication Data
Forta, Ben.
MariaDB crash course / Ben Forta.
p. cm.
Includes index.
ISBN 978-0-321-79994-4 (pbk.)
1. MariaDB. 2. Database management. 3. Client/server comput-
ing. I. Title.
QA76.9.D3F663 2012
004’.36--dc23
2011023506
Copyright © 2012 Pearson Education, Inc.
All rights reserved. Printed in the United States of America. This pub-
lication is protected by copyright, and permission must be obtained
from the publisher prior to any prohibited reproduction, storage in a
retrieval system, or transmission in any form or by any means, elec-
tronic, mechanical, photocopying, recording, or likewise. To obtain
permission to use material from this work, please submit a written
request to Pearson Education, Inc., Permissions Department, One
Lake Street, Upper Saddle River, New Jersey 07458, or you may fax
your request to (201) 236-3290.
ISBN-13: 978-0-321-79994-4
ISBN-10: 0-321-79994-1
Text printed in the United States on recycled paper at R.R. Donnelley
in Crawfordsville, Indiana.
First printing September 2011
Editor-in-Chief
Mark Taub
Acquisitions Editor
Mark Taber
Managing Editor
Kristy Hart
Project Editors
Elaine Wiley
Jovana San Nicolas-
Shirley
Copy Editor
Geneil Breeze
Indexer
Erika Millen
Proofreader
Leslie Joseph
Publishing
Coordinator
Vanessa Evans
Book Designer
Gary Adair
Compositor
Gloria Schurick

ptg7041395
This page intentionally left blank

ptg7041395
Table of Contents
Introduction 1
What Is MariaDB Crash Course? 1
Who Is This Book For? 2
Companion Web Site 3
Conventions Used in This Book 3
1: Understanding SQL 5
Database Basics 5
What Is a Database? 6
Tables 6
Columns and Datatypes 7
Rows 8
NULL 8
Primary Keys 9
What Is SQL? 10
Try It Yourself 11
Summary 11
2: Introducing MariaDB 13
What Is MariaDB? 13
Client-Server Software 14
MySQL Compatibility 15
MariaDB Tools 16
mysql Command Line 16
MySQL Workbench 17
Summary 19
3: Working with MariaDB 21
Making the Connection 21
Selecting a Database 22
Learning About Databases and Tables 23
Summary 26
4: Retrieving Data 27
The SELECT Statement 27
Retrieving Individual Columns 27
Retrieving Multiple Columns 29
Retrieving All Columns 30
剩余302页未读,继续阅读



















安全验证
文档复制为VIP权益,开通VIP直接复制

评论1