MySQL - Suay.Site

How to increase the size of columns in phpMyAdmin

Posted by Alex On February 15, 2024

Table of contents 1. Why phpMyAdmin does not show the full contents of a cell (column) 2. How to view the full contents of a cell in phpMyAdmin 3. Why does changing column widths not show the entire data? 4.How to increase the number of characters in cells in phpMyAdmin Why phpMyAdmin does not show the full contents of a...

How to search in phpMyAdmin

Posted by Alex On February 14, 2024

Table of contents 1. How does searching through databases and tables work in phpMyAdmin 2. Instructions for using the search function in phpMyAdmin 3. Search the database as a whole. Search multiple tables simultaneously 4. Single table search Conclusion How does searching through databases and tables work in phpMyAdmin Searching MySQL/MariaDB is performed using SQL queries and therefore requires knowledge...

What is the difference between the LIKE operator and the equal sign (=) in MySQL/MariaDB. How to use LIKE in SQL

Posted by Alex On February 13, 2024

Table of contents 1. What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator 2. When to use equal sign (=) in SQL 3. When to use the LIKE operator in SQL 4. Even more differences under the hood Conclusion What to use to search in MySQL/MariaDB: LIKE operator or equals (=) operator The LIKE operator and...

Case sensitive search in phpMyAdmin

Posted by Alex On February 12, 2024

Table of contents 1. Case sensitive search in phpMyAdmin 2. How to create a request with “BINARY” in phpMyAdmin 3. How can I make SQL case sensitive string search in phpMyAdmin 4. Video on how to find a case-sensitive string in phpMyAdmin Case sensitive search in phpMyAdmin Let’s try to find rows in the table that contain the word “test”....

Case sensitive search in MySQL/MariaDB

Posted by Alex On February 12, 2024

Table of contents 1. MySQL/MariaDB search for strings not case sensitive 2. How to make search case sensitive in MySQL/MariaDB 3. Why do MySQL/MariaDB look for strings that are not case sensitive? 4. Why does adding “BINARY” make string searches case sensitive? 5. It is correct to put “BINARY” before the search string or before the column name 6. Optimizing...

ERROR 1114 (HY000) at line 19894: The table ‘en’ is full (SOLVED)

Posted by Alex On September 24, 2023

Why does the “ERROR 1114 (HY000)” occur When adding information to a database, for example, when using an “INSERT” statement, or when importing tables or databases into MySQL (MariaDB), error number 1114 may occur: ERROR 1114 (HY000) at line 19894: The table 'en' is full After the error there is an explanation: the specified table is completely occupied. The problem...

PHP Fatal error: Uncaught mysqli_sql_exception: No database selected (SOLVED)

Posted by Alex On September 6, 2023

Let's look at a small PHP code that tries to connect to a MySQL or MariaDB DBMS and execute a query with a “SELECT” statement: <?php $db_user = "root"; $db_password = ""; $mysqli = new mysqli("localhost", $db_user, $db_password); if ($mysqli->connect_errno) { printf("Somehow we failed: %s\n", $mysqli->connect_error); exit(); } $query = "SELECT * FROM TestTABLE;"; $result = $mysqli->query($query); while ($row =...

“ERROR 1046 (3D000): No database selected” in MySQL and MariaDB (SOLVED)

Posted by Alex On September 3, 2023

How to fix “ERROR 1046 (3D000): No database selected” The error “ERROR 1046 (3D000): No database selected” occurs most often due to haste – of course, before performing actions with tables and the information stored in them, you must specify (that is, select to use) database. This simple mistake is a good reason to tell you about at least 5...

How to change the command line prompt for MySQL (MariaDB)

Posted by Alex On September 2, 2023

The MySQL (MariaDB) client, when connected to a DBMS server, displays the database selected to use and the name of the DBMS (such as MariaDB or MySQL) at the default command prompt. Perhaps you want to add to this information the username, the hostname on which the MySQL (MariaDB) server is running, the port number, the current date and time,...

How to determine the location and name of the MySQL (MariaDB) configuration file. How to find the group name for MySQL and MariaDB configuration files

Posted by Alex On September 2, 2023

MySQL and MariaDB config files Some useful settings that improve productivity or solve problems that have arisen should be saved in configuration files. But you may encounter a situation where some online guide recommends saving the settings to a file located in a certain directory, but in your Linux this file or even the entire directory is missing. The confusion...