摘要: try { using (MySqlConnection conn = new MySqlConnection("Database=Database;Data Source=127.0.0.1;User Id=root;Password=123456;pooling=false;CharSet=utf8")) ... 阅读全文
posted @ 2018-12-24 11:54 sanpi1992 阅读(4065) 评论(0) 推荐(0) 编辑
摘要: USE MASTER GO DECLARE @dbname SYSNAME SET @dbname = 'EducationManagementSystem' -- 这个是要删除的数据库库名 DECLARE @s NVARCHAR( 1000) DECLARE tb CURSOR LOCAL FOR SELECT s = 'kill ' + CAST( spid... 阅读全文
posted @ 2018-12-24 11:51 sanpi1992 阅读(459) 评论(0) 推荐(0) 编辑
摘要: 1 SELECT 2 HOUR (时间) AS HOUR, 3 COUNT( 4 CASE 5 WHEN orderlist.State = 1 THEN 6 orderlist.State 7 END 8 ) AS suCount, 9 COUNT( 10 CASE 11 WHEN orderli 阅读全文
posted @ 2018-12-24 11:41 sanpi1992 阅读(560) 评论(0) 推荐(0) 编辑