LING122333的博客

database config 'other_db' => [ // 数据库类型 'type' => 'mysql', // 服务器地址 'hostname' => '127.0.0.1', // 数据库名 'database' => 'db1', // 用户名 'username'

a. $map[] = [‘a.create_time’, ‘between’, [‘2020-10-01’, ‘2020-10-02’]];b. $map[] = [‘a.create_time’, ‘between time’, [‘2020-10-01’, ‘2020-10-02’]];A. Db::name(‘student_answer’)->alias(‘a’)B. Db::name(‘student_answer a’)a + A : okb + A : oka +

->orderRaw(‘field(status,4,3,0,1,2)’)

from_unixtime(a.create_time,’%Y-%m-%d’) as time

concat(strA, strB) as path //拼接两个concat(strA, strB, strC, …) as date //拼接多个// SQL->field(‘concat(strA, strB) as path’) //TP

select from_unixtime(create_time,’%Y-%m-%d’) as date, COUNT(*) as num FROM table_name GROUP BY date