distal-attribute
distal-attribute
distal-attribute
distal-attribute

Dumb question.

kbizzle posted 6 years ago in General
How the heck do I select multiple tables without having to click the check box for all of them?
ansgar posted 6 years ago
In which dialog?
kbizzle posted 6 years ago
dialog? Sorry, new to this stuff.
ansgar posted 6 years ago
dialog = window
Dr. Dave posted 6 years ago
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?
kbizzle posted 6 years ago
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.
ansgar posted 6 years ago
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'

kbizzle posted 6 years ago
I tried the delete querie you wrote in like 10 different combinations and all i get is a syntax error.
ansgar posted 6 years ago
Any chance you post the queries here so we can proabably solve the problem ...?
kbizzle posted 6 years ago
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.
ansgar posted 6 years ago
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.
kbizzle posted 6 years ago
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.
kbizzle posted 6 years ago
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?
kbizzle posted 6 years ago
Here is a pic of the table.

http://i82.photobucket.com/albums/j268/kylebussen/untitled-3.jpg
ansgar posted 6 years ago
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.
kbizzle posted 6 years ago
Haha Wow you would be correct. Had no Idea. Thank you.
Dr. Dave posted 6 years ago
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.

Please login to leave a reply, or register at first.