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

Dumb question.

User, date Message
Written by kbizzle
6 years ago
Category: General
9 posts since Fri, 18 Jul 08
How the heck do I select multiple tables without having to click the check box for all of them?
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
In which dialog?
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
dialog? Sorry, new to this stuff.
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
dialog = window
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08
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?
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
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.
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
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'

Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
I tried the delete querie you wrote in like 10 different combinations and all i get is a syntax error.
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
Any chance you post the queries here so we can proabably solve the problem ...?
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
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.
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
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.
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
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?
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
Here is a pic of the table.

http://i82.photobucket.com/albums/j268/kylebussen/untitled-3.jpg
Written by ansgar
6 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by kbizzle
6 years ago
9 posts since Fri, 18 Jul 08
Haha Wow you would be correct. Had no Idea. Thank you.
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08
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.