Welcome Visitor, Please Login or Register Now Thursday, March 28, 2024 11:36 PM 
Forums Index > Mewsoft Products > Searchawy > sql command on Cat_ID
New Topic   New Reply
Search for:
Author Message
marty marty's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 11:36 PM
Member Offline
View Member's Profile PM
 
Back to top
sql command on Cat_ID Edit Delete Reply with quote Quote
First Post Posted on: 03-14-13 11:54 PM next post first post
Is it possible to delete a main category with a sql command that would also delete all its sub categories, if so what what command would that be ?\ \ DELETE From Directories Select Cat_ID = xxxxx ?\ DELETE From Directories_Name Select Cat_ID = xxxxx ?\ \ Like would deleting a main category delete its sub cats as well ? \ \ Any advice on doing this please, I need to delete my Cat's down to a respectable level.\ \ Marty
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-28-24 11:36 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: sql command on Cat_ID Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 03-15-13 01:34 AM next post previous post
When you delete a category from the admin->category manager, it deletes all its sub categories tree automatically.

Mewsoft Support
www.mewsoft.com

marty marty's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 11:36 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: sql command on Cat_ID Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 03-15-13 01:45 AM next post previous post
\ \ \ \ \
\ \ \ \ \ \ \ \
mewsoft's Wrote:
When you delete a category from the admin->category manager, it deletes all its sub categories tree automatically.
\
\ \ I understand what your saying, but unfortunately the Cat's list is so big I cant do that, it hangs (times out). Thus I didn't want to try the above etc..\ \ I don't mind if the sub cats are still listed in the mysql database, I just didn't want the system to try and read them.\ \ Would the above command help out with load times.\ \ Basically I dont want or need 2+ million links, thus that will reduce my Cat's by two hundred thousand.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 03-28-24 11:36 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: sql command on Cat_ID Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 03-15-13 11:24 AM next post previous post

You can run any lengthy commands from telenet, anyway, the commands you asked:

    DELETE FROM DirCategories WHERE Cat_ID=xxxx
    DELETE FROM DirCategories_Name WHERE Cat_ID=xxxx
    DELETE FROM DirCategories_Description WHERE Cat_ID=xxxx
    DELETE FROM DirCategories_Meta WHERE Cat_ID=xxxx


Mewsoft Support
www.mewsoft.com

marty marty's personal page
Registered Member
Posts: Display member's posts
Joined: 03-28-24 11:36 PM
Member Offline
View Member's Profile PM
 
Back to top
Re: sql command on Cat_ID Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 03-15-13 11:55 AM last post previous post
Thank you...
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print