how to delete the links from wp_links tables using WP Pages?

You … don’t use pages. Go to WP Admin -> Links. Delete.

i mean wp_links, not wp_n_links:(
dude, your method not works:(

Can you elaborate on “not works”? Do you not see the links in the list under Link content type? Do you see them and they do not respond to delete functions?

Same thing. You don’t remove links for your sites from the DB. You (generally) never mess around in the DB unless you’re crazy like me ??

WP Admin -> Links.

Delete the links you don’t want.

Now. Are you trying to ask ‘How do I set it up so all new sites on my network have a set of default links that I define?’

@john operation as told can only delete records in talbe wp_n_links, not table wp_links

What Mika and I are saying is don’t delete any records from the database. Leave it alone. The task you are trying to accomplish is carried out through the regular user interface. We are just trying to figure out if you have actually tried it, did it work, if not, did you get an error, etc…

Do Not Modify The Database Directly (unless you are quite fluent in the table relationships and WP data structure)

So just to clarify, please log into your blogs admin panel (www.blogname.com/wp-admin) and click on Links. You should see a list of the links that populate the blogroll widget. You can select and delete any of the links you want. You can even add new ones. They have categories, etc…

I apologize if you already know this and have been encountering errors, we just want to know what the errors are because deleting content from the database directly is just a horribly bad idea.

Based on your OTHER post, you are trying to ask “How do I set it up so all new sites on my network have a set of default links that I define?”

https://www.ads-software.com/extend/plugins/wpmu-new-blog-defaults/ is one way.

Or you can use something like Blog Copier to make a default set up and copy every time.