MariaDB – POFTUT

Category: MariaDB

SQL UPDATE Statement and Query with Examples 0

SQL UPDATE Statement and Query with Examples

SQL databases provide structured data storage capabilities. We can store data in tables with columns and rows. Other useful features for SQL databases are update capabilities. We can update SQL databases data in different ways and constraints. In this tutorial, we will learn how to update database table data with an SQL UPDATE statement and query single record, multiple records or conditional situations with examples. SQL UPDATE Syntax SQL Update...

0

How To Connect MySQL/MariaDB Server From Command Line On Linux and Windows?

MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases command line connection may be required to connect and management MySQL and MariaDB database server. Install MySQL/MariaDB Client For Ubuntu, Debian, Kali, Mint We will start by installing MySQL/MariaDB command line client in the deb based distributions like Ubuntu, Debian, Kali, Mint etc. The package is...

0

How To Create, Use and Delete SQL View?

SQL Programming language and SQL Database engines provide some useful mechanisms in order to make management of the data easier. SQL View is one of them which can be used to create a table from a SQL result set. What Is SQL View? SQL View is a virtual table which does not exist in a database physically. SQL View table is created from an SQL statement which is generally a...

0

SQL “Select Into” Statement Usage Tutorial

SQL provides different statements in order to select into existing table, variable, temp table in various database servers like Oracle, MySQL, PostgreSQL etc. In this tutorial we will examine how to use Select Into SQL statement for different cases. Syntax Select Into statement syntax is the same as with Select syntax. We just need to a INTO between SELECT and FROM. We can also use WHERE statement in order to filter rows.

...

0

How To Create New User and Set, Grant Permissions To User In MySQL and MariaDB?

MySQL provides ability to create and users from its shell. Security is important part of the database servers. In this tutorial we will examine how to create users and manage privileges in MySQL database server. We will specifically learn restrict user access to a database, database server, grant different type of privileges, print these privileges. Login To MySQL Shell In order to create user and manage privileges of this user...

1

How To Check and Determine MySQL Database Server Version?

MySQL or MariaDB is very popular opensource databases servers. While using these database servers we may need to know the version of the client or server. We can use features according to these version numbers. In this tutorial we will look how to list MySQL and MariaDB database server versions. mysql –version Command mysql is a client command used to connect and manage database server. We can use –version option in order...

0

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

MySQL stores given relation data 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 We need to connect or run command in MySQL to list table names. We will connect to the interactive...

0

What Is MySQL Default Port Number?

MySQL is very popular database in the opensource community. While developing applications or connecting MySQL database we need to specify the MySQL port implicitly or explicitly. In this tutorial we will learn MySQL default port number and alternative port numbers. TCP 3306 The default port for the MySQL service is TCP 3306. This port can be also used for MariaDB database server. List with netstat Command We can use netstat...

0

How To Connect MySQL Database From Python Application and Execute Sql Query with Examples

MySQL is very popular and open source database server. Python is old but lately discovered language. In this tutorial we will look how to use this popular techs in our applications in order to run sql queries. Install Python MySQL Connector In order to connect MySQL database from Python application we need some libraries. There are different libraries those supports running sql queries on MySQL but we will stick with...

Enjoy this blog? Please spread the word :)