All geek questions in one place

Phpmyadmin shows full sql output

It seems phpmyadmin truncates the end of sql output when running control commands. I really need phpmyadmin to show full output

enter image description here

Any ideas?

+6
source share
2 answers

After a quick google search, I found this: http://wiki.phpmyadmin.net/pma/Config#MaxCharactersInDisplayedSQL

It seems you just need to edit the PHPmyadmin configuration file and set $cfg['MaxCharactersInDisplayedSQL'] = 1000; to the value you need.

+6
source

My problem was even simpler. I used the "show create table", but the result was truncated after a few characters.
PHPMyAdmin actually has a small "+options" link for the results, with simple parameters like "truncating the results." Just need to undo it!

If you want to edit the files mentioned by Torr, find:

  • config.default.php , in the "librairies" folder containing existing parameters
  • config.inc.php where you have to copy / paste the ones you need.
+1
source

Source: https://habr.com/ru/post/917408/

More articles:


All Articles