Phpmyadmin running SQL problems this post is finally edited in phpmyadmin by huoshi5151 from 2012-12-0921: 58: 13. no matter how the SQL statement conditions are written, click "run" and always SELECT & nbsp; * & nbsp; FROM & nbsp; 'test' & nbsp; WHERE & nbsp; 1 & nbsp; LIMIT & nbsp; 0 & phpmyadmin SQL running problems
This post was last edited by huoshi5151 at 21:58:13, January 9 ,.
In phpmyadmin, no matter how SQL statement conditions are written, after clicking execute
SELECT *
FROM `test`
WHERE 1
LIMIT 0 , 30
For example, the SQL statement I entered is
SELECT `name` FROM `test` WHERE `id`=2
After the result is clicked
SELECT *
FROM `test`
WHERE 1
LIMIT 0 , 30
Output
------ Solution --------------------
What is the relationship between them?
------ Solution --------------------
The problem with the phpmyadmin version should be that you can try it with the latest version, but you cannot change the SQL management tool. isn't it okay to execute statements in PHP?
------ Solution --------------------
Right? what do you think is the right result?
------ Solution --------------------
Reference:
Reference: The problem with phpmyadmin is that you can try another version, but you cannot change the SQL management tool. isn't it okay to execute statements in PHP?
Php execution also seems to be a problem
PHP code? 123456789 <[email protected] _ connect ("localhost", "root", "123456") or die ("link failed"); mys ......
[Email protected] _ connect ("localhost", "root", "123456") or die ("link failed ");
Mysql_select_db ("test", $ conn );
$ SQL = "SELECT * FROM 'test '";
$ Row = mysql_fetch_array ($ SQL );
Var_dump ($ row );
?>
Mark the result as follows: