Phpmyadmin 简明教程

phpMyAdmin - SQL

phpMyAdmin 在 SQL 选项卡下提供一个 SQL 控制台。它的内容根据选择而有所不同。如果没有选择数据库,则 SQL 控制台会在 localhost 上下文中打开,否则会在相关的数据库上下文中打开。给出的示例中,我们选择了 TutorialsPoint 数据库。现在切换到 SQL 会显示以下屏幕。

phpMyAdmin provides a SQL console under SQL Tab. Its context varies as per the selection. If no database is selected, then SQL console opens in localhost context otherwise in relevant database context. In given example, we’ve selected a database TutorialsPoint. Now switching to SQL shows the following screen.

sql

现在让我们运行一个简单查询来查看正在执行的 SQL 选项卡。在用户键入时,SQL 界面会不断建议关键字。您也可以同时按 Ctrl+Space 打开相关建议。

Now let’s run a simple query to see SQL Tab in action. SQL interface will keep suggesting keywords while user types. You can press Ctrl+Space to open the relevant suggestion as well.

sql suggestion

现在单击“执行”按钮,phpMyAdmin 将运行查询并显示如下所示的结果−

Now click on Go Button and phpMyAdmin will run the query and show the result as shown below −

sql result