如何用5000行JS撸一个关系型数据库
SELECT s.id，s.name，ifnull AS gender_id， /*处理空值*/ AS gender_name，s.dept_id，d.dept_name FROM t_staff s LEFT JOIN t_gender g ON g.id=s.gender LEFT JOIN t_dept d ON d.dept_id=s.dept_id WHERE d.dept_name IS NOT NULL LIMIT 3。
SELECT s.id，s.name，ifnull AS gender_id， /*处理空值*/ AS gender_name，s.dept_id，d.dept_name FROM t_staff s LEFT JOIN t_gender g ON g.id=s.gender LEFT JOIN t_dept d ON d.dept_id=s.dept_id WHERE d.dept_name IS NOT NULL LIMIT 3。