常用mysql语句

2018-10-16 19:09:45 xhs
1、格式化时间 FROM_UNIXTIME(v.visit_time, '%Y-%m-%d') AS visit_time select request_data, FROM_UNIXTIME(create_...

UPDATE语句写错了

2018-09-06 10:54:32 xhs
想更新物品数量,本来是9,需要减5,并且更新时间 SQL写成这样 UPDATE user_borrow_goods SET num=num-5 AND update_time=1535363307 WHERE...

mysql可连接IP

2019-01-31 13:40:36 xhs
mysql> insert into user (host,user,password, ssl_cipher, x509_issuer,x509_subject) values('192.168.3.%','r...