mysql database – POFTUT

How To List MySQL Tables with “show tables” SQL Query?

How To List MySQL Tables with "show tables" SQL Query?

MySQL is a popular relational data that stores information in tables. While using tables we generally need to check and list existing tables. We can use different ways to list tables. In this tutorial, we will learn how to use show tables and Select table_name in order to list and print table names. Connect MySQL Interactive Shell … Read more

How To Create a Database and Table In MySQL and MariaDB?

How To Create Database and Table In MySQL and MariaDB?

MySQL database is a very popular database server used by a lot of small and big companies. In this tutorial we will look at the basics of MySQL server like creating databases and tables, populating data into tables. MySQL installation can be done with the following tutorial for Linux operating systems. How to Install Mariadb/Mysql … Read more

How To List MySQL Database Users?

How To List MySQL Database Users?

MySQL database server has users to connect and use databases and tables. Users provide security for database operations. MySQL server comes with default users or in the operations, a lot of users are created. In this post, we will look at how to list these users. Connect To MySQL Database We will connect to the … Read more