mysql5.6下载和安装,直接解压缩运行,你知道myql5.6如何下载和安装吗?并且不需要繁琐的安装过程,直接解压缩就可以运行,下面将详细介绍......
mysql查询时区分大小写
mysql查询时不区分大小写,怎么区分大小写呢,我和大家分享一下方法,我写的经验对你学习mysql有帮助的话,给我投票、点赞或者收藏!
1mysql表的字段怎么设置唯一性
1mysql中怎么创建数据库
1mysql怎么修改锁记录超时等待时间
工具/原料
- mysql5.6
方法/步骤
登录mysql,在test数据库中新建一个表:
CREATETABLE`chengshi`(`id`int(11)NOTNULLAUTO_INCREMENT,`shengfen`varchar(10)NOTNULL,`chengshi`varchar(10)NOTNULL,`shijian`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP,`zhujima`varchar(10)NOTNULLDEFAULT'binary',PRIMARYKEY(`id`),UNIQUEKEY`chengshi`(`chengshi`))ENGINE=InnoDBAUTO_INCREMENT=10DEFAULTCHARSET=utf8
在表中增加一些数据:
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('1','河南','安阳','2019-03-14 09:57:29','ay');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('2','河南','郑州','2019-03-14 10:10:02','zz');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('3','河南','洛阳','2019-03-14 10:10:56','ly');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('4','河南','漯河','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('5','河南','新乡','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('6','河南','濮阳','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('7','河南','焦作','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('8','河南','鹤壁','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('9','河南','开封','2019-03-05 10:14:27','');
在表中查询"安阳“的记录助记码是小写:
SELECT * FROM chengshi WHERE zhujima='ay';
在表中查询"安阳“的记录助记码是大写:
SELECT * FROM chengshi WHERE zhujima='AY';
查询时默认是区分大小写的。
查询区分大小写,没有查询安阳的记录:
SELECT * FROM chengshi WHERE BINARY zhujima='AY';
查询区分大小写,如果换成小写查询安阳的记录成功:
SELECT * FROM chengshi WHERE BINARY zhujima='ay';
以上方法由办公区教程网编辑摘抄自百度经验可供大家参考!
相关文章