下载更多文档请访问https://apibase.cn/api.jsp
云数据库接口地址:https://www.dbihelper.cn/linkdb | |
create table mysql.demo_log( logid varchar(30) null comment '记录id', logfont varchar(255) null comment '记录内容', createtime datetime null comment '创建时间', createuser varchar(30) comment '创建用户ID', createip varchar(30) comment '创建IP', updatetime datetime null comment '修改时间', primary key(logid) ) charset=gbk comment='操作记录表' | |
数据查询接口,sqlid:demoselect SQL语句:select * from mysql.demo_log where logfont like ?'[logfont]' and createuser=?'[createuser]' and createip=?'[createip]' order by [orderby] | |
数据删除接口,sqlid:demodelete SQL语句:delete from mysql.demo_log where logfont=?'[logfont]' and createuser=?'[sys.userid]' | |
数据修改接口,sqlid:demoupdate SQL语句:update mysql.demo_log set logfont=?'[logfont]',createtime=?'[createtime]',createuser=?'[createuser]',createip=?'[createip]',updatetime=?'[updatetime]' where createuser=?'[sys.userid]' | |
数据插入接口,sqlid:demoinsert SQL语句:insert into mysql.demo_log(logid,logfont,createtime,createuser,createip,updatetime) values('[sys.id]','[logfont]','[sys.time]','[sys.userid]','[sys.ip]',null) |