Dumb question.

How the heck do I select multiple tables without having to click the check box for all of them?

In which dialog?

dialog? Sorry, new to this stuff.

dialog = window

From the sounds of it, I would assume he/she is talking about the Export dialog box, in which case you either click the 'select all' icon then deselect the tables you don't want to include, or select the tables you want included manually.

This seems sort of an odd question but I'm probably assuming incorrectly that you're referring to the Export dialog window. And please pardon me if this sounds rude, but if you don't know what a "dialog box" is, or have never heard of the term, why exactly are you on a computer and/or messing with SQL?

I am trying to delete rows out of some of my tables. I dont want to click on every single check box next to the rows in order to delete all of them. I dont wanna delete the whole table because there are some things that I want to keep in it.

Ok, so you're talking about the data tab and the grid...

You should run a DELETE query in the Query tab which deletes all relevant rows:

DELETE FROM mytable WHERE title LIKE '%foo%' AND when BETWEEN '2004-03-02' AND '2008-07-06'

I tried the delete querie you wrote in like 10 different combinations and all i get is a syntax error.

Any chance you post the queries here so we can proabably solve the problem ...?

Im sorry, I dont know quite what to post. Here is what it is.

Table: Vendors
Columns: Entry, Item, Amount, Max Amount, Inctime

Here is the query I was trying to do.

DELETE FROM vendors WHERE entry = 50000


The entries are numbers only and that entry 50000 has about 200 rows. Im trying to delete all rows with entry 50000.

Hope this helps. Thanks for the work so far.

The DELETE query looks good. Which error message did you get?

I only see a difference in the case of "entry" + "Entry". Maybe that's relevant.

The error im getting says this:

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM vendors WHERE entry = 50000 ORDER BY 'ent

I capatalized the E in Entry but it is technically all lower case in my DB.

Let me ask, does the query also have to include those other columns, ie... item, amount, max_amount, inctime, in order for it to delete the whole row?

Here is a pic of the table.

http://i82.photobucket.com/albums/j268/kylebussen/untitled-3.jpg

Well, the DELETE query is ok so far, nothing to add, really. But I have a slight idea you typed this DELETE into the Filter editor instead of the Query editor??

Ensure you are in the Query tab and execute the DELETE from there using F9. Look here if you don't get what I mean.

Haha Wow you would be correct. Had no Idea. Thank you.

And of course you know that if you do eventually delete those entries, your private world of warcraft game will throw errors when the logonserver boots.