解决方案 »
- 请教个连接TOMCAT的问题
- 相同的表结构,如何统计多个表中 相同字段不同数值的个数?
- MySQL中有乱码
- 我的mysql经常启动不起来,无奈啊
- sql能否做到下面例子的link
- 网站访问量巨大的情况下,数据库如何多分几个数据库来存储啊?
- Mysql有没有办法在插入时获得当前自增Id的函数,我有两个列用到该id?
- [急求]关于in排序 的问题!
- 我已经安装了mysql的服务,为什么总是无法识别mysql命令呀
- MYSQL数据传送时为何会出现这样的错误提示?
- 如何在bat中实现先后两条mysql命令,运行mysql后导入数据库?
- 在linux下用安装的mysql 总是启动不了。日志如下。。。这是杂回呈啊
`S_In`.`inID` AS `inID`,
`S_In`.`inStatus` AS `状态`,
`S_In`.`inDataSource` AS `数据来源`,
`S_In`.`inType` AS `类型`,
`S_In`.`inNo` AS `流水编号`,...
及 show index from 所有的表以供分析。
`S_In`.`inID` AS `inID`,
`S_In`.`inStatus` AS `状态`,
`S_In`.`inDataSource` AS `数据来源`,
`S_In`.`inType` AS `类型`,
`S_In`.`inNo` AS `流水编号`,
`S_In`.`CreateDate` AS `过磅时间`,
`S_Supplier`.`supplierName` AS `供应商`,
`Z_FoodType`.`foodTypeName` AS `粮食类型`,
`Z_Warehouse`.`warehouseName` AS `库房`,
`S_In`.`inPlateNumber` AS `车牌号`,
`S_In`.`inFinalPrice` AS `最终单价`,
`S_In`.`inGW` AS `毛重`,
`S_In`.`inTW` AS `皮重`,
`S_In`.`inNW` AS `净重`,
`S_In`.`inBuckleRate` AS `总扣杂率`,
`S_In`.`inBuckleWeight` AS `总扣杂`,
`S_In`.`inNW_Real` AS `实重`,
`S_In`.`inMoney_SP` AS `商品金额`,
`e1`.`employeeName` AS `质检人员`,
`e2`.`employeeName` AS `司磅人员`,
`e3`.`employeeName` AS `库管人员`,
`S_In`.`inRe` AS `备注`,
`S_In`.`fkInPaysID` AS `fkInPaysID`
FROM
((((((S_In
LEFT JOIN S_Supplier ON ((S_In.fkSupplierID = S_Supplier.supplierID)))
LEFT JOIN Z_FoodType ON ((S_In.fkFoodTypeID = Z_FoodType.foodTypeID)))
LEFT JOIN Z_Warehouse ON ((S_In.fkWarehouseID = Z_Warehouse.warehouseID)))
LEFT JOIN Z_Employee AS e1 ON ((S_In.fkEmployeeID_ZJ = e1.employeeID)))
LEFT JOIN Z_Employee AS e2 ON ((S_In.fkEmployeeID_SB = e2.employeeID)))
LEFT JOIN Z_Employee AS e3 ON ((S_In.fkEmployeeID_KG = e3.employeeID)))
where `S_In`.`CreateDate` BETWEEN '13-08-28 00:00:00' AND '13-08-28 23:59:59'
order by `S_In`.`CreateDate` desc
LIMIT 0,100