Tag Archives: SQL

WordPress: How to Disable Plugin


One day, my WordPress shows Sorry, your request cannot be accepted, and I can’t log in to the site. I summarized how to do in such cases.

If you got the message as I got, I recommend you to try the following. In my case, IP GEO Block plugin wqs the reason.

Continue reading WordPress: How to Disable Plugin

LibreOffice: Show Database Data on Spread Sheet


I will introduce the way to show database data on spread sheet of LibreOffice Calc, using LibreOffice Base. The data you retrieve from the database onto the spread sheet can be used for any table and pivot tables. I wrote the article “Excel: Retrieve and Show Database Data” before, which shows the way to get the data onto Excel through ODBC, but LibreOffice enables us to do the same thing for free.

Continue reading LibreOffice: Show Database Data on Spread Sheet

PostgreSQL: How to Export SQL Result to File


I will introduce you several way to output sql result into a file with using psql.

Continue reading PostgreSQL: How to Export SQL Result to File