suppo的用法mysql数据库⽐较字符串数值
记录
教师节祝福语6字
问题：⽐较⼤⼩时候出现错误
英语学习计划书原因：按位⽐较
laboratorylect * from device_log where del = '0' and sn_start <= '9999988888777771' and sn_end >= '9999988888777771' ## sn_start=sn_end = '9999988888' lect '9999988888' <= '9999988888777771' ⽐较⼀ -- ⽐较结果1
新加坡硕士留学费用lect '9999988889' >= '9999988888777771' ⽐较⼆ -- ⽐较结果2
韩国语在线翻译lect CHAR_LENGTH('9999988888777771') -- 16海洛因英文
lect lpad('9999988888', CHAR_LENGTH('9999988888777771'), 0) --0000009999988888
突破自我lect * from device_log where del = '0' and lpad(sn_start, CHAR_LENGTH('1999988888777761'), 0) <= '1999988888777761' and lpad(sn_end, CHAR_LENGTH('1999988888777761'), 0) >= '1999988888777761' -- 解决⽅法：前置填充0ad2
jinxed
