MariaDB – Connection One way to establish a connection with MariaDB consists of using the mysql binary at the command prompt. MYSQL Binary Review an example given below. [root@host]# mysql -u root -p Enter password:****** The code given above connects to MariaDB and provides a command prompt for executing SQL commands. After entering the code, […]
Category Archives: mariadb
MariaDB – PHP Syntax MariaDB partners well with a wide variety of programming languages and frameworks such as PHP, C#, JavaScript, Ruby on Rails, Django, and more. PHP remains the most popular of all available languages due to its simplicity and historical footprint. This guide will focus on PHP partnered with MariaDB. PHP provides a […]
MariaDB – Data Types Good field definitions are essential for the optimization of your database. The ideal approach requires that you exclusively use a field of the type and size needed. For example, if you will only use a field, five-characters wide, do not define a field, 20-characters wide. Field (or column) types are also […]