SQL增删改查

iduq.sh

#修改已存在数据
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]

update loghis set dirtime='12331' where logpath='/Users/ayuliao/Downloads/temp/20181017/'

#插入数据
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES
( value1, value2,...valueN );

insert into loghis (logpath,dirtime,addtime) VALUES ('ayuliao/nn','123','321')

# 查询数据
SELECT column_name,column_name FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]

select dirTime from loghis where logpath='/Users/ayuliao/Downloads/temp/20181020/'