如何让PHPMyAdmin显示MySQL警告？-HowtogetPHPMyAdmintoshowMySQLwarnings?

1  

I don't believe Dreamhost gives you access to the configuration file for their installation of phpMyAdmin. However, you can easily make your own installation of phpMyAdmin by downloading the source from their website and just untarring it to the directory you want to access it at (your-domain.com/phpma for example). Then, follow the website's instructions for editing your config file (which should include enabling warnings like you've asked).

我不相信Dreamhost允许您访问配置文件以安装phpMyAdmin。但是,您可以通过从他们的网站下载源代码轻松地自行安装phpMyAdmin,只需将其解压缩到您想要访问的目录(例如,your-domain.com/phpma)。然后,按照网站的说明编辑配置文件(其中应包括启用警告,如您所问)。

1  

I was just looking for the same thing.

我只是在找同样的事情。

When I ran INSERTs using the standard phpMyAdmin 'insert' form, rows would get inserted but a red bar would appear stating any warnings. But when I did a bulk insert, no warnings would appear and a green bar appeared instead just saying the number of rows affected (giving you the impression that it had all gone successfully, when in fact it may not have).

当我使用标准的phpMyAdmin'insert'表单运行INSERT时,将插入行,但会出现一个红色条,表示任何警告。但是当我进行批量插入时,不会出现任何警告,并且会出现绿色条,而只是说影响的行数(给您的印象是它已经成功完成,实际上它可能没有)。

I found I had to send the SHOW WARNINGS command manually. For example, when running this query, I put both statements into the phpMyAdmin SQL box.

我发现我必须手动发送SHOW WARNINGS命令。例如,在运行此查询时,我将两个语句都放入phpMyAdmin SQL框中。

INSERT INTO test2 SELECT * FROM test1;
SHOW WARNINGS;

This gave a list of warnings like the following...

这给出了一系列警告,如下所示......

Level    Code   Message
Warning  1265   Data truncated for column 'a' at row 1
Warning  1265   Data truncated for column 'a' at row 3
Warning  1265   Data truncated for column 'b' at row 3
Warning  1366   Incorrect integer value: 'x' for column 'b' at row...

Things to note:

注意事项:

• You cannot run the SHOW WARNINGS command later, it will appear empty. It must be in the box with your initial query when you click "Go". This is because MySQL only holds the warnings for the last query you ran. Every time you click a link or button phpMyAdmin runs all sorts of other queries on the DB and so your previous warnings get lost.

您以后无法运行SHOW WARNINGS命令,它将显示为空。单击“开始”时,它必须在初始查询的框中。这是因为MySQL只保存您运行的上一个查询的警告。每次单击链接或按钮时,phpMyAdmin都会在数据库上运行各种其他查询,因此您之前的警告会丢失。

• phpMyAdmin does NOT support showing multiple results from a custom query. So doing this as one SQL script does NOT work... (as of version 3.4.10.1)

  phpMyAdmin不支持显示自定义查询的多个结果。所以这样做就像一个SQL脚本不起作用......(从版本3.4.10.1开始)

  INSERT INTO test2 VALUES ('my text', 'something else');
  SHOW WARNINGS;    # you won't see the warnings from here
  INSERT INTO test2 VALUES ('my text', 'something else');
  SHOW WARNINGS;
  

  Although the method above will not work in phpMyAdmin, it SHOULD work fine in the MySQL command line client. So use that if you need to.

  虽然上面的方法在phpMyAdmin中不起作用,但它应该在MySQL命令行客户端中正常工作。如果需要,请使用它。

If you do have multiple inserts and want to show all warnings, you've got to chain them together as a single INSERT statement. For example:

如果您确实有多个插入并希望显示所有警告,则必须将它们作为单个INSERT语句链接在一起。例如:

INSERT INTO test2 VALUES 
('my text', 'something else'), 
('my text', 'something else');
SHOW WARNINGS;

0  

I could be mistaken but if I remember correctly you need to have access to the phpMyAdmin config file to enable it.

我可能会弄错,但如果我没记错,你需要访问phpMyAdmin配置文件来启用它。

0  

follow the website's instructions for editing your config file (which should include enabling warnings like you've asked).

按照网站的说明编辑配置文件(其中应包括启用警告,如您所问)。

Well yes, it should. But I don't see it in the config file and I don't see it in the page you linked to. I've already looked for information in the obvious places, believe me.

是的,它应该。但我没有在配置文件中看到它,我没有在你链接到的页面中看到它。相信我,我已经在显而易见的地方寻找信息了。