mysql

1.mysql 有则更新无则插入

INSERT INTO TABLE ( id, feild2, feild3,…feildn )
VALUES
( 1, ‘v2’, ‘v3’,…, ‘vn’ )
ON DUPLICATE KEY UPDATE feild1 = ‘v2’,
feild2 = ‘v3’,
…， feildn = ‘vn’

2.分页数据量大的查询

法1：
SELECT * FROM product WHERE ID > = ( SELECT id FROM product LIMIT 10000, 1 )
LIMIT 10

法2：
SELECT
*
FROM
product a
JOIN ( SELECT id FROM product LIMIT 10000, 10 ) b ON a.id = b.id