MySQL Reference Manual
File title:
MySQL Reference Manual
File content:
General Information About MySQL
What Is MySQL, About This Manual (Conventions Used in This Manual), History of MySQL, Books About MySQL, The Main Features of MySQL, How Stable Is MySQL?, Year 2000 Compliance, General SQL Information and Tutorials, Useful MySQL-related Links.
MySQL Mailing Lists
The MySQL Mailing Lists, Asking Questions or Reporting Bugs, How to Report Bugs or Problems, Guidelines for Answering Question on the Mailing List.
MySQL Licensing and Support
MySQL Licensing Policy, Copyrights Used by MySQL (Copyright Changes), Example Licensing Situations (Selling Products that use MySQL, ISP MySQL Services, Running a Web Server Using MySQL), MySQL Licensing and Support Costs (Payment information, Contact Information), Types of Commercial Support (Basic E-mail Support, Extended E-mail Support, Login Support, Extended Login Support).
Installing MySQL
How to Get MySQL, Operating Systems Supported by MySQL, Which MySQL Version to Use, How and When Updates Are Released, Installation Layouts, Installing a MySQL Binary Distribution (Linux RPM Notes, Building Client Programs, System-speci c Issues (Linux Notes for Binary Distributions, HP-UX Notes for Binary Distributions)), Installing a MySQL Source Distribution (Quick Installation Overview, Applying Patches, Typical configure Options), Installing from development source tree, Problems Compiling?, MIT-pthreads Notes, Perl Installation Comments (Installing Perl on UNIX, Installing ActiveState Perl on Windows, Installing the MySQL Perl Distribution on Windows, Problems Using the Perl DBI/DBD Interface), System-speci c Issues (Solaris Notes, Solaris 2.7/2.8 Notes, Solaris x86 Notes, SunOS 4 Notes), Linux Notes (All Linux Versions), (Linux-x86 Notes, RedHat Version 5.0 Notes, RedHat Version 5.1 notes, Linux-SPARC Notes, Linux-Alpha Notes, MkLinux Notes, Qube2 Linux Notes, Linux IA64 Notes), Alpha-DEC-UNIX Notes (Tru64), Alpha-DEC-OSF1 Notes, SGI-Irix Notes, FreeBSD Notes, NetBSD notes, OpenBSD 2.5 Notes, BSD/OS Notes (BSD/OS Version 2.x Notes, BSD/OS Version 3.x Notes, BSD/OS Version 4.x Notes), SCO Notes, SCO Unixware Version 7.0 Notes, IBM-AIX notes, HP-UX Version 10.20 Notes, HP-UX Version 11.x Notes, Mac OS X Notes, BeOS Notes), Windows Notes (Installing MySQL on Windows, Starting MySQL on Windows 95 or Windows 98, Starting MySQL on NT or Windows 2000, Running MySQL on Windows, Connecting to a Remote MySQL from Windows with SSH, Splitting Data Across Di erent Disks Under Windows, Compiling MySQL Clients on Windows, Windows and BDB Tables, MySQL-Windows Compared to UNIX MySQL), OS/2 Notes, MySQL Binaries, Post-installation Setup and Testing (Problems Running mysql_install_db, Problems Starting the MySQL Server, Starting and Stopping MySQL Automatically, Command-line Options, Option Files), Is There Anything Special to Do when Upgrading/Downgrading MySQL? (Upgrading From Version 3.22 to Version 3.23, Upgrading from Version 3.21 to Version 3.22, Upgrading from Version 3.20 to Version 3.21, Upgrading to Another Architecture).
How Standards-compatible Is MySQL?
MySQL Extensions to ANSI SQL92, Running MySQL in ANSI Mode, MySQL Di erences Compared to ANSI SQL92, Functionality Missing from MySQL (Sub-selects, SELECT INTO TABLE, Transactions, Stored Procedures and Triggers, Foreign Keys (Reasons NOT to Use Foreign Keys constraints), Views, `–’ as the Start of a Comment), What Standards Does MySQL Follow?, How to Cope Without COMMIT/ROLLBACK.
The MySQL Access Privilege System
General Security, How to Make MySQL Secure Against Crackers, What the Privilege System Does, MySQL User Names and Passwords, Connecting to the MySQL Server, Keeping Your Password Secure, Privileges Provided by MySQL, How the Privilege System Works, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification, When Privilege Changes Take Effect, Setting Up the Initial MySQL Privileges, Adding New User Privileges to MySQL, Setting Up Passwords, Causes of Access denied Errors.
MySQL Language Reference
Literals: How to Write Strings and Numbers (Strings, Numbers, Hexadecimal Values, NULL Values, Database, Table, Index, Column, and Alias Names (Case Sensitivity in Names), User Variables, Column Types (Column Type Storage Requirements, Numeric Types, Date and Time Types (Y2K Issues and Date Types, The DATETIME, DATE, and TIMESTAMP Types, The TIME Type, The YEAR Type), String Types (The CHAR and VARCHAR Types, The BLOB and TEXT Types, The ENUM Type, The SET Type), Choosing the Right Type for a Column, Column Indexes, Multiple-column Indexes, Using Column Types from Other Database Engines), Functions for Use in SELECT and WHERE Clauses (Grouping Functions, Normal Arithmetic Operations, Bit Functions, Logical Operations, Comparison Operators, String Comparison Functions, Cast Operators, Control Flow Functions, Mathematical Functions, String Functions, Date and Time Functions, Miscellaneous Functions, Functions for Use with GROUP BY Clauses), CREATE DATABASE Syntax, DROP DATABASE Syntax, CREATE TABLE Syntax (Silent Column Specification Changes), ALTER TABLE Syntax, RENAME TABLE Syntax, DROP TABLE Syntax, OPTIMIZE TABLE Syntax, CHECK TABLE Syntax, BACKUP TABLE syntax, RESTORE TABLE syntax, ANALYZE TABLE syntax, REPAIR TABLE syntax, DELETE syntax, TRUNCATE syntax, SELECT syntax, JOIN syntax, INSERT syntax, REPLACE syntax, LOAD DATA INFILE syntax, UPDATE syntax, USE syntax, FLUSH syntax (clearing caches), KILL syntax, SHOW syntax (Get information about tables, columns,…) (SHOW information about database, tables, columns and index, SHOW status information about tables, SHOW status information, SHOW VARIABLES, SHOW information about connected threads (processes), SHOW GRANTS (privileges) for a user, SHOW CREATE TABLE), EXPLAIN syntax (Get information about a SELECT), DESCRIBE syntax (Get information about columns), BEGIN/COMMIT/ROLLBACK syntax, LOCK TABLES/UNLOCK TABLES syntax, SET syntax, GRANT and REVOKE syntax, CREATE INDEX syntax, DROP INDEX syntax, Comment syntax, CREATE FUNCTION/DROP FUNCTION syntax, Is MySQL picky about reserved words?.
MySQL table types
MyISAM tables (Space needed for keys, MyISAM table formats (Static (Fixed-length) table characteristics, Dynamic table characteristics, Compressed table characteristics)), MERGE tables, ISAM tables, HEAP tables, BDB or Berkeley db tables.
MySQL Tutorial
Connecting to and disconnecting from the server, Entering queries, Examples of common queries (The maximum value for a column, The row holding the maximum of a certain column, Maximum of column per group, The rows holding the group-wise maximum of a certain field, Using user variables, Using foreign keys), Searching on two keys, Creating and using a database (Creating and selecting a database, Creating a table, Loading data into a table, Retrieving information from a table (Selecting all data, Selecting particular rows, Selecting particular columns, Sorting rows, Date calculations, Working with NULL values, Pattern matching, Counting rows), Using more than one table), Getting information about databases and tables, Using mysql in batch mode, Queries from twin project (Find all non-distributed twins, Show a table on twin pair status).
MySQL server functions
What languages are supported by MySQL? (The character set used for data and sorting, Adding a new character set, String collating support, Multi-byte character support), How big MySQL tables can be.
Replication in MySQL
Introduction, Replication Implementation Overview, HOWTO, Replication Features, Replication Options in my.cnf, SQL commands related to replication, Replication FAQ.
Getting maximum performance from MySQL
Optimization overview, System/Compile time and startup parameter tuning (How compiling and linking a ects the speed of MySQL, Disk issues (Using symbolic links for databases and tables), Tuning server parameters, How MySQL opens and closes tables, Drawbacks of creating large numbers of tables in the same database, Why so many open tables?, How MySQL uses memory, How MySQL locks tables, Table locking issues), Get your data as small as possible, How MySQL uses indexes, Speed of queries that access or update data (Estimating query performance, Speed of SELECT queries, How MySQL optimizes WHERE clauses, How MySQL optimizes DISTINCT, How MySQL optimizes LEFT JOIN and RIGHT JOIN, How MySQL optimizes LIMIT, Speed of INSERT queries, Speed of UPDATE queries, Speed of DELETE queries), Other optimization tips, Using your own benchmarks, Design choices, MySQL design limitations/tradeoffs, Portability, What have we used MySQL for?.
The MySQL benchmark suite
MySQL Utilites
Overview of the different MySQL programs, safe mysqld, the wrapper around mysqld, The command line tool, Administering a MySQL server, Dumping the structure and data from MySQL databases and tables, Importing data from text files, Showing databases, tables and columns, The MySQL compressed read-only table generator.
Maintaining a MySQL installation
Using myisamchk for table maintenance and crash recovery (myisamchk invocation syntax (General options for myisamchk, Check options for myisamchk, Repair options for myisamchk, Other options for myisamchk), myisamchk memory usage), Setting up a table maintenance regimen, Getting information about a table, Using myisamchk for crash recovery (How to check tables for errors, How to repair tables, Table optimization), Log file maintenance.
Adding new functions to MySQL
Adding a new user-definable function (UDF calling sequences, Argument processing, Return values and error handling, Compiling and installing user-de nable functions), Adding a new native function.
Adding new procedures to MySQL
Procedure analyse, Writing a procedure.
MySQL ODBC Support
Operating systems supported by MyODBC, How to fill in the various elds in the ODBC administrator program, How to report problems with MyODBC, Programs known to work with MyODBC, How to get the value of an AUTO_INCREMENT column in ODBC, Reporting problems with MyODBC.
Using MySQL with some common programs
Using MySQL with Apache
Problems and common errors
How to determine what is causing problems, What to do if MySQL keeps crashing, Problems when linking with the MySQL client library, Some common errors when using MySQL (MySQL server has gone away error, Can’t connect to [local] MySQL server error, Host ‘…’ is blocked error, Too many connections error, Out of memory error, Packet too large error, Communication errors / Aborted connection, The table is full error, Can’t create/write to file error, Commands out of sync error in client, Ignoring user error, Table ‘xxx’ doesn’t exist error), How MySQL handles a full disk, How to run SQL commands from a text file, Where MySQL stores temporary files, How to protect `/tmp/mysql.sock’ from being deleted, Access denied error, How to run MySQL as a normal user, How to reset a forgotten password, Problems with file permissions, File not found, Problems using DATE columns, Timezone problems, Case sensitivity in searches, Problems with NULL values, Problems with alias, Deleting rows from related tables, Solving problems with no matching rows, Problems with ALTER TABLE, How to change the order of columns in a table.
Solving some common problems with MySQL
Database replication with update log, Database backups, The update log, The binary log, The slow query log, Running multiple MySQL servers on the same machine.
MySQL client tools and APIs
MySQL C API, C API datatypes, C API function overview, C API function descriptions (mysql_affected_rows(), mysql_close(), mysql_connect(), mysql_change_user(), mysql_character_set_name(), mysql_create_db(), mysql_data_seek(), mysql_debug(), mysql_drop_db(), mysql_dump_debug_info(), mysql_eof(), mysql_errno(), mysql_error(), mysql_escape_string(), mysql_fetch_field(), mysql_fetch_fields(), mysql_fetch_field_direct(), mysql_fetch_lengths(), mysql_fetch_row(), mysql_field_count(), mysql_field_seek(), mysql_field_tell(), mysql_free_result(), mysql_get_client_info(), mysql_get_host_info(), mysql_get_proto_info(), mysql_get_server_info(), mysql_info(), mysql_init(), mysql_insert_id(), mysql_kill(), mysql_list_dbs(), mysql_list_fields(), mysql_list_processes(), mysql_list_tables(), mysql_num_fields(), mysql_num_rows(), mysql_options(), mysql_ping(), mysql_query(), mysql_real_connect(), mysql_real_escape_string(), mysql_real_query(), mysql_reload(), mysql_row_seek(), mysql_row_tell(), mysql_select_db(), mysql_shutdown(), mysql_stat(), mysql_store_result(), mysql_thread_id(), mysql_use_result(), Why is it that after mysql_query() returns success, mysql_store_result() sometimes returns NULL?, What results can I get from a query?, How can I get the unique ID for the last inserted row?, Problems linking with the C API, How to make a thread-safe client), MySQL Perl API (DBI with DBD::mysql, The DBI interface, More DBI/DBD information), MySQL Eiffel wrapper, MySQL Java connectivity (JDBC), MySQL PHP API (Common problems with MySQL and PHP), MySQL C++ APIs, MySQL Python APIs, MySQL Tcl APIs.
How MySQL compares to other databases
How MySQL compares to mSQL (How to convert mSQL tools for MySQL, How mSQL and MySQL client/server communications protocols differ, How mSQL 2.0 SQL syntax differs from MySQL),How MySQL compares to PostgreSQL.
MySQL internals
MySQL threads, MySQL full-text search.
Appendix A Environment variables
Appendix B Some MySQL users
General news sites, Some Web search engines, Some Information search engines concentrated on some area, Online magazines, Web sites that use MySQL as a backend, Some Domain/Internet/Web and related services, Web sites that use PHP and MySQL, Some MySQL consultants, Programming, Uncategorized pages.
Appendix C Contributed programs
APIs, Clients, Web tools, Performance Benchmarking tools, Authentication tools, Converters, Using MySQL with other products, Useful tools, RPMs for common tools (Most are for RedHat 6.1), Useful functions, Windows programs, Uncategorized.
Appendix D Contributors to MySQL
Appendix E MySQL change history
Changes in release 3.23.x (Recommended; beta) (Changes in release 3.23.28, Changes in release 3.23.27, Changes in release 3.23.26, Changes in release 3.23.25, Changes in release 3.23.24, Changes in release 3.23.23, Changes in release 3.23.22, Changes in release 3.23.21, Changes in release 3.23.20, Changes in release 3.23.19, Changes in release 3.23.18, Changes in release 3.23.17, Changes in release 3.23.16, Changes in release 3.23.15, Changes in release 3.23.14, Changes in release 3.23.13, Changes in release 3.23.12, Changes in release 3.23.11, Changes in release 3.23.10, Changes in release 3.23.9, Changes in release 3.23.8, Changes in release 3.23.7, Changes in release 3.23.6, Changes in release 3.23.5, Changes in release 3.23.4, Changes in release 3.23.3, Changes in release 3.23.2, Changes in release 3.23.1, Changes in release 3.23.0), Changes in release 3.22.x (Changes in release 3.22.35, Changes in release 3.22.34, Changes in release 3.22.33, Changes in release 3.22.32, Changes in release 3.22.31, Changes in release 3.22.30, Changes in release 3.22.29, Changes in release 3.22.28, Changes in release 3.22.27, Changes in release 3.22.26, Changes in release 3.22.25, Changes in release 3.22.24, Changes in release 3.22.23, Changes in release 3.22.22, Changes in release 3.22.21, Changes in release 3.22.20, Changes in release 3.22.19, Changes in release 3.22.18, Changes in release 3.22.17, Changes in release 3.22.16, Changes in release 3.22.15, Changes in release 3.22.14, Changes in release 3.22.13, Changes in release 3.22.12, Changes in release 3.22.11, Changes in release 3.22.10, Changes in release 3.22.9, Changes in release 3.22.8, Changes in release 3.22.7, Changes in release 3.22.6, Changes in release 3.22.5, Changes in release 3.22.4, Changes in release 3.22.3, Changes in release 3.22.2, Changes in release 3.22.1, Changes in release 3.22.0), Changes in release 3.21.x (Changes in release 3.21.33, Changes in release 3.21.32, Changes in release 3.21.31, Changes in release 3.21.30, Changes in release 3.21.29, Changes in release 3.21.28, Changes in release 3.21.27, Changes in release 3.21.26, Changes in release 3.21.25, Changes in release 3.21.24, Changes in release 3.21.23, Changes in release 3.21.22, Changes in release 3.21.21a, Changes in release 3.21.21, Changes in release 3.21.20, Changes in release 3.21.19, Changes in release 3.21.18, Changes in release 3.21.17, Changes in release 3.21.16, Changes in release 3.21.15, Changes in release 3.21.14b, Changes in release 3.21.14a, Changes in release 3.21.13, Changes in release 3.21.12, Changes in release 3.21.11, Changes in release 3.21.10, Changes in release 3.21.9, Changes in release 3.21.8, Changes in release 3.21.7, Changes in release 3.21.6, Changes in release 3.21.5, Changes in release 3.21.4, Changes in release 3.21.3, Changes in release 3.21.2, Changes in release 3.21.0), Changes in release 3.20.x (Changes in release 3.20.18, Changes in release 3.20.17, Changes in release 3.20.16, Changes in release 3.20.15, Changes in release 3.20.14, Changes in release 3.20.13, Changes in release 3.20.11, Changes in release 3.20.10, Changes in release 3.20.9, Changes in release 3.20.8, Changes in release 3.20.7, Changes in release 3.20.6, Changes in release 3.20.3, Changes in release 3.20.0), Changes in release 3.19.x (Changes in release 3.19.5, Changes in release 3.19.4, Changes in release 3.19.3).
Appendix F Known errors and design deficiencies in MySQL
Appendix G MySQL and the future (The TODO)
Things that should be in 4.0, Things that must done in the real near future, Things that have to be done sometime, Some things we don’t have any plans to do.
Appendix H Comments on porting to other systems
Debugging a MySQL server, Debugging a MySQL client, The DBUG package, Locking methods, Comments about RTS threads, Differences between different thread packages.
Appendix I Description of MySQL regular expression syntax
Appendix J What is Unireg?
Appendix K GNU General Public License
Appendix L GNU Library General Public License
SQL command, type and function index
Concept Index
File type: PDF
File size: 2,363 KB
File url:
http://zid-luxinst.uibk.ac.at/mysql/manual.pdf
MySQL®
File title:
MySQL®
File Content:
How cPanel Distributes and Installs MySQL on Linux, How cPanel Distributes and Installs MySQL on FreeBSD, What Version of MySQL does cPanel currently install?, MySQL Version File Example, Choosing the Version of MySQL that is Right for You, Manually Upgrading MySQL, Manually Upgrading MySQL: How it is Actually Done, The cPanel Naming Conventions and how they Work with MySQL, How cPanel and MySQL Interact, Possible Errors with cpwrap, Basic MySQL Troubleshooting, Scripts Included with cPanel to Help Troubleshoot MySQL, MySQL and Perl Scripts, Additional MySQL Troubleshooting.
File url:
http://www.cpanel.net/docs/seminar/MySQL.pdf
File type: PDF
File size: 148 kb
How to setup and secure Snort, MySQL and Acid on FreeBSD 4.7 Release
File title:
How to setup and secure Snort, MySQL and Acid on FreeBSD 4.7 Release
File content:
Purpose of document, Assumptions, Setting up the viewing station, File system layout, Other installation details, On the initial boot, Updating your ports collection, X-windows, Installing and setting up PGP, Patching BSD, Verifying the PGP signature of the patch, Post-installation cleanup, Installing the necessary ports, Adding a user for Snort, Editing the necessary files, For Snort, For Apache, For ACID, Setting up intial MySQL functionality, Setting up MySQL to accept data from Snort, Setting up Stunnel, Mozilla, Preparing your firewall boot options, Kernel configuration, Setting up rules for IPFW, Setting up the sensor(s), File system layout, Other installation details, On the initial boot, Updating your ports collection, Patching BSD, Post-installation cleanup, Installing the necessary ports, Adding a user for Snort, Editing the necessary files, For Snort, Snort startup script, Setting up Stunnel, Preparing your firewall boot options, Kernel configuration, Setting up rules for IPFW, Miscellaneous, Things that the administrator should do on his/her own, To-do list, Example motd, Lists to subscribe to, Resources.
File url:
http://www.snort.org/docs/FreeBSD47RELEASE-Snort-MySQLVer1-3.pdf
File type: PDf
File size: 65 kb
Where can I find article about MySQL GUI Tools Manual ?
File title:
MySQL GUI Tools Manual
File type: PDF
File url:
http://downloads.mysql.com/docs/guibook-en.pdf
File size: 1.89 mb
File content:
MySQL Enterprise
Installation
Introduction, Installing Under Windows (Using the Windows Installer, Installing From the ZIP File), Installing Under Linux (Installing the Generic Tarball, RPM Installation), Installing Under Mac OS X.
Removing MySQL GUI Tools
Uninstall – Windows, Uninstall – Linux, Uninstall – Mac OS X.
Upgrading MySQL GUI Tools
Upgrading – Windows, Upgrading – Linux (Tarball Upgrade, RPM Upgrade), Upgrading – Mac OS X.
Running MySQL GUI Tools
Running Under Windows, Running Under Linux, Running On Mac OS X.
- MySQL Administrator -
Introduction to MySQL Administrator
Connection Dialog
Advanced Options, Configure-service Mode.
Main Window
Introduction, Sidebar, Working Area, Menus (File, Edit, View, Tools, Help).
Server Information
Service Control
Introduction, Start Stop Service, Configure Service.
Startup Variables
Introduction
Server Connections
Introduction, Threads, User Connections
User Administration
Introduction, User Accounts, User Information, Global Privileges, Schema Privileges, Table Column Privileges, Resources.
Health
Introduction, Connection Health, Memory Health, Creating Custom Health Graphs, Status Variables, System Variables.
Server Logs
Introductions, Error Log, Slow Log, General Log.
Backup
Introduction, Backup Project, Advanced Options (Backup Execution Method, Output File Options), Schedule.
Restore
Introduction, The General Tab, Restore Content.
Replication Status
Introduction, Configuring Replication Servers, Using the Replication Status Section.
Catalogs
Introduction, Schema Tables (Table Status, Row Status), Schema Indexes.
- MySQL Query Browser -
Introduction to the MySQL Query Browser
A Tour of the MySQL Query Browser
The Main Query Window, The Query Toolbar (The Navigation Buttons, The Query Area, The Action Buttons), The Advanced Toolbar, The Result Area, The Object Browser (The Database Browser, The Bookmark Browser, The History Browser), The Information Browser (The Syntax Browser, The Function browser, The Parameter Browser, The Transaction Browser), The Script Editor (The Script Debugging Buttons, The Script Area).
Using The MySQL Query Browser
Entering and Editing Queries Manually, Building Queries, Creating Views, Navigating Result Sets Within the Result Area, Exporting Result Sets, Handling BLOB and TEXT Columns, Editing Result Sets Within the Result Area, Comparing Result Sets, Managing Stored Procedures and Functions with MySQL Query Browser, Editing Queries From a Development Tool.
- Common Administrator and Query Browser Components -
Options Dialog
Introduction, General Options, Connections (SSL Connections), Editors, The Browser Section (Display Options, Query Options, Various), Administrators (User Administration, Health Graphs, Backup).
- Common Administrator and Query Browser Components -
The MySQL Table Editor
Introduction, The Main Editor Window, The Columns And Indices Tab (The Column Editor, The Detail Area), The Table Options Tab, The Advanced Options Tab (The Various Section, The Row Options Section, The Storage Options Section, The Merge Table Options Section, The Table RAID Settings Section), Applying Your Changes.
- MySQL Migration Toolkit -
Introduction to the MySQL Migration Toolkit
An Overview of the Migration Process
The Migration Process In-Depth
Introduction, The Welcome Screen, The Configuration Type Screen, The Source Database Screen (Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Saving Connection Information), The Target Database Screen, The Connect to Server Screen, The Source Schema Selection Screen, The Reverse Engineering Screen, The Object Type Selection Screen (Migrating a Sub-Set of Object Types), The Object Mapping Screen (GRT Object, Table Objects), The Meta Migration Screen, The Manual Editing Screen, The Object Creation Options Screen, The Creating Objects Screen, The Data Mapping Options Screen, The Bulk Data Transfer Screen, The Summary Screen, Saving the Current Application State.
Scripted Migration
The Steps for Scripted Migration, Setting the Source and Target Connection, Reverse Engineering, Migration Methods, Map Objects and Migrate, The SQL Create Statements, Bulk Data Transfer.
Extending The MySQL Migration Toolkit
Introduction, Architecture of the MySQL Migration Toolkit, The Modular Migration Process, Tools Required to Extend the MySQL Migration Toolkit.
Preparing a Microsoft Access Database for Migration
The Generic Runtime Environment (GRT) Shell
Introduction, Exploring the GRT Shell (Menu Items, The Shell, The Globals Tree Panel), Using the GRT Shell, Invoking the GRT Shell From the Command Line.
- Appendixes -
Installing From Source
Introduction, Downloading The Source Code, Building from Source under Windows (Prerequisites, Compiling and Building), Building from Source under Linux (Prerequisites), Compiling and Building (Building Static Binaries, Building RPMs).
Troubleshooting Application Errors
Troubleshooting Connection Errors, Troubleshooting Display Problems.
How Connections Are Stored
XML Files Common to the MySQL GUI Applications
XML Files Used by MySQL Query Browser
XML Files Used by MySQL Administrator
The MySQL System Tray Monitor
Third-party Software Used by the MySQL GUI Tools
PCRE Library, PNG Support
Notes for Translators
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
File title:
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
File type: PDF
File url:
http://www.unixodbc.org/doc/OOoMySQL.pdf
File size: 2.12 mb
File content:
‘Access’ your data - OpenOffice.org 1.0’s best kept secret
‘Access’ for Linux?, Software options, Notes for users of MS-Windows platforms.
Joining OpenOffice.org 1.0 to MySQL using ODBC
Installing MySQL, Testing MySQL, Installing unixODBC and the MySQL libraries, Creating the ODBC .ini files, Testing ODBC, Setting up ODBC within OpenOffice.org 1.0, If you use another installation method.
Using the Data Source Tools in OpenOffice.org 1.0
Finding the Data Source Tools, Working with Table Definitions (Creating a table, Designing Indexes, Changing the definition of a table), Editing data, Using the Database Toolbar to work with your data (Displaying/Hiding the Data Source Explorer, Find Record, Sort Ascending / Sort Descending, AutoFilter, Default Filter, Sort, Remove Filter / Sort, Apply Filter, Refresh, Edit Data, Save Current Record), Creating new Views of your data (Rows in the Query Design table, The Query Toolbar), More Complex Queries (Example 1 - Orders on Hand, Example 2 - Summary Orders on Hand).
Using Data Sources in other OpenOffice.org 1.0 programs
Calc (Creating a link with Drag and Drop, Menu Options, Data Pilot), Writer (Creating a link with Drag and Drop, Using the Database Toolbar).
Using the Form AutoPilot
The Form AutoPilot in action