Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Sql question (need to delete all tags with 1 count) database

⇧
0
⇩
48 views

Hi all I have a big tag datebase which has 100s of thousands of "1 count tag" rows

enter image description here

Is there a easy way I can remove all these rows from my datebase? deleting them one by one would take me a life time :D

Many Thanks enter image description here

mysql sql database table row
asked April 14, 2011 1:02 pm CDT
Vodkaholic
posted via StackOverflow

2 Answers

⇧
3
⇩
Best answer
 
 
delete from tags where tag_count = 1;

Assuming the column that has the count is called tag_count since I cannot see it.

answered April 14, 2011 1:23 pm CDT
lobster1234
⇧
0
⇩
 

Assuming you have a Tags table that defines the tags, and a TagSummary view that shows the number of times each tag is used, you can then do a delete query:

DELETE FROM Tags
WHERE TagID IN 
    (SELECT TagID From TagSummary WHERE TagCount=1)
answered April 14, 2011 1:23 pm CDT
mdma

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
SQL query to delete all abandoned tags from WordPress database
January 10, 2011
Delete a string w/ certain tags using preg_replace
February 22, 2011
MySQL DELETE With a Sub-Query using Having and Count
February 8, 2011
Simple Question: How to delete n-th word in a string
March 15, 2011
Question about delete row from table with conditions uniqueField = 1
March 28, 2011
How to count number of deleted rows from one table in delete + join structure ?
January 10, 2011
Mysql, AVG and Count question
February 9, 2011
PostgreSQL join question: delete records present in one table, but not another
April 6, 2011
MySQL count + rollup to subtotal a query question
March 25, 2011
MySQL Count Distinct Values Query Question
January 14, 2011
How do I get similar domains from database using tags?
January 20, 2011
Storing tags without several trips to the database.
March 22, 2011
Regular expressions: how to remove machine tags from my tags list
February 24, 2011
Php/mySQL How do I get all the tags from the database for multiple items?
March 8, 2011
Most used tags of author - mysql normalised database
March 30, 2011
PHP Preg_Replace data between tags, respecting other tags within the document
March 18, 2011
Database schema for tags with JOIN and fulltext search ?
April 4, 2011
Is this the correct way to add tags to a Toxi database tagging scheme?
March 30, 2011
Matching Comma Separated mysql tags to database values (WP - PHP)
March 10, 2011
Logical Delete from an EJB database
January 17, 2011
Database: on update and on delete - how to handle?
April 9, 2011
Delete MySQL database and users
January 30, 2011
SQL trigger to delete rows from database
January 12, 2011
Send sms to delete user from database Kannel
February 17, 2011
How to delete all rows in all table of a database in mysql
February 19, 2011
Delete TEST database - supplied with phpMyAdmin
April 4, 2011
Cannot delete a database object after restarting the application
January 24, 2011
MySQL delete entries in database which are more than a month old
February 14, 2011
Android SQL : Find And Delete Item From SQL Database
April 2, 2011
What can I delete after moving MySQL database files location
December 23, 2010