Summary of usage of command line query examples

First, display the garbled characters, mainly Chinese garbled characters: Step 1: Find the directory where mysql is installed and find the my.ini file; Step 2: Use Notepad to open the my.ini file and set the default encoding to utf-8: Step 3: Enter in the mysql database cmd: show variables like'%char%'; Step 4: Change the encoding method of the original database: Step 5: Changed encoding method: Step 6: Re-query: Several character sets involved in MySQL character-set-server/default-character-set: Server character set, used by default. character-set-database: Database character set. character-set-table: database table character set. The priorities increase sequentially. Therefore, under normal circumstances, you only need to set character-set-server, and do not specify the character set when creating databases and tables. In this way, character-set

1. [MySQL 04] Command line query garbled code problem

Introduction: First, display the garbled code, mainly Chinese garbled code ：

2. Extract the display data of MySQL command line into text method [Graphic and text]

Introduction: The following is for Windows, not Linux. When using the MySQL command line to query data, the screenshot is often used to send a post as shown below:

3. Solution to the problem of Chinese garbled characters in MySQL command line query

Introduction: When using the Mysql command line to query, Chinese garbled characters often appear. Solution: Enter: show variables like 'character_set_%'; on the MySQL command line to view the current configuration. Encoding; Enter on the MySQL command line: set names utf8; is equivalent to set character_set_client=utf8; set character

4. ThinkPhp+MySQL emoticon problem, iOS, Android emoticons

Introduction: The requirement is to support the access of mobile emoticons in the database; First of all, MySQL storage is supported. You can copy emoticons using the MySQL client on the PC, or use SQL. It can be written to the database and the data is displayed normally; and the result page of the command line query using the terminal to log in to the server's MySQL is normal; but through...

[Related Q&A recommendations]:

node.js - Why are the results of nodejs connection to mysql query inconsistent with the command line query?

java - mysql Why can't I use the command line to query the version after modifying my.ini?

ThinkPhp+MySQL emoticon problem, iOS and Android emoticons

The above is the detailed content of Summary of usage of command line query examples. For more information, please follow other related articles on the PHP Chinese website!