|
Customizable code library,
Caché Monitor is an SQL
Whether you are an
with built in starter
development tool designed
experienced developer,
javascript library with over
for InterSystems database
system administrator, web
50 scripts
Caché
It supports
designer or new to MySQL and
developers with many
phpMyAdmin, this book will
features:
* Advanced
show you how to increase
SQL Query Editor
your productivity and
o Caché-SQL Syntax
control when working with
highlighting
o
your databases. You will
SQL Code completion (Shows
learn how to:
•
Tables,Views,Columns and
Administer MySQL users and
Indexes)
o SQL
privileges, and get
History
o
statistics about MySQL
Parallel (multi-threaded)
servers and databases
•
queries
o The
Manage databases, table data
Graphical SQL
and structures, and
execution plan supplies
indexes
• Use bookmarks and
index and selectivity
metadata
• Generate
information from every used
multiple SQL queries
•
index in the plan
Generate better
o SQL abbreviations, Type:
documentation of evolving
se<space> to
table structures
Along
complete to "SELECT *
the way you’ll build a more
FROM "
o
detailed understanding of
TuneTable for selected
SQL and how it works in
Tables or whole Namespaces
MySQL.
As an
o Select2Table
application developer you’ll
Function
* DDL Code
learn how to use phpMyAdmin
generation (CREATE TABLE)
to:
• Effectively perform
* MetaData-Browser for
day-to-day database and
o Namespaces
table management.
• Create
o Tables
o
better database tables and
Views
o
relational structures
•
Routines
o
More easily document your
Classes
o
evolving data
CachedQueries
o
structure
As a MySQL
Stored Procedures o Indexes
server administrator, you’ll
benefit from the in-depth
and practical coverage
of:
• Using phpMyAdmin to
manage users and
privileges
• Getting server
and database
statistics
All database
users will expand and refine
their knowledge of SQL in a
MySQL context through using
phpMyAdmin to track SQL
execution and
results.
This book has
now been updated to cover
v2.6.0
Date: Mar, 20 2007 Date: Feb, 15 2005 Date: Dec, 08 2004 |