Patrick on Nostr: #[0] 假设有一个部门表 (mst_dept) (表结构为 ...
dave (npub1tsg…htk4) 假设有一个部门表 (mst_dept) (表结构为 id,code,name,),员工表(mst_staff) (id,code,name,depid ),用mysql统计每个部门有多少员工,格式如下
deptName staffCount
开发部 30
前端部 1
Published at
2023-02-08 08:35:04Event JSON
{
"id": "ba5c57f43b072dc29b00d39da5d8e7e6f27942abc2db591d0cbd505896da98c9",
"pubkey": "c8ae3acd9c976dee5afa104411cae8d6dfffafa592a328fe7f82578a70812302",
"created_at": 1675845304,
"kind": 1,
"tags": [
[
"p",
"5c10ed0678805156d39ef1ef6d46110fe1e7e590ae04986ccf48ba1299cb53e2"
]
],
"content": "#[0] \n假设有一个部门表 (mst_dept) (表结构为 id,code,name,),员工表(mst_staff) (id,code,name,depid ),用mysql统计每个部门有多少员工,格式如下\ndeptName staffCount\n开发部 30\n前端部 1",
"sig": "688975236c80d362d984dda022b460ce041b7caf34a73fac30ec7156f6eb594e7c63e1942f645bae2248b1c8aa8f3c132e881fa789c5f1f03ae5f5b7a2734cf1"
}