订单表:order包含字段: id,orderNo,amount中文意思:序列,订单号,金额查询语句:select * from order where orderNo = '订单编号'因为编号是字符串类型,所以需要加单引号哦
Select * from 订单 where 订单号='XXXXX'