Using MySQL

Basic Usage | Administration | Links

back to top Basic Usage

MySQL & PHP from scratch, Wade Maxfield
p. 46 - 53:
/root]# mysql mysql
where the first mysql is a command, the second an intial sample database
mysql> show tables;
+-----------------+
| Tables in mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
mysql> show columns from user;
mysql> select host,user,password,select_priv from user;
mysql> select host,user,password,select_priv from user where User='root';
mysql>
mysql> CREATE DATABASE imp;
mysql> use imp;
mysql> CREATE TABLE imp_addr ( -> user text, -> address text, -> nickname text, -> fullname text ->); Query OK, 0 rows affected (0.46 sec)
mysql> CREATE TABLE imp_pref ( -> user text, -> fullname text, -> replyto text, -> lang varchar(30) -> sig text -> );
mysql> show tables
mysql> quit

To add text, as in an org chart, enter text as close as reasonable to right position. Snap to grid will prevent correct positioning so toggle it by pressing g (using pointer tool and clicking the diagram first), drag text, re-apply snap-to-grid pressing g again.

To group the text and box, drag a selection frame (dotted line) around the box, press Ctrl-G. [[To ungroup, select, and press Ctrl-U]]

This has accomplished the task with basic tools; there are shortcuts to this by using Flowchart library shapes which include a text piece as part of boxes...

back to top Administration Course

Duane W. French of Alliance Micro Solutions, Inc., http://www.alliance-micro.com (800-798-3901)
solicited course development contractors to create a course for Alliance Micro Solutions along the lines of this outline (of a book? some other courseware?):

MySQL Training: Administering MySQL
Duration: 4 days
MySQL Training Overview

MySQL is the world's most popular open source client-server database. In this four-day, hands-on course, attendees learn the fundamentals of writing MySQL queries, administering the MySQL database, and writing applications that automate tasks within MySQL.

Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/.

MySQL Training Prerequisites

This course can be customized to any level of experience. The last section, Integrating Applications with MySQL, presumes that attendees already know the language in question and merely need to learn how to use the language to automate MySQL.

Hands-on/Lecture Ratio
This MySQL training class is 85% hands-on, 15% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

MySQL Training Materials
All MySQL training students receive:

Software Needed on Each Student PC

MySQL Training Objectives

Note: MySQL training students interested in learning how to use MySQL to build database-driven Web sites are also encouraged to consider Building Data-Driven Web Sites with PHP & MySQL.

MySQL Training Outline

MYSQL BASICS

DESIGNING AND CREATING DATABASES WITH MYSQL

WRITING SQL QUERIES

MYSQL TABLE TYPES AND TRANSACTIONS

ADMINISTERING MYSQL

OPTIMIZING MySQL

INTEGRATING APPLICATIONS WITH MYSQL

MySQL Cookbook, Second Edition — Dozens of short, focused pieces of code and hundreds of worked-out examples that are perfect for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch. Read more.

O’Reilly’s SQL Cookbook which also contains solutions for MySQL. (See link below) I will locate the above if needed.

http://www.oreilly.com/catalog/sqlckbk

Learning MySQL from OReilly isbn 9 780596 008642

MySQL Administrator’s Guide and Language Reference from MySQL Press isbn 9 780672 328701

MySQL Database Design and Tuning from MySQL Press isbn 9 780672 327650

MySQL Tutorial from MySQL Press. Many topics are similar to Microsoft’s SQL Server and some are very diverse. It would take a full 3 to 4.5 days to cover all the topics.

back to top MySQL Links