MYSQL Guide

From WoWRosterWiKi
Jump to: navigation, search
WR.net

Important note: When you edit this page, you agree to release your contribution into the public domain.
If you do not want this or can not do this because of license restrictions, please do not edit.

Contents


Warning.png Translation in Progress: This is still being translated from the original article MYSQL_Guide/de

PHPMyAdmin - Installation and Basic Operation

For those who have no idea how to administer their databases can visit a guide for the tool PHPMyAdmin.

PHPMyAdmin is a PHP script that allows you to access and modify your MySQL databases.
With this tool, it is possible to add new databases (as long as your service provider allows), add/modify tables, and add/modify the data in databases.

The latest version is available here: http://www.phpmyadmin.net


The installation

Installation is almost as simple as installing WoWRoster or UniAdmin
So once this is done, it's easy street!

Info.png Note: Many times your web host will provide PHPMyAdmin via your control panel
We suggest you use this instead of installing it yourself


Using PHPMyAdmin

PHPMyAdmin will show up in 3 sections when you first view it

Info.png Note: You may need to enter your MySQL username and password to access PHPMyAdmin
This can usually be found in the server control panel, and is usually given to you when you first got your server
  1. The left side
    The PHPMyAdmin Logo and a small button bar
    This shows all of the databases you have access to
  2. The center
    Shows you information about the current server
  3. The right side
    Displays information about PHPMyAdmin itself
    You can select a different server here, when multiple servers are defined


The Left Side Buttons:

Among them you will find in most cases a drop-down list of all the databases on the current server. Once you have selected a database will include a list of tables in the database, and the right of the page loads.

As you can see right now the structure of the database (ie tables). You see the table name, an action bar, the number of entries in the table, the type of table, the Collation (?), The size of the table (including data), and possibly an overhang (data not assigned). If you deal with the mouse on a button in the action bar, get your ride a little Tooltyp with regard to its function. Will your data directly into a spreadsheet register clicks on the 4th Button in the action bar next to the name of the table. Will you all your data in the table view, clicking on the 1st Button in the action bar. This button is only available if data in the table. You can also add links to a table name click, then you get to see its structure. The structure consists of a table field names, polja, field size, etc. In this view, you can new fields in the table, to give below the table structure, the number fields, which you want to add and how these are to be added (at the beginning, at the end or after a given field). Will your only data in the table above, click on Insert and you will get a query with all field name of the table, then you will wear the appropriate information.


When you change data have you two options:

Or

To select multiple items at once to deal marks the checkbox in front of the entries to edit your want and clicking on the pen next to the word "marked".

So this should be a short introduction to the basic operating range. More extensive information can be found in the documentation or on http://wiki.cihar.com/ PHPMyAdmin.

Personal tools
Namespaces
Variants
Actions
WoWRoster
Navigation
Toolbox