default '0',
primary key(id),
key pname(name, price)
)engine=InnoDB default character set=utf8;
mysql...> select a.id aid, b.id bid, a.name aname, b.name bname from products a, products b;
mysql> select...a.id aid, b.id bid, a.name aname, b.name bname from products a, products b where a.id=b.cid;
mysql>..., b.id bid, a.name aname, b.name bname from products a, products b where a.id=b.cid order by aid;
mysql...> select * from products group by cid having cid between 2 and 9;
mysql> select * from products group
