mysql control center-prolly stupid question:)
 

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

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

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

Thx in advance

Marratook[/code]

select * from `items` where id>1000;

Re: mysql control center-prolly stupid question:)
 

Here the query to return the last 1000 item :

Select * from items order by ID desc limit 1000;


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

hope that help :)

Really great help guys.

Thx alot

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

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.