 |
|
 |
Source Site » dev.mysql.com
Search another site:
| Total: 11 | Showing: 11 | Page 1 of 1 |
 |
|
|
 MySQL / General Guides MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables: Site: dev.mysql.com
|
||
|
|
Report |
|
|
|
MySQL / General Guides This chapter provides a brief overview of the command-line programs provided by MySQL AB and discusses the general syntax for specifying options when you run these programs. Most programs have options that are specific to their own operation, but the option syntax is similar for all of them. Later chapters provide more detailed descriptions of individual programs, including which options they recognize. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides In the previous sections, you used mysql interactively to enter queries and view the results. You can also run mysql in batch mode. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides Creating the database is the easy part, but at this point it's empty, as SHOW TABLES tells you: Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides Before you can start creating tables you need to have a database.creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides Once you know how to enter commands, you are ready to access a database. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides It's more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering commands, using several queries you can try out to familiarize yourself with how mysql works. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / General Guides To connect to the server, you will usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you will also need to specify a host name. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / Optimization Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want your system to become, the more you must know about it. Site: dev.mysql.com
|
||
|
|
|
|
|
|
MySQL / Replication and Backup This chapter describes the various replication features provided by MySQL. It introduces replication concepts, shows how to set up replication servers, and serves as a reference to the available replication options. Site: dev.mysql.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|