mysql 数据库 真删改查 常用命令

数据库 2019-11-11 44 次浏览 次点赞

#数据库增删改查
update easy_lhc_bet set bet_issue ='2019113' where bet_issue ='2019114' and lhc_name='lhc';

update easy_admin_ip_permit set ip_list ='["115.84.117.102","210.5.58.161","203.177.152.7"]' where 
id='8';

select id,oid,site_id,user_name,tel,email,country,city,pay_name from user_list where user_name 
='ok3698';

insert into easy_lot_kill (id,lot_id,percent,bets_num,bets_money,user_num,play_num) values 
(3,12701,80,0,0,0,0);

update easy_lot_result set opentime=opentime-interval '1 days' where lot_id=12101 and opentime>'2019-1 
0-02';

update easy_lot_result set date='4,6,6' where lot_id ='11101' and issue='20191016017';

update  easy_user_config set value='' where name='email' and value !='' and value not like '%@%';

update  easy_user_config set value='' where name='email' and value !='' and value not like '%@%' limit 
300;

select count(*) from easy_user_config where name='email' and value !='' and value not like '%@%' limit 
300;

select * from easy_user_config where name='email' and value !='' and value not like '%@%' limit 300;

select count(*) from easy_user_config where name='email' and value !='' limit 100;

select user_name,pay_name,tel from user_list where tel like '1%';

select user_name,pay_name,tel,logintime,virtual from user_list where  tel  ~* '[A-Z]';

select user_name,pay_name,tel,logintime from user_list where tel!='' and virtual='t' order by id limit 
100;

本文由 laowang 创作,采用 知识共享署名 3.0,可自由转载、引用,但需署名作者且注明文章出处。

还不快抢沙发

添加新评论