2011年5月30日

mysql 开发指南

摘要: 1.创建索引 create index PENALTIES_AMOUNT on penalties(amount);删除: drop index PENALTIES_AMOUNT;2.创建索引create view number_sets (matchno,difference) as select matchno,abs(won-lost) from matches;删除: drop view number_sets;使用方法:select * from number_sets;3.对用户限制在某个表操作grant select ,update on players to dinnery 阅读全文

posted @ 2011-05-30 17:23 alon 阅读(187) 评论(0) 推荐(0) 编辑

导航