convert mdb to mysql

Restarting the service takes effectSystemctl Stop MARIADBSystemctl Start mariadb4 changing character encoding to UTF8Sed-n S/LATIN1/UTF8/GP Latin.sqlSed-i s/latin1/utf8/g Latin.sql5 Creating a new library import dataMySQL--default-character-set=utf8Show variables like ' char% ';650) this.width=650; "src=" Https://s5.51cto.com/oss/201711/22/6769216433c8f11a993095f200e3a552.png "title=" QQ picture 20171122112916.png "alt=" 6769216433c8f11a993095f200e3a552.png "/>Create Database UTF8;Show create D

Tags: select databaseUpdate Dept B, (select Group_concat (T.deptid), Group_concat (d.deptname separator '/') as Dname, T.id, t.deptname from (sel ECT Substring_index (Substring_index (A.deptid, ', ', b.help_topic_id+1), ', ', -1) as DeptID, a.ID, A.deptname from (select D.father as DeptID, D.id, D.deptname from Dept D) a join Mysql.help_topic B on b.help_topic_id GROUP by ID, deptname) C set b.location=c.dname where b.id = C.idEffectCopyright NOTICE: This article for Bo Master original article,