Tagged: mysql

0

Mysql: Export select rows to CSV on server

Use the following command to export the query rows to a file on the server in the CSV format:

...

0

MariaDB – allow user to connect from anyhost

Use the following command in your server to allow user to connect from anyhost:

0

Apache 2, PHP 5 and MariaDB on Raspbian

A great tutorial to do so can be found here: https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-lamp-on-debian-jessie/ Please remember to prefix the commands with sudo or...

0

Updating the URL of a WordPress website with SQL commands

Use the following commands to change the URL of a WordPress website directly inside the mysql database:

 

0

MySQL JOINs with examples

This is an interesting tutorial on MySQL Joins: http://www.sitepoint.com/understanding-sql-joins-mysql-database/

0

WordPress – db_term_taxonomy reset count

Reset the term count: