MySQL query

SELECT 정렬

SELECT * FROM [tablename] ORDER BY [filedname] [ASC][DESC]
//ASC = 오름차순, 작은수에서 큰수
//DESC = 내림차순

Update Counting

UPDATE dbname
SET hit= +1 WHERE id= [id]