mysql怎么增删改除_mysql里面如何写增删改查

我在mysql里面写了个查询语句，可是有错stringstrsql=string.Format("selectconvert(varchar(16),EM_Date,121)+':00',convert(decimal(10,3),avg(EM_SO2)),convert(decimal(10,3),avg...

我在mysql里面写了个查询语句，可是有错string strsql = string.Format("select convert(varchar(16),EM_Date,121)+':00' ,convert(decimal(10,3),avg(EM_SO2)),convert(decimal(10,3),avg(EM_CO)),"

+ "convert(decimal(10,3),avg(EM_NO)),convert(decimal(10,3),avg(EM_NO2)),convert(decimal(10,3),avg(EM_NOX)),"

+ "convert(decimal(10,3),avg(EM_PM10)),convert(decimal(10,3),avg(EM_O3)),convert(decimal(10,3),avg(EM_TMP)),"

+ "convert(decimal(10,3),avg(EM_Airpre)),convert(decimal(10,3),avg(EM_WSPD)),convert(decimal(10,3),avg(EM_WDIR)),"

+ "convert(decimal(10,3),avg(EM_HUMD)),convert(decimal(10,3),avg(EM_IDTP)),convert(decimal(10,3),avg(EM_IDHU))"

+ "from envirairmonitor where EM_Date > '{0}' and EM_Date < '{1}'and ID = {2} group by convert(varchar(16),EM_Date,121)+':00' ", date1, date2,id);

展开