项目中一条语句:点击(此处)折叠或打开SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称'from role_goodsLEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on goods.id=role_goods.goodsId...【阅读全文】
项目中一条语句:点击(此处)折叠或打开SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称'from role_goodsLEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on goods.id=role_goods.goodsId...【阅读全文】
项目中一条语句:点击(此处)折叠或打开SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称'from role_goodsLEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on goods.id=role_goods.goodsId...【阅读全文】
项目中一条语句:点击(此处)折叠或打开SELECT role_goods.id,role_goods.number,roleId,role.`name` ,goods.`name` as '物品名称'from role_goodsLEFT JOIN role on role.id =role_goods.roleId LEFT JOIN goods on goods.id=role_goods.goodsId...【阅读全文】
MySQL5.1 引入表分区功能,使得MySQL在处理大表的能力上得到增强。使用过表分区功能的朋友应该知道,MySQL5.1中使用表分区的时候,对字段是有要求的,那就是必须是整数型,或者可以将其他类型的字段通过函数转换成整数型才可以。/* with MySQL 5.1 ivan @ MySQL实验室(mysqlab.net/blog/) */CREATE ...【阅读全文】