本文介绍了PHPMyAdmin中没有结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

使用Mysql控制台进行此操作

This with the Mysql Console:

set @Name=CONCAT('seq_0_to_',DATEDIFF('2015-12-15','2015-12-05')-1);
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> set @s =CONCAT("SELECT DAYNAME('2015-12-05' + INTERVAL (seq) DAY) day,'2015-12-05' + INTERVAL (seq) DAY date FROM ",@Name);
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> PREPARE stmt FROM @s;
Query OK, 0 rows affected (0.00 sec)
Statement prepared

MariaDB [test]> EXECUTE stmt;
+-----------+------------+
| day       | date       |
+-----------+------------+
| Saturday  | 2015-12-05 |
| Sunday    | 2015-12-06 |
| Monday    | 2015-12-07 |
| Tuesday   | 2015-12-08 |
| Wednesday | 2015-12-09 |
| Thursday  | 2015-12-10 |
| Friday    | 2015-12-11 |
| Saturday  | 2015-12-12 |
| Sunday    | 2015-12-13 |
| Monday    | 2015-12-14 |
+-----------+------------+
10 rows in set (0.00 sec)

在PMA中,我只能得到:

In PMA I get only:

 # Datensätze: 10

但没有控制台能给我的结果.

but no results like the console gives me.

为什么?

推荐答案

这是phpMyAdmin中的一个问题,该问题已在4.6.0版中修复: https://github.com/phpmyadmin/phpmyadmin/issues/11741

This was an issue in phpMyAdmin which was fixed in version 4.6.0: https://github.com/phpmyadmin/phpmyadmin/issues/11741

这篇关于PHPMyAdmin中没有结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-28 19:07