By admin, 14 五月, 2015

这个网站有很多优秀摄影师的作品,很美!很享受!
http://500px.com

By admin, 14 五月, 2015

他创建了一个汉字字源网站,在上面你可以搜到几乎每一个汉字的演变过程,甲骨文、小篆、金文,繁体字、简体字。

http://www.chineseetymology.org/

By admin, 14 五月, 2015

A friend of me asked me long time ago: "How can I have a ranking on a result with MySQL?". Now I found some time to write it down:

Lets do first some preparation for the example:

CREATE TABLE sales (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
, fruit VARCHAR(32)
, amount DECIMAL
);

INSERT INTO sales
VALUES (NULL, 'apple', 12.75), (NULL, 'orange', 1.89), (NULL, 'pear', 19.23)
, (NULL, 'banana', 4.25), (NULL, 'cherry', 123.75), (NULL, 'plum', 23.15)
;

Now lets query:

标签