摘要:
insert into mysql.user(Host,User,Password) values("%","admin",password("admin")); grant all privileges on *.* to 'admin' identified by 'admin'; grant 阅读全文
摘要:
两个对象: 学生表:Student 课程表:Course 两者的关系是多对多,当查询Student对象,并以Course对象作为条件时的sql语句写法如下: select pa from Student pa inner join pa.Courses as course where course. 阅读全文
摘要:
$db_prefix = C('DB_PREFIX');$Model = new Model(); $data = $Model->table("{$db_prefix}ordernum as ou")->join("{$db_prefix}orderinfo as oi on ou.ofid=o... 阅读全文