魔幻精灵

文章 分类 评论
243 7 8

站点介绍

魔幻精灵网

MYSQL批量 修改字符集 utf8mb4 等 mysql> show tables;批量列出数据库表

魔幻精灵 2019-07-17 1824 0条评论 网站知识

首页 / 正文

先用下边语句批量打出数据库里面的所有表


mysql> show tables;


然后利用修改单个表的字符集的命令:alter table 表名 convert to character set utf8mb4 collate utf8mb4_bin;


进行批量套入执行命令

评论(0)

最新评论

  • stussy crop top

    Hey! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no backup. Do you have any solutions to prevent hackers?

  • seo packages london

    %%

  • Husky-reps yupoo password

    Heya i'm for the first time here. I came across this board and I to find It truly useful & it helped me out much. I am hoping to present something back and aid others such as you helped me.

  • Umkao yupoo password

    Hi there are using Wordpress for your site platform? I'm new to the blog world but I'm trying to get started and set up my own. Do you require any coding expertise to make your own blog? Any help would be really appreciated!

  • Diagmond Store Around World

    Hello, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam responses? If so how do you prevent it, any plugin or anything you can advise? I get so much lately it's driving me insane so any support is very much appreciated.

  • Blessed Store Official

    Everyone loves what you guys are usually up too. This sort of clever work and coverage! Keep up the wonderful works guys I've incorporated you guys to my own blogroll.

  • Bins Store

    I could not refrain from commenting. Perfectly written!

  • Typecho

    欢迎加入 Typecho 大家族

日历

2022年08月

 123456
78910111213
14151617181920
21222324252627
28293031   

标签云

文章目录

推荐关键字:

配色方案