mysql去重并统计数量:
select count(distinct queue_number) as total from queue
mysql去重并统计数量:
select count(distinct queue_number) as total from queue
ubuntu mysql5.5升级到5.7,添加5.7的源后,直接安装就会自动升级了。
升级完成后,要执行一下
mysql_upgrade -u root -p --force
不然执行sql语句的时候会报错: Table 'performance_schema.session_status' doesn't exist
sqlite获取当前时间:
SELECT datetime('now', 'localtime')
C# WINFORM使用html css里十六进制颜色格式:
BackColor = ColorTranslator.FromHtml("#626262");