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:31:38Event JSON
{
"id": "ca135fcc0cbd1dd97c033a4873674f994fc24ce23f2d355cdf69c1302292117f",
"pubkey": "c8ae3acd9c976dee5afa104411cae8d6dfffafa592a328fe7f82578a70812302",
"created_at": 1675845098,
"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": "1bad1ede61f82438a796cbe745476d42c74258eb3d521a0102905f67ac40d11a06ee197725e43a4f0d3488b74eab76024ccbbc58106381b0d8ac4a113037d19e"
}