Shulou(Shulou.com)06/01 Report--

1. Syntax:

ALTER DATABASE database name

CHARACTER SET coding

COLLATE proofreading rules

two。 Syntax parsing:

Database name: demo1

Coding: one of the coding sets, such as utf8.

Proofreading rules: one of a set of proofreading rules, such as utf8_general_ci

3. Example:

# modify coding and proofreading rules

ALTER DATABASE demo1

CHARACTER SET utf8

COLLATE utf8_general_ci

4. Screenshot of the running result:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.