CREATE DATABASE sss DEFAULT CHARACTER SET=UTF8;
USE ss;
create table classes_number (id bigint not null, class_name varchar(255), starttime varchar(255), endtime varchar(255), greeting varchar(255), primary key (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into classes_number values(1,'早班','09:00','09:20','早上好');
insert into classes_number values(2,'中班','02:00','02:20','中午好');
insert into classes_number values(3,'早班','06:00','06:20','晚上好');
批处理为什么会有乱码
USE ss;
create table classes_number (id bigint not null, class_name varchar(255), starttime varchar(255), endtime varchar(255), greeting varchar(255), primary key (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into classes_number values(1,'早班','09:00','09:20','早上好');
insert into classes_number values(2,'中班','02:00','02:20','中午好');
insert into classes_number values(3,'早班','06:00','06:20','晚上好');
批处理为什么会有乱码
insert into classes_number values(1,'早班','09:00','09:20','早上好');
insert into classes_number values(2,'中班','02:00','02:20','中午好');
insert into classes_number values(3,'早班','06:00','06:20','晚上好');
USE ss;
create table classes_number (id bigint not null, class_name varchar(255), starttime varchar(255), endtime varchar(255), greeting varchar(255), primary key (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8;set names 'gbk';大家的意思是这样吗???/insert into classes_number values(1,'早班','09:00','09:20','早上好');
insert into classes_number values(2,'中班','02:00','02:20','中午好');
insert into classes_number values(3,'早班','06:00','06:20','晚上好');