如何为您的数据库使用phpMyAdmin

曾经终败给现在 2022-12-06 15:35 140阅读 0赞

Abhilash writes "I am using phpMyAdmin… so how can I interact with the database?"

Abhilash写道：“我正在使用phpMyAdmin ...，如何与数据库进行交互？”

Hi Abhilash! phpMyAdmin is a great way to interact with your database. It allows you the flexibility of using the interface, or simply using SQL commands directly. Let's take a closer look at how to use it!

嗨，阿比拉什！ phpMyAdmin是与数据库交互的好方法。 它使您可以灵活地使用界面，或直接使用SQL命令。 让我们仔细看看如何使用它！

First navigate to your phpMyAdmin login page. Enter your username and password to access your database.

首先导航到您的phpMyAdmin登录页面。 输入您的用户名和密码以访问数据库。

Now that you have logged in, you will see a screen that has all of your database's basic information. From here there are several things you can do. Let's say you want to run a bit of SQL script. On the left hand side of the screen, there are some small buttons. The first button is a home button, then an exit button, and the third is a button that reads SQL. Click on this button. This should prompt a popup window.

现在，您已经登录，您将看到一个包含所有数据库基本信息的屏幕。 从这里可以做几件事。 假设您要运行一些SQL脚本。 在屏幕的左侧，有一些小按钮。 第一个按钮是主页按钮，然后是退出按钮，第三个按钮是读取SQL的按钮。 点击这个按钮。 这将提示一个弹出窗口。

Now, if you wish to run your code you have two options. Option one is to type or paste in the SQL code directly. The second option is to choose the "Import Files" tab. From here you can import files full of SQL code. Often when you download software they will include files like this to help you install it.

现在，如果您希望运行代码，则有两个选择。 选项一是直接键入或粘贴SQL代码。 第二个选项是选择“导入文件”选项卡。 从这里可以导入完整SQL代码文件。 通常，当您下载软件时，它们会包含这样的文件来帮助您安装它。

Another thing you can do in phpMyAdmin is browse your database. Click on the database name in the left hand column. It should expand to show you a list of tables within your database. You can then click on any of the tables it contains.

在phpMyAdmin中可以做的另一件事是浏览数据库。 单击左侧列中的数据库名称。 它应该展开以显示数据库中的表列表。 然后，您可以单击其中包含的任何表。

There are several tabs of options on the top of the right page now. The first option is "Browse". If you select browse, you can view all of the entries in that table of the database. You can edit, or delete entries from this area of [phpMyAdmin][]. It is best not to change data here if you aren't exactly sure what it's doing. Only edit what you understand because once deleted it is irreversible.

现在，右侧页面顶部有几个选项卡。 第一个选项是“浏览”。 如果选择浏览，则可以查看数据库该表中的所有条目。 您可以在[phpMyAdmin的][phpMyAdmin]此区域中编辑或删除条目。 如果您不确定自己在做什么，最好不要在此处更改数据。 只编辑您了解的内容，因为一旦删除，它是不可逆的。

The next tab is the "Structure" tab. From this table you can view all of the fields within the database table. You can remove or edit the fields from this area too. You can also change the data types here.

下一个标签是“结构”标签。 在此表中，您可以查看数据库表中的所有字段。 您也可以从该区域删除或编辑字段。 您也可以在此处更改数据类型。

The third table is the "SQL" tab. This is similar to the pop up SQL window that we discussed earlier in this article. The difference is that when you access it from this tab, it already has some SQL pre-filled in the box pertaining to the table from which you accessed it.

第三个表是“ SQL”选项卡。 这类似于我们在本文前面讨论的弹出SQL窗口。 区别在于，当您从该选项卡访问它时，它已经在与访问它的表有关的框中预填充了一些SQL。

The forth tab is the "Search" tab. As it's name implies this is used to search your database, or more particularly the table form which you accessed the tab. If you access the search feature from the main phpMyAdmin screen you can search all of the tables and entries for your entire database. This is a very useful feature, that could be completed using only SQL but for many programmers as well as non-programmers it's nice to have the simple to use interface.

第四个标签是“搜索”标签。 顾名思义，它用于搜索数据库，或更具体地说是用于访问选项卡的表格形式。 如果从phpMyAdmin主屏幕访问搜索功能，则可以搜索整个数据库的所有表和条目。 这是一个非常有用的功能，可以仅使用SQL来完成，但是对于许多程序员和非程序员而言，拥有易于使用的界面非常好。

The next tab is "Insert" which allows you to add information to your database. It is followed by the "Import" and "Export" buttons. As they imply they are used to import or export data from your database. The Export option is particularly useful, as it allows you to make a backup of your database from which you can restore if you ever have an issue. It is a good idea to [backup data often][]!

下一个选项卡是“插入”，它允许您向数据库中添加信息。 随后是“导入”和“导出”按钮。 正如它们所暗示的那样，它们用于从数据库中导入或导出数据。 导出选项特别有用，因为它使您可以备份数据库，如果遇到问题可以从中还原。 [经常备份数据][backup data often]是个好主意！

Empty and Drop are both potentially dangerous tabs, so please use them with caution. Many a novice has clicked through these tabs only to have their database disappear into the great unknown. Never delete unless you are absolutely sure it won't break things!

空和掉落都是潜在的危险标签，因此请谨慎使用。 许多新手单击了这些选项卡，只是使他们的数据库消失在鲜为人知的地方。 除非您绝对确定它不会破坏任何东西，否则切勿删除！

Hopefully that gives you some basic ideas of how you can use phpMyAdmin to work with the database on your website.

希望这为您提供了一些有关如何使用phpMyAdmin来处理网站上的数据库的基本想法。

> 翻译自: [https://www.thoughtco.com/use-phpmyadmin-for-your-database-2693965][https_www.thoughtco.com_use-phpmyadmin-for-your-database-2693965]

[phpMyAdmin]: https://www.thoughtco.com/repairing-mysql-database-with-phpmyadmin-2693966
[backup data often]: https://www.thoughtco.com/backup-and-restore-mysql-databases-2693879
[https_www.thoughtco.com_use-phpmyadmin-for-your-database-2693965]: https://www.thoughtco.com/use-phpmyadmin-for-your-database-2693965