select * from actionlog where JSON_EXTRACT(action, '$name')='reward'
const actionLogs: ActionLog[] = await ActionLog.findAll({
where: Sequelize.where(
Sequelize.fn('JSON_EXTRACT',
Sequelize.col('action'),
'$.name'),
'reward')
})
duongame
Android developer
Tuesday, December 3, 2019
Tuesday, October 8, 2019
MariaDB /usr/local/etc/my.cnf.d No such file or directory
$ mysql.server start
/usr/local/Cellar/mariadb/10.3.10/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
Starting MariaDB
./usr/local/Cellar/mariadb/10.3.10/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
/usr/local/Cellar/mariadb/10.3.10/bin/my_print_defaults: Can't read dir of '/usr/local/etc/my.cnf.d' (Errcode: 2 "No such file or directory")
Fatal error in defaults handling. Program aborted
191008 10:52:51 mysqld_safe Logging to '/usr/local/var/mysql/namjungsoo-MacBook-Pro.local.err'.
191008 10:52:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
ERROR!
해결 방법: 아래의 명령을 통해서 폴더를 만들어준다.
mkdir /usr/local/etc/my.cnf.d
Monday, September 16, 2019
MySQL timezone convert function CONVERT_TZ
update account set createdAt=CONVERT_TZ(createdAt, '+00:00', '+09:00'), updatedAt=CONVERT_TZ(updatedAt, '+00:00', '+09:00')
Wednesday, September 4, 2019
MariaDB Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
mysql.server start
Starting MariaDB
.190904 09:57:41 mysqld_safe Logging to '/usr/local/var/mysql/duongame-MacBook-Pro.local.err'.
190904 09:57:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
SUCCESS!
mysql.server start
Starting MariaDB
.190904 09:57:41 mysqld_safe Logging to '/usr/local/var/mysql/duongame-MacBook-Pro.local.err'.
190904 09:57:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
SUCCESS!
Subscribe to:
Posts (Atom)