mysql5.7 Base Alter database...charset= ... Modify the character encoding of the database to change UTF8 to GBK

Source: Internet
Author: User

Li Wu:
Heng Learn to think together, honouring teachers save Thanksgiving. Leaf See root three return to one, rivers the same oneness.
Meekness Conscience Lord, willing to do without regrets to the most bitter. Reading exercises to keep the body and mind, sincere advice and the line and cherish.

Data,
data, Lingen on the data. You must be cautious about operating the database. Give the most bitter code here, and take a look at it, to have your own judgment.  Meet the choice, or ashamed to ask.
mysql:5.7
Os:windows7 x64

Code and effects

Mysql>ShowCreate Databasenewdb;+----------+----------------------------------------------------------------+| Database | Create Database                                                |+----------+----------------------------------------------------------------+|Newdb| CREATE DATABASE' Newdb '/*!40100 DEFAULT CHARACTER SET UTF8*/ |+----------+----------------------------------------------------------------+1Rowinch Set(0.00sec) MySQL> Alter DatabaseNEWDB CharSet=GBK; Query OK,1Row affected (0.00sec) MySQL>ShowCreate Databasenewdb;+----------+---------------------------------------------------------------+| Database | Create Database                                               |+----------+---------------------------------------------------------------+|Newdb| CREATE DATABASE' Newdb '/*!40100 DEFAULT CHARACTER SET GBK*/ |+----------+---------------------------------------------------------------+1Rowinch Set(0.00sec) MySQL>

MySQL, relational database management system, excellent, worth learning.
Learning resources: Itcast and Itheima video library + Pure Heart.
If you have public resources, can share to me, with your resources to learn also can.
Blog post is to watch the video, into thinking written. It's good that the teacher speaks well. Blog bad, is to give the most bitter not serious.

mysql5.7 Base Alter database...charset= ... Modify the character encoding of the database to change UTF8 to GBK

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.