mysql中间件kingshard
2024-08-30 19:46:10
这样写是OK的:
select * from bind_history limit 10;
select id, passport_id, person_id, create_time, cast(is_bind AS char(1)) from bind_history_0000;
select id, passport_id, person_id, create_time, cast(is_bind AS char) from bind_history;
select id, passport_id, person_id, create_time, convert(is_bind,char(1)) from account.passport_bind_history limit 10;
select id, passport_id, person_id, create_time, convert(is_bind,char) from account.passport_bind_history limit 10;
这样写不行:
select id, passport_id, person_id, create_time, cast(is_bind AS char(1)) from bind_history;
不建议使用
最新文章
- IDEA默认常用快捷键
- 江湖恩仇录之PHP程序CPU高占用优化经历分享
- 温故知新---重读C#InDepth(二)
- redis运用连接池报错解决
- hdu---(1421)搬寝室(dp)
- Js判断键盘按键
- java substring和substr
- hdu1022 Train Problem I
- Asp.Net多线程用法1
- Java_Utils框架
- weblogic下 微信公众平台获取token报错
- ISO14443 ISO15693 ISO18000
- ubuntu 12.04安装经典的Gnome桌面
- Ubuntu 安装Composer
- 2016 ACM/ICPC Asia Regional Dalian Online Football Games
- Java多线程其他
- 由于服务主机:DCOM服务进程占用过多CPU,导致系统卡死
- BZOJ 193题纪念
- SQL 2017 远程连接被拒绝
- Intellij IDEA 导入Eclipse的Web项目
热门文章
- Java覆盖
- js splice函数 数组增加,替换,删除
- eclipse导入git项目出现There are no resources that can be added or removed from the server错误
- linux 执行脚本1.补充命令 2.后台执行
- 20165326 java实验五
- leetcode题解 5. Longest Palindromic Substring
- 使用POI读取xlsx文件,包含对excel中自定义时间格式的处理
- 3.2 unittest执行顺序
- 国内优秀MVC开源框架jfinal简介
- : LDAP &; Implementation