To jest tylko wersja do druku, aby zobaczyć pełną wersję tematu, kliknij TUTAJ
phpBB2 by Przemo
Support forów phpBB2 modified by Przemo

F.A.Q. - Read it first! - phpMyAdmin - service

Matteo - 01-09-2010, 20:17
Temat postu: phpMyAdmin - service
When you enter to phpmyadmin, you must choose a database on the left side.
[ Screen 1 ]

On the left and right side you have content viewyour database. You can see name of tables your database.
[ Screen 2 ]

If you want edit content your table, click on it's name on the left side. Now you should see structure of your table.
[ Screen 3 ]

If you pull over the bottom, you could perform various operations on tables. If you want optimize, or repair a table - select it and choose correct operation from menu on the right side.
[ Screen 4 ]

On the top you have inscription Browse, click on it. Now you will see what a data conceals in the table.
[ Screen 5 ]

If you want edit some of record in the table - click on pencil icon, near record. Now you can change table contents.
[ Screen 6 ]

Example you can change username. Just that in field username you change value Matteo to Test then click on Go.
[ Screen 7 ]

If you click on red cross then you will delete record. You can't back this operation, unless you have backup of database.
[ Screen 8 ]

Always on the top in phpMyAdmin you have pop-up menu. If you want send SQL query ex.:
UPDATE phpbb_users SET user_style = 1 WHERE user_style = 4

Click on the SQL
This brings you something like that:
[ Screen 9 ]

To blank field write SQL query and click Go. phpMyAdmin perform operation on database and results show above the window.
[ Screen 10 ]

Truncate - delete from tables ALL records, but leave all structure of table. After this operation we have empty table, which can supplemented by new records.
Drop - delete table. You can't add to this table none records, couse simply you don't have this table. Be careful. :)

(original content)

Powered by phpBB modified by Przemo © 2003 phpBB Group