select username, password, phone, mail, from_unixtime(last_datetime,'%Y-%m-%d %H:%i:%s') as last_datetime, from_unixtime(reg_datetime,'%Y-%m-%d %H:%i:%s') as reg_datetime from user join user_info using(`user_id`) join user_data using(`user_id`)where teacher_id=1 |
语句解释
|
1
|
from_unixtime(unix字段,'%Y-%m-%d %H:%i:%s') as 字段别名(一般为原字段名称) |
|
1
|
from 主表 join 关联表1 using(关联字段) join 关联表2 using(关联字段) |
