standard output - Suay.Site

How to display results in MySQL and MariaDB without a table and without extraneous characters

Posted by Alex On September 23, 2024

Contents How to output data without a table when saving results to a file How to display results without a table on the screen How to display results in mariadb and mysql clients without a table How to configure the output of results without a table by default When working with MySQL and MariaDB in the command line, the results...

How to clear the terminal window in PowerShell. Analog of clear

Posted by Alex On September 3, 2024

When debugging cmdlets and options, so that previously output data does not fall into the field of view and does not mix with the results of the last command, or if for other reasons you want to delete everything that the command line utilities output, then you can use this instruction. We will consider such questions as: 1) How to...

How to remove the header from the output table in PowerShell and leave only the data

Posted by Alex On September 3, 2024

Most likely, you do not need to remove the table header Before I tell you how to remove the header (column names) from the data output by a cmdlet and leave only the data itself, it is important to note that PowerShell is quite different from other programming languages in terms of output data. While Python, Bash, PHP, and many...

How to run a program from Python: how to run a system command or another Python script (complete guide)

Posted by Alex On September 2, 2024

Table of Contents 1. The subprocess module in Python 2. How to pass arguments to a program in subprocess.run 3. Getting the result of command execution (standard output, stdout)) 4. Working with the standard error (stderr) 5. Automatic command splitting into a list of arguments 6. How to run a command with wildcards 7. Calling a command without breaking it...

Error “The ‘<‘ operator is reserved for future use.” (SOLVED)

Posted by Alex On October 25, 2022

Analog “<” for PowerShell On Linux, you can use the following construct: COMMAND1 < FILE1 In this case, COMMAND1 will be executed with FILE1 as the input source instead of the keyboard, which is the normal standard input source. The “<” operator corresponds to the use of “|” to be passed to standard input. For example, the following commands are...

mysqldump in PowerShell corrupts non-Latin characters when exporting database (SOLVED)

Posted by Alex On October 23, 2022

mysqldump is a MySQL utility for creating database and table backups. Unlike phpMyAdmin, which, although it offers a web interface, is a slower tool due to the limitations of intermediates such as PHP and Apache, mysqldump is a much more efficient tool without limitations for backing up very large data. But on Windows, mysqldump has some nuances. Due to the...

Output encoding issues in PowerShell and third-party utilities running in PowerShell (SOLVED)

Posted by Alex On October 23, 2022

What encoding is used in PowerShell by default. How to change the default output encoding to UTF-8 in PowerShell If you run the following command in PowerShell 5: "Testing" > test.file And check the encoding in the newly created test.file, it turns out that it is UTF-16LE. If you run the following command in PowerShell 7: "Testing" > test.file And...