Category: Software, hardware and other IT

How to increase the size of columns in phpMyAdmin

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

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

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

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

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...

Alternatives for Google Domains

For the second year now, I have been using Google Domains to register domains – I really like their service: low prices, free Domain Privacy, convenient management, no restrictions, automatic verification of sites in Google Search Console. Overall, I could definitely recommend this domain registrar if it still worked... Note: Domain Privacy is the hiding of your personal data (your...

Keyboard shortcuts for Google Maps

Keyboard shortcuts in Google Maps This article is devoted to the hotkeys that work in Google Maps for computers in web browsers. The article does not address keyboard shortcuts in Google Earth, nor does it address the Google Maps mobile application. Why Google Maps keyboard shortcuts don't work While preparing this article, I came across the fact that many Keyboard...

OpenStreetMap – Great detailed maps and GPS navigation app

Table of contents 1. What is OpenStreetMap 2. OpenStreetMap application. How to install OpenStreetMap on Android 3. How to use OpenStreetMap 4. How to view your location in OpenStreetMap. Compass in OpenStreetMap 5. How to find a place in OpenStreetMap 6. How to build a route in OpenStreetMap. How to use OpenStreetMap as a GPS navigator 7. List of OpenStreetMap...

Error “ModuleNotFoundError: No module named ‘manimpango’” (SOLVED)

When starting one of the programs the following error occurred: Traceback (most recent call last): File "/usr/bin/emote", line 33, in <module> sys.exit(load_entry_point('Emote==0.0.0', 'gui_scripts', 'emote')()) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/bin/emote", line 25, in importlib_load_entry_point return next(matches).load() ^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.11/importlib/metadata/__init__.py", line 202, in load module = import_module(match.group('module')) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.11/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1206,...

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

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...
Loading...
X