# 創建表時指定表組 表組可以在創建表的時候指定，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; ~~~