방구석코딩이야기

삭제 sudo apt-get purge mariadb-server -y sudo apt-get purge mariadb-common -y sudo apt purge mysql-common -y sudo rm -rf /var/log/mysql sudo rm -rf /var/log/mysql.* sudo rm -rf /var/lib/mysql sudo rm -rf /etc/mysql sudo dpkg -l | grep mariadb 설치 sudo apt update sudo apt install mariadb-server -y sudo apt-get install mariadb-client -y sudo apt-get install libmariadbclient-dev -y sudo find / -iname..

SELECT * FROM( select * from tb_event_his where (iSid, stDateTime) in ( select iSid, max(stDateTime) as stDateTime from tb_event_his group by iSid ) order by stDateTime desc )t group by t.iSid;