执行mySQL的INSERT语句

执行mySQL的INSERT语句:

1、插入sql   主键ID也需要填,mysql不会自动生成,--并且需要满足自增

INSERT into tb_roomhclog (ID,RID,RoomID,RoomName,UCount,Raw_URL,Analyse_URL,Analyse_Time,CID,TeacherNo,DepartmentID,CourseName,Jie,SeatRate,ArriveRate,CNumber,DName,CName,OughtPNum,TeacherName,CreateDate,CreateBy,UpdateDate,UpdateBy,IsDel) VALUES(4,'2','1222','张三家',3,'url','url',NOW(),'2','1054','1544','数学','5',1,10,25,'张三','张三',15,'李老师',NOW(),'',NOW(),'','0')
View Code

 

posted @ 2022-10-30 15:05  じ逐梦  阅读(42)  评论(0)    收藏  举报