数据库
vily_luky
爱哭,爱笑,爱学习
展开
-
msyql----编辑字段
delimiter $ drop procedure if exists pro_put_column; create procedure pro_put_column() BEGIN if exists(select column_name from information_schema.columns where table_name = 'bizlog' and column_name = 'qqq') THEN alter table bizlog CHANGE qqq a.原创 2021-05-29 19:15:10 · 111 阅读 · 0 评论 -
mysql----删除多个字段
delimiter $ drop procedure if exists pro_put_column; create procedure pro_put_column() BEGIN alter table bizlog drop column qqq,drop column aaww; END $ delimiter ; call pro_put_column();原创 2021-05-29 19:14:24 · 2506 阅读 · 0 评论 -
mysql-----新增多个字段
delimiter $ drop procedure if exists pro_put_column; create procedure pro_put_column() BEGIN alter table bizlog add column asd BIGINT ,add column mmm BIGINT ; END $ delimiter ; call pro_put_column();原创 2021-05-29 19:13:50 · 338 阅读 · 0 评论 -
sqlite 查询数量
public Integer getUnreadTaskCount() { Cursor c = db.rawQuery("select count(id) from patrol_task " + "where cur_uid = ? " + "and unread = 1 " , new String[]{"" + User.myUid}); c.moveToFirst(); in...原创 2020-07-31 16:00:43 · 1492 阅读 · 0 评论