How To Run SQL Query For WordPress Blog

Blogs that we run on wordpress use My Sql database , and it is some times required to run SQL query in My Sql, particularly when you are downloading any plugin that allows registration of some sort, by the users of your site. A good example of this can be enabling Guest Authors for your blog, and if you are downloading any plugin for this, then definitely it will be required to run some sort of query in the database .

Here is how to do it?

  1. Login to your PHP My admin, you can use your C-Panel for this.
  2. Select your required database(the one in which you want to run query).
  3. Click on SQL button.
  4. Type the query in the text box. And click on “GO”
  5. You are done.

I will try to share more on what more can be done using PHP My Admin panel .

Do share your opinions with us :)

Comments

Similar articles

How to secure WordPress Blogs and Sites

Security is like a part of our life which includes blogging also. In real life, we use keys to secure our house, car and many others from unwanted visitors or unwanted person.

How To Shift WordPress Blog To Another Server

Often when we start blogging as a newbie, we go for cheapest web hosting without thinking too much over it. But after a period of time we realize that having a good web hosting service is an essential part of any blog or site. But often we do not prefer changing web hosting service as it involves a

How To Show Author Info In WordPress

Quite often it is required to show little information about the author , beneath the post written by him/her. One of the many advantages of showing author info is that it helps in building a network, as the readers of the blog tend to connect more with the author in such a way. So heres how its done

How To Use No Follow Attribute Effectively In Your Blog

After introduction of “No-Follow” attribute by Google, webmasters have been figuring out ways to use it effectively and more importantly to use it in a manner so as to retain as much link juice as possible. There are millions of online texts available on how to use “No Follow” attribute effectively

How To Use Update Services In WordPress

WordPress provides a facility to ping your updates to other blogs/sites i.e it is a way to let other people know that you have updated your blog’s content. Letting other sites/blog know about your updates help in getting better SERP for your blogpost, so having a well managed Ping List is a must for

Increase Traffic - Do You Really Need It

You will find millions of articles on how to increase traffic to your blog. There are thousands of sites claiming to bring traffic to your blog . A lot has been said, done, implemented and thought of to bring traffic to your blog. But the question is do you really need it, you might say “Are you a j

*Disclaimer: Any or all product name(s) and company logo(s) used on the website are registered and trademarked by their respective owners.