There are two primary methods to view the tables in MySQL:
- The MYSQL SHOW TABLES command.
- Querying the Information_schema.tables table.
In this article, we are going to explore them both.
Different Ways to View Tables in MySQL Server
Tag: mysql
MySQL UPDATE Statement with Useful 5 Tips for T-SQL Developers
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn.
We are continuing our journey to MySQL from the SQL Server point of view. It started with MySQL CREATE TABLE, followed by MySQL INSERT, and the most recent piece was about MySQL DELETE. Today, UPDATE is our focal point.
MySQL and MariaDB Backup and Restore Strategy with Best Practices
A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential to ensure data recovery at any point in time of the application workflow life cycle. Both MySQL and MariaDB offer solutions for these cases. This article will explore the existing options and procedures of how to backup MySQL Database and MariaDB as well as recovery strategies.
Top 5 MySQL DELETE Syntax for T-SQL Developers
Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to MySQL DELETE. Since you are familiar with T-SQL DELETE, the goal is to make you more productive using the MySQL syntax.
There are minor differences but there’s nothing that you can’t handle. Let’s get started.
How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways
This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a virtual machine using Oracle VM virtual box and set up Ubuntu 18.04 on the virtual box. I’d recommend you referring to the article Creating a Virtual Machine with Oracle VM Virtual Box for a better understanding of the installing process and creating a virtual machine on Oracle VM virtual box. Also, you may turn to the article How to Install Ubuntu 18.04 for more information about installing Ubuntu 18.04 on the virtual machine.
Backup and Restore MySQL Database Using mysqldump
The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool for generating backups in several formats or restoring MySQL databases.
How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench
This article describes the step-by-step deployment process of the Azure Database for MySQL Server.
Open the Azure portal and log in using the appropriate credentials. Note: For demonstration purposes, I got a pay-as-you-go subscription to Microsoft Azure. For more information about the Azure MySQL pricing model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, and tenants for Microsoft’s cloud offerings.
MySQL Insert Command vs T-SQL Query Syntax with Examples
Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp, what’s the faster way to learn MySQL? Often you want to compare syntaxes. Last time, you learned about creating a table in MySQL. Our today’s post will take you a step further. We’ll insert records with MySQL INSERT.
ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)
This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover the following issues:
- Installing the ODBC driver on Windows 10.
- Configuring the ODBC data source with ODBC driver for MySQL.
- Creating a basic list report with PowerBI that uses the ODBC driver for the data population from the MySQL database.
MySQL Create View, Replace View and Drop View Statements with Examples
An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a database. When we run the SELECT query to populate the data, it executes a query that creates the view (View definition).
