The decompressed version of MYSQL is installed 1: After decompression, copy a my.ini file and add the byte encoding configuration: [client] default-character-set=gbk [mysqld] character-set-server=utf8 Specify the database configuration file bin\mysqld --defaults-file=my.ini --initialize-insecure Specify the configuration file my.ini (If you ignore this step, the configuration of my.ini will not take effect, which is a bit of a pitfall) Install the database: bin/mysqld --install Start the database service: net start mysql (under Windows environment) 2: Specify the database encoding when creating a database: 3 Specify UTF8 encoding when creating a table: CREATE TABLE `Demo_Table` ( `name` varchar(255) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `modified_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `size` bigint(20) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `label` varchar(255) DEFAULT NULL, PRIMARY KEY (`name`,`created_by`) )ENGINE=InnoDB DEFAULT CHARSET=utf8; The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: How to completely uninstall node and npm on mac
>>: JS implements multiple tab switching carousel
Table of contents 01 Common Faults 1 02 Common Fa...
Table of contents Install CentOS7 Configuring Sta...
View system help help contents mysql> help con...
30 free high-quality English ribbon fonts for down...
To deploy multiple sites on a server, you need to...
Table of contents 1. How to find duplicate rows 2...
Hyperlink Hyperlinks are the most frequently used ...
The component lifecycle is usually where our busi...
MQTT Protocol MQTT (Message Queuing Telemetry Tra...
Several problems were discovered during the use o...
Preface nginx uses a multi-process model. When a ...
Table of contents Network Information Modify the ...
1. Download the MySQL 5.7 installation package fr...
LocalStorage stores Boolean values Today, when I ...
Two days ago, I took advantage of the Double 11 s...