Mysql按VARCHAR字段插入订单号 [英] Mysql Insert Order Number By VARCHAR Field
本文介绍了Mysql按VARCHAR字段插入订单号的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个关于按特定订单类型插入行订单号的问题.
I have a question about inserting row order number by spesific order type.
Products 表有 OrderNumber 字段.我想通过其名称以编程方式将新行添加到适当的 OrderNumber.如果引用列是整数,它必须很容易
Products table has OrderNumber field. I want to programaticly add new line to appropriate OrderNumber by its name. If the reference column would be integer it has to be easy like that
update products set OrderNumber=OrderNumber+1 where Price>555
varchar 字段是否有类似的方法
Is there similar way for varchar field like
update products set OrderNumber=OrderNumber+1 where Name>'bla%'
谢谢
推荐答案
可以使用 STRCMP('text', 'text2')
You can use STRCMP('text', 'text2')
update products
set OrderNumber=OrderNumber+1
where STRCMP(Name, 'bla') = 1;
我误解了你的意思.你能试试这样的吗?
I missunderstood your point. Can you try something like this?
SET @rownum:=0;
update
set OrderNumber=@rownum:=@rownum + 1
from products
order by Name;
这篇关于Mysql按VARCHAR字段插入订单号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文