MySQL Visual Blueprint: Open Source Database Management Guide by Michael Moncur

$ 2.38

ISBN-13: 9780764516924 Dewey Edition: 21 Format: CD-ROM / Trade Paperback Publication Year: 2002 Item Length: 9 in brand: Wiley & Sons, Incorporated, John Series: Visual Read Less, Learn more Ser. gtin13: 9780764516924 Subject: Programming Languages / Sql Reviews: "...a fine introduction to MySQL and a lasting reference guide to boot..." (IT Training, February 2003) Synopsis: MySQL, Perl, and PHP software on CD-ROM! Also includes Apache and phpMyAdmin, with usage examples for Windows and UNIX Plus a fully searchable e-version of the book, and more Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 500 MySQL tips, features, and characteristics, including: Managing databases and tables Modifying tables Using SELECT queries Adding, deleting, and updating data Applying MySQL functions Importing and exporting data Managing the MySQL server Optimizing and troubleshooting MySQL Configuring MySQL security Using MySQL with PHP and Perl Software and examples on CD-ROM! Includes MySQL, Perl, and PHP software Includes Apache Web server, phpMyAdmin, and DBD:MySQL Code examples and advanced usage examples for both Windows and UNIX Plus a searchable e-version of the book, MySQL is the world's most popular open source database that runs on Windows, Linux, and several other platforms. This visual guide covers the most widely used features of MySQL, beginning with the basics and progressing to more advanced concepts. Readers will learn the fundamentals then find techniques for optimization and adding database security., MySQL is a popular open source database that runs on Windows, Linux, and several other platforms. This visual guide covers the widely used features of MySQL, beginning with the basics and progressing to more advanced concepts. In this book, readers will learn the fundamentals, and then find techniques for optimization and adding database security. Type: Textbook Language: English Item Height: 0.3 in Publication Name: My Sqltm : Your Visual Blueprinttm to Open Source Database Management LCCN: 2002-110260 Number of Pages: 304 Pages Item Weight: 23 Oz Intended Audience: Trade Illustrated: Yes Author: Michael Moncur Dewey Decimal: 005.75/85 ISBN-10: 0764516922 Table Of Content: HOW TO USE THIS BOOK.1) INTRODUCING MYSQL.Understanding MySQL.MySQL Terminology.Other Database Systems.Structured Query Language (SQL).Download MySQL.Install MySQL under Linux from a Package.Install MySQL under UNIX from Source.Install MySQL under Windows.Start the MySQL Server.Test the MySQL Installation.Using the MySQL Monitor.View the Server Status.Try an SQL Query.Configure a MySQL User.Specify a Multiple-Line Query.Edit a Long Command.Configure MySQLGUI.2) MANAGE DATABASES AND TABLES.Design a Database.Create and Drop Databases.Create a Database.Show Available Databases.Select a Database.Create and Drop Tables.Create a Simple Table.Show Table Information.Numeric Column Types.Text and Date Column Types.Using Text Columns.Using Sets and Enumerations.Create an Indexed Table.Delete Tables and Databases.3) MODIFY TABLES.Using ALTER TABLE Queries.Add a Column to a Table.Add an Index.Add a Primary Key or Unique Index.Add a Timestamp Column.Add an Auto-Increment Column.Rename a Column.Change a Column Type.Delete a Column.Delete an Index or Primary Key.Rename a Table.Change a Table Type.4) ADD AND DELETE DATA.Using INSERT and DELETE Queries.Add a Row to a Table.Specify Columns for a New Row.Specify Insert Priority.Using Auto-Increment Columns.Using Timestamp Columns.Replace an Existing Row.Insert Rows from Another Table.Delete a Specific Row.Delete All Table Rows.Limit the Number of Deleted Rows.Delete Data by Date.5) UPDATE DATA IN TABLES.Using UPDATE Queries.Modify a Single Row.Modify Multiple Rows.Update All Table Rows.Limit the Number of Rows to Update.Update Multiple Columns.Update Depending on Column Values.Increment a Column Value.6) USING SELECT QUERIES.Using SELECT Queries.Display Data with SELECT.Using the WHERE Clause.Specify Multiple WHERE Conditions.Using the LIMIT Clause.Sort Data with the ORDER BY Clause.Using the GROUP BY Clause.Using Multiple Clauses with SELECT.Count Database Rows.Calculate Totals and Averages.Display Data from Multiple Tables.Using JOIN Options.Display Data with MySQLGUI.7) USING MYSQL FUNCTIONS.Math Functions.Using Math Functions.Compare Numeric Values.Understanding String Functions.Compare String Values.Using String Functions.Work with Substrings.Understanding Date and Time Functions.Work with Dates and Times.Display Formatted Dates.Add and Subtract Dates and Times.Miscellaneous Functions.8) IMPORT AND EXPORT DATA.Import and Export Tools.Export to a Text File with SELECT.Format an Import File.Import from a Text File.Export Data from a Spreadsheet.Export Data from Microsoft Access.Back up Data from a Table.Restore a Backup File.Manage Automated Backups.Back up Table Structure.Create a Copy of a Table.9) MANAGE THE MYSQL SERVER.MySQL Administration Tools.Check Server Status.Check the MySQL Server Version.Start and Stop the MySQL Server under UNIX.Start and Stop the MySQL Server Under Windows.View and Manage Running Processes.Using WinMySQLadmin.Manage MySQL with MySQLGUI.10) OPTIMIZE AND TROUBLESHOOT MYSQL.Optimize MySQL.Check a Table for Errors.Optimize and Repair Tables.MySQL Configuration Options.Display Server Performance Information.Edit the Configuration File in UNIX.Edit the Configuration File in Windows View MySQL Log Files.Improve Performance with Indexes.Manage Table Locking.11) CONFIGURE MYSQL SECURITY.The Importance of Security.MySQL Security Basics.Grant Privileges to Users.Modify User Passwords.View a User's Privileges.View Security Tables.Control Network Access.Advanced MySQL Security.12) USING MYSQL WITH PHP.Introducing PHP.Test the PHP Installation.Install and Test phpMyAdmin.Manage Data with phpMyAdmin.Manage the MySQL Server with phpMyAdmin.Connect to a MySQL Server.Display Query Results.Store Query Results as Objects.Insert a Record from PHP.Delete Records Using PHP.Create a Form to Add Records.Create a Database Search Form.13) US Item Width: 8 in Subject Area: Computers Publisher: Wiley & Sons, Incorporated, John LC Classification Number: QA76.3.S67M66 2003

Description

100% Customer Satisfaction Guaranteed! This item includes Free Shipping and Handling, and 30 Day Returns. ***BUYER PAYS RETURN SHIPPING*** This book is in very good condition, with only minimal to no signs of wear and tear. The pages are crisp and clean, and the spine is tight. It looks like it has been hardly read before! If for any reason you are not satisfied with your purchase, you may return the item within 30 days for a refund. ***BUYER PAYS RETURN SHIPPING*** Be sure to check out our all other items in stock as well!

  1. This book is a fantastic visual guide for mastering MySQL! The step-by-step blueprint makes database management easy to understand, even for beginners. The condition is excellent—barely used with clean pages and a tight spine. Free shipping and a 30-day return policy make it a risk-free purchase. Highly recommended for anyone looking to learn MySQL efficiently!

    Gary Chancdc