选择: select * from user where user.id=1; 插入: insert into user(user.id,user.name,user.pwd) values('3','testname','testpwd') insert into booktest(booktest.id,booktest.name,booktest.price,booktest.userid) values(1,'好书名',15,null) 删除: delete from user where id=3 更新: update user set user.name='updatename' where user.id=2 Like语句: select * from user where user.name like '%name%' 排序: select * from user order by user.id desc 总数: select count(*) from user 求和: select sum(book.price) from book 平均: select avg(book.price) from book 最大: select max(book.price) from book 最小: select min(book.price) from book left join: select * from user u left join book b on u.id=b.userid; Group by: select u.id,u.name,count(*) from user u left join book b on u.id=b.userid group by u.id; IN: select * from book where price in(25,10) NOT IN: select * from book where price not in(25,10) 子查询: select * from user where user.id in(select book.userid from book) Between: select * from book where book.price between 5 and 30 时间函数: select DAYOFWEEK('1998-02-03'); select WEEKDAY('1997-10-04 22:23:00'); 创建表 CREATE TABLE booktest ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(1024) NOT NULL, price int(10) not null, userid int(10) ) TABLESPACE ts_1 STORAGE DISK ENGINE NDBCLUSTER;