sql
newbeedaly
这个作者很懒,什么都没留下…
展开
-
mysql元组查询
`select * from user;select * from user where (name,age) in ( (‘123’,12),(‘12’,13) );select * from user where name in (‘123’,‘12’) and age in (12,13);`原创 2020-09-23 19:56:41 · 2152 阅读 · 0 评论 -
mysql blob类型转string的sql处理方式
sql查看select CONVERT (data USING utf8) AS CONTENT from tableName;sql修改update tableName set data=concat(‘123中国史蒂夫sfd’,cast("" as char));原创 2019-02-26 14:20:38 · 6750 阅读 · 0 评论