Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

What is the exact query used by phpmyadmin's SELECT function

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

What is the exact query used by phpmyadmin's SELECT function

Postby jacen6678 » Sun Jun 27, 2004 1:34 pm

Does anyone know the exact query run by phpmyadmin when you goto select (click a table and choose select from the list Print view, Browse, Select, Insert).



I have been using a generic SELECT query like:

SELECT * FROM some_table WHERE name='some_name'

I noticed that in one case, phpmyadmin's select finds more results then the generic query. What is phpmyadmin doing differently?
jacen6678
New php-forum User
New php-forum User
 
Posts: 2
Joined: Sun Jun 27, 2004 1:23 pm

Postby ruturajv » Sun Jun 27, 2004 7:47 pm

by default phpmyadmin appends
Code: Select all
limit 0, 30

and hence limits the recordset
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India

not the answer I was looking for...

Postby jacen6678 » Sun Jun 27, 2004 9:47 pm

I know that phpmyadmin adds a limit 0, 30. But it also manipulates the WHERE clause somehow. For example, it renders case insensitive. What are all of the manipulations to the where clause?
jacen6678
New php-forum User
New php-forum User
 
Posts: 2
Joined: Sun Jun 27, 2004 1:23 pm


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.