create database Hero
default character set utf8
default collate utf8_general_ci;
default character set utf8
default collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)
utf8_general_ci;表示编码格式,此编码格式对字母大小写不敏感,不严格区分大小写,与这个对应的有个
utf8_bin就是严格区分大小写的编码格式;
题外话:
truncate table tableName;这句话是表示清空表,并且自增主键又按照1开始技术