mysql control center-prolly stupid question:)

[Marratook]

i have my query set to 1000, and it only show 1000 querys, but its always the first 1000 posts, ie items has about 26000 post if i want it to show that last 1000 post as 25000-26000 can i edit that somewhere?

Also if i want it to show post/ids 2455-3455 is there anyway to do this?

Or is the only way to set up query to like 30000, seems like it eat up alot of memory and a little slow.

Thx in advance

Marratook

[Muuss]

if you have an index field, lets say ID for example, which is a numerical value, you can add a ADD statement to your query, like WHERE ... AND ID>1000 (or whatever)

that's simple but still functionnal

[Marratook]

Sounds great, but i am so bad at sql syntax so would be great if you help me with that:)

Ive tryed a few combos to see if i could find a good syntax

this already exists

SELECT *
FROM `items`

Thx in advance

Marratook[/code]

[Trumpcard]

http://www.1keydata.com/sql/sql.html

[Muuss]

select * from `items` where id>1000;

[lagmann]

i have my query set to 1000, and it only show 1000 querys, but its always the first 1000 posts, ie items has about 26000 post if i want it to show that last 1000 post as 25000-26000 can i edit that somewhere?


Here the query to return the last 1000 item :

Select * from items order by ID desc limit 1000;


Also if i want it to show post/ids 2455-3455 is there anyway to do this?

Select * from items where (id between 2455 and 3455);

hope that help :)

[Marratook]

Really great help guys.

Thx alot

[Kgaul]

also in Control Center you can right click the table you want to view and set your query to 10000 to get all, say, items.

just right click on your table highlight open table, then click return limited and enter the number of items you want to see...

Helps with NPC's and things


Kg

[Shawn319]

Try mysql-Front (2.5).. its a really great program and i hear the people that used to use CC love it...


read bottom of my sig for a link.