Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need help using Search tab in phpMyAdmin


kbking

Recommended Posts

Posted

Hi!

 

I want to find all the configuration_group_id:s = 20 and 21, and all the configuration_id values 228 to 258, that might allready be in use in my database, by using the Search tab in phpMyAdmin.

 

I'm not sure on how to use the Search tab for this and need help to rest assured that I find possible conflicts if any.

 

TIA

/kbking

Posted

Here's how I'm doing it:

 

I'm opening the table configuration -> Click on Search Tab -> Pick the field configuration_id -> Change rows per page from 30 to 30000 (just to be safe) -> Type 228 in Add Search Criteria -> Hit the Go button.

 

This generates 350 results, ranging from 1 to 1016.

 

231 - 258 are listed and by that fact in use, I guess.

 

So in this case I need to change the numbers in the sql-file to something not listed in my above search operation, right?

 

And the same procedure for configuration_group_id:s, I presume!?

 

Would my reasoning here be to play it safe enough?

 

The instruction that I want to follow is:

 

---------------------------------------------------

::: INSTALLATION :::

---------------------------------------------------

(01) Run the SQL. Please note: You should always check to make sure the configuration_group_id and configuration_id value do not already exist in your DB.

 

The included SQL uses:

 

- configuration_group_id = 20 and 21

- configuration_id = 228 to 258

 

---------------------------------------------------

Posted

Just to be safe, you could use the browse tab, then use the page dropdown menu to skip ahead a few pages...the configuration table is listed in order of configuration_id ...skip ahead to page 4 or so with the page dropdown menu to get close ...and just browse to check those entries from 238-258

 

If you use the SQL tab, you can do this to see the entries of configuration_id from 228-258

 

SELECT *

FROM `configuration`

WHERE `configuration_id` >=228

AND `configuration_id` <=258

LIMIT 0 , 30

 

and this will find configuration_group id 20 or 20

 

SELECT *

FROM `configuration`

WHERE `configuration_group_id` =20

OR `configuration_group_id` =21

LIMIT 0 , 30

Posted
Just to be safe, you could use the browse tab, then use the page dropdown menu to skip ahead a few pages...the configuration table is listed in order of configuration_id ...skip ahead to page 4 or so with the page dropdown menu to get close ...and just browse to check those entries from 238-258

 

If you use the SQL tab, you can do this to see the entries of configuration_id from 228-258

 

SELECT *

FROM `configuration`

WHERE `configuration_id` >=228

AND `configuration_id` <=258

LIMIT 0 , 30

 

and this will find configuration_group id 20 or 20

 

SELECT *

FROM `configuration`

WHERE `configuration_group_id` =20

OR `configuration_group_id` =21

LIMIT 0 , 30

 

Thanks for an elaborate answer, just what I needed here! :)

 

Thank You!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...