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
Problem Description There is a type of query call...
Table of contents Preface 1. Iceraven Browser (Fi...
Introduction Based on docker container and docker...
[Abstract] This article quickly builds a complete...
Preface: Docker port mapping is often done by map...
Table of contents 1. Prepare materials 2. Downloa...
Why is NULL so often used? (1) Java's null Nu...
1. InnoDB locking mechanism The InnoDB storage en...
1. First, an error message is reported when assoc...
Today I will use the server nginx, and I also nee...
Table of contents Preface Enumerable properties I...
The div+css layout to achieve 2-end alignment is ...
When the amount of data in MySQL is large, limit ...
Table of contents 1. Uninstall the original drive...
1. Install Docker. Reference URL: Docker Getting ...