Sql query help?

[kreegoth]

Well now heres the issue.. I know i should know this LOL but i dont ..


WHen i use a Query to search for certain parameters in Navicat.. Is there a way to dump only the searched for items to a SQL? i cant seem to figure out how to do that.. I get my list of items i was looking for and then i cant find a way to dump them.. Anyone who knows this let me know please

[EatUrBrains]

So what your saying is your searching for items in navicat query (ones that you have created right?) and trying to dump them?

[kreegoth]

Well not necessarily just that but yes. thats the idea.. Say i wanted to find ALL of the Glyphs.. and dump them to a SQL.. something like that

[EatUrBrains]

not sure if you can do that. only if you have created it and put it in the query your self.

[waymirec]

Not sure how you would do it through Navicat or SQLYog as I don't use them. But using the standard mysql client you can do the following. Just replace the table names and search criteria with whatever you need.

Open up the mysql client and type:

CREATE TABLE custom_items LIKE items;
INSERT INTO custom_items SELECT * FROM items WHERE id BETWEEN(50000,60000);

Then export that table in whatever method you feel comfortable. Either through Navicat/SQLYog or by simply running the following from a command prompt/shell:

mysqldump -n -c -t -p <database_name> custom_items > custom_items.sql

[Link_S]

Maybe like this, i don't know if this is right, can't understand your problem properly.

DELETE FROM items WHERE = itemname

Replace itemname with the name of item.

NOTE: I don't know if this works