phpMyadmin not showing full output
Sorry if this is in the wrong section, I thought it looked like the one best suited.
I have been using phpmyadmin and mysql to create a database and query it. When I run my script, it works okay, providing a 'full' output (about 40 queries), showing each statement and the result. (i.e 2 rows inserted. (Query took 0.0046 seconds.)). This is until I add some code to create a copy of a table:
CREATE TABLE IF NOT EXISTS copy_of_X LIKE X;
INSERT IGNORE copy_of_X SELECT * FROM X;
After this, the output becomes a single line saying that '# 3 rows affected.' This no longer shows any results from select statements or the rest of the creation of the database.
The code all runs still and but before I can see this database in the menu showing a list of all databases, I must first re-log. Since the code creates the tables still and inserts into tables I was thinking it might be a setting on phpmyadmin however this is just a guess.
Does anyone know how to fix this? Thanks
Subject
Written By
Posted
phpMyadmin not showing full output
January 06, 2018 07:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.