解决sql导入乱码

haoduoylg · Jan 17, 2019 · b725b4a · b725b4a
1 parent da96fd9
commit b725b4a
Showing 1 changed file with 2 additions and 1 deletion.
diff --git a/library.sql b/library.sql
@@ -1,5 +1,6 @@
 CREATE DATABASE library;
 USE library;
+set names utf8;
 START TRANSACTION;
 CREATE TABLE `admin` ( `admin_id` BIGINT NOT NULL PRIMARY KEY, `password` VARCHAR ( 15 ) NOT NULL, `username` VARCHAR ( 15 ) DEFAULT NULL ) ENGINE = INNODB DEFAULT CHARSET = utf8;
 INSERT INTO `admin`
@@ -106,4 +107,4 @@ VALUES
 	( 10003, '张明华', '123456' ),
 	( 10004, '李一琛', '123456' ),
 	( 10005, '李二飞', '123456' );
-COMMIT;
+COMMIT;