utf-8的mysql表筆記

標籤：

mysql預設連結數量15 連接埠3306 [email protected]
create database mybase character set utf-8;
use mybase;
drop table students;
create table students(
name char(8),
sex char(4),
age tinyint unsigned not null,
tel char(13) null default "-"
)default charset=utf8;
set names gbk;
/*
方法一:在插入中文之前 先輸命令set names gbk 告訴用戶端你在這裡敲的命令是GBK編碼的 用戶端會把你接下來敲的命令轉成
UTF-8 你資料庫內部的編碼還是UTF-8
*/
insert into students(name, sex, age, tel) value("張彭洋明","man", 25, "15388128692");

 

select * from students;
insert into students(name, sex, age) value("張彭","男", 23);
update students set sex="男" where name="張彭洋明";
delete from students where name="yangming" and tel="15388128692";

utf-8的mysql表筆記