{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Subject': 'VARCHAR(255) NOT NULL', 'Title': 'VARCHAR(255)', 'Extract': 'TEXT', 'CharCount': 'INT DEFAULT 0', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'UpdateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'}
SELECT Extract, CharCount, CreateTime FROM data_wikipedia WHERE Subject = '{subject}'
AND Package = '{package}'
ORDER BY UpdateTime DESC LIMIT 1
INSERT INTO data_wikipedia
(Guid, Subject, Title, Extract, CharCount,
Package, Module)
VALUES
('{guid}', '{subject}', '{title}',
'{extract}', {char_count},
'{package}', 'ObjServiceWikipedia')
ON DUPLICATE KEY UPDATE
Title = VALUES(Title),
Extract = VALUES(Extract),
CharCount = VALUES(CharCount)
SELECT Subject, Title, CharCount, UpdateTime FROM data_wikipedia WHERE Package = '{package}' ORDER BY Subject
SELECT Subject, Title, Extract, CharCount FROM data_wikipedia WHERE Package = '{package}'
AND (Subject LIKE '%{search}%'
OR Extract LIKE '%{search}%')
ORDER BY Subject