# 创建表时指定表组 表组可以在创建表的时候指定，SQL 查询语法格式如下： ~~~ CREATE TABLE table_name ( column_name data_type [, column_name data_type] ) TABLEGROUP tablegroup_name ; ~~~ **示例：创建表时指定表组。** 如下创建订单表和订单明细表，业务上这两个表经常要关联查询，所以建议放到同一个表组中。 ~~~ create table ordr ( o_w_id int , o_d_id int , o_id int , o_c_id int , o_carrier_id int , o_ol_cnt int , o_all_local int , o_entry_d date , index iordr(o_w_id, o_d_id, o_c_id, o_id) local , primary key ( o_w_id, o_d_id, o_id ) )tablegroup tpcc_group partition by hash(o_w_id) partitions 6; create table ordl ( ol_w_id int , ol_d_id int , ol_o_id int , ol_number int , ol_delivery_d date , ol_amount decimal(6, 2) , ol_i_id int , ol_supply_w_id int , ol_quantity int , ol_dist_info char(24) , primary key (ol_w_id, ol_d_id, ol_o_id, ol_number ) )tablegroup tpcc_group partition by hash(ol_w_id) partitions 6; ~~~