Author: Alex

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

Menu buttons (toolbar) and status bar are missing in SMPlayer (SOLVED)

SMPlayer is a popular cross-platform video player. SMPlayer has many useful functions (crop video to fit the screen, fine-tune the appearance and location of subtitles, select the number of audio output channels) and many other settings, including those related to performance optimization and hardware acceleration of video decoding. Separately, I would like to note such a function as saving playback...

How to install and configure best video player on Linux (SMPlayer)

What is SMPlayer. Why SMPlayer is better than other video players SMPlayer is one of the most convenient video players I've ever used. In terms of its ability to play various formats, SMPlayer is no worse than another great cross-platform video player – VLC. But when it comes to ease of use, SMPlayer is ahead of VLC. SMPlayer is a...

How to check if Wayland or X11 is used?

Table of contents 1. What is Wayland and X11 2. How to find out if you are using Wayland or X11 on the command line 2.1 Using the session ID 2.2 Checking the $XDG_SESSION_TYPE variable 2.3 Checking the WAYLAND_DISPLAY and DISPLAY variables 2.4 Finding Display Server environment variables 3. How to detect whether X11 or Wayland is being used in a GUI 3.1 How to see if GNOME is...
Loading...
X