phpMyAdmin: other commands

3.4.4. phpMyAdmin: other commands

Yet another couple of instructions: In order to see the structure of a table, you only need to click on the one that is marked in the left bar and you will see all its fields and modification options appear in the central part (Figure 3-12).

Figure 3-12. phpMyAdmin: table forum_topics.

phpMyAdmin: table forum_topics.



Caution ATTENTION!
 

The DROP command eliminates all the contents of the DB, the table or the single field, use it with caution.

To learn more about the possibilities that phpMyAdmin offers you in administering your databases, see Doing More With phpMyAdmin (Part 1) and Doing More With phpMyAdmin (Part 2). The first part explains how to obtain the software, install and configure it for secure access, and use it for tasks such as managing multiple servers, manipulating user privileges, viewing reports on server activity, and exporting MySQL records into different formats. The second part explains the more advanced aspects of the application, including using it for transformations, maintaining a history of all the SQL queries executed in the phpMyAdmin session, defining relations between tables to create JOINs automatically, creating E-R diagrams in PDF format, and bookmarking important queries for future reference.


Help us make a better PHP-Nuke HOWTO!

Want to contribute to this HOWTO? Have a suggestion or a solution to a problem that was not treated here? Post your comments on my PHP-Nuke Forum!

Chris Karakas, Maintainer PHP-Nuke HOWTO

 

Site Info v2.2.2

Last SeenLast Seen
Server TrafficServer Traffic
  • Total: 342,457,704
  • Today: 103,703
Server InfoServer Info
  • Nov 22, 2017
  • 09:24 pm PST
 
 

Daily Inspiration