Blog

12/08/2019

Running SQL Queries on a Database with phpMyAdmin



 

  1. This tutorial assumes you’ve already logged in to phpMyAdmin. Now let’s learn how to run SQL queries on a database.
  2. Click the database table you wish to run a SQL query on.
  3. Click the SQL button here.
  4. Then type your SQL command. Click Go when finished.
  5. In this case, we’re going to delete the address field from the details table using the command:ALTER TABLE details DROP COLUMN address;
  6. That’s it! The SQL command is executed when you click Go. Let’s go take a look.
  7. The address field is no longer in our details table.
  8. You can also click the SQL button directly from the table view. Doing so presents a SQL query window that is partially filled in.

 

14/08/2019

How to KVM, QEMU start or stop virtual machine from command line (CLI)

KVM or Kernel Based Virtual Machine is a popular virtualization technology. It allows you to run virtual guest machines over a host machine. To start...
14/08/2019

How to Docker backup Saving and restoring your volumes

Running a Docker volume backup First, we spin up a temporary container, and we mount the backup folder and the target Docker volume to this container....
12/08/2019

How to Start and Enable Firewalld on CentOS 7

In this article, we discuss how to start and enable firewalld. It is highly recommended that you have a firewall protecting your server.Pre-Flight CheckThese...