mysql mac 中文乱码_MAC下mysql中文乱码问题

1、基本命令

创建数据库

create database customer_gl;

创建数据库并设置编码格式

create database customer_gl character set utf8;

创建数据表

create table customer (

id varchar(100) primary key auto_increment,

name varchar(100) not null,

email varchar(100) not null,

gender varchar(10) not null,

birthday date,

cellPhone varchar(50) not null,

preferences varchar(100),

type varchar(100),

description varchar(255)

);

创建数据表并设置表编码格式

create table customer (

id varchar(100) primary key auto_increment,

name varchar(100) not null,

email varchar(100) not null,

gender varchar(10) not null,

birthday date,

cellPhone varchar(50) not null,

preferences varchar(100),

type varchar(100),

description varchar(255)

)engine=InnoDB default charset=utf8;<