admin表里面有 id username password lastloginip lastlogin2 lastlogintime
这些数据
比如 iD=1 user=admin pass=admin IP=127.0.0.1 ip2=127.0.0.2 time=xxxxx
如果要修改 admin表里的 IP,IP2跟time的语句是什么啊?
这些数据
比如 iD=1 user=admin pass=admin IP=127.0.0.1 ip2=127.0.0.2 time=xxxxx
如果要修改 admin表里的 IP,IP2跟time的语句是什么啊?
set
lastloginip ='192.xxx.xxx.xx',
lastlogin2 ='192.xxx.xxx.xx',
lastlogintime ='2010-xx-xx'
where id=1
update table_name
set lastloginip = '127.0.0.66', lastlogin2 = '127.0.0.88', lastlogintime = #2001-1-2#
where iD = 1
set ip = ...,
ip2 = ...,
time = ...
where iD = 1