CREATE TABLE `member` (
`uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` char(255) NOT NULL,
`pass` char(255) NOT NULL,
`token` char(255) NOT NULL,
`src_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '来源id', PRIMARY KEY (`uid`,`name`)
)
INSERT INTO Persons (LastName) VALUES ('Wilson')
UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'
DELETE FROM Person WHERE LastName = 'Wilson'
SELECT DISTINCT Company FROM Orders
SELECT * FROM member LIMIT 5
SELECT * FROM member WHERE NAME LIKE '%e_a%'
SELECT * FROM member WHERE NAME IN ('zen','test')
SELECT * FROM member WHERE uid BETWEEN '4' AND '11'
SELECT member.`name`,user_data.`nickname` FROM member,user_data WHERE member.`uid`= user_data.`uid`
SELECT NAME FROM member UNION SELECT nickname FROM user_data
SELECT * FROM tablea INNER JOIN tableb ON tablea.name = tableb.name
SELECT AVG(uid) AS uidAvg FROM member
SELECT COUNT(uid) AS uidAvg FROM member 计数
SELECT SUM(uid) AS uidAvg FROM member 总数
在 SQL 中增加 HAVING 子句原因是，WHERE 关键字无法与合计函数一起使用。
SELECT rid,SUM(zdl) FROM sys_hero WHERE rid < 20000000 GROUP BY rid HAVING SUM(zdl) >7800 LIMIT 0,10
