就是数据库按照超级表插入子表的时候。
能将具体的 sql 发出来吗？执行 sql 有报告什么错误？
use stock_md;
insert into fb_data_100000.sz
using fb_data TAGS (‘100000.sz’)
(
datetime, msg_id, is_opening, pre_close, open, new_price, high, low, avg_price,
last_vol, last_money, original_vol, original_money, vol, money, num_trades,
hl_percent, change, bs,
buy_vol1, buy_vol2, buy_vol3, buy_vol4, buy_vol5,
buy_price1, buy_price2, buy_price3, buy_price4, buy_price5,
sell_vol1, sell_vol2, sell_vol3, sell_vol4, sell_vol5,
sell_price1, sell_price2, sell_price3, sell_price4, sell_price5
)
values (
‘2025-12-19 10:37:00.000’, ‘MSG_600022_1037’, true, 1.48, 1.48,
1.49, 1.50, 1.48, 149.06,
0, 0, 310075, 46220298,
310075, 46220298, 1258, ‘0.68%’, 0.01, ‘0’,
14038500, 16129600, 8450800, 6420300, 2586400,
1.49, 1.48, 1.47, 1.46, 1.45,
19482800, 16283100, 8536400, 7058000, 5531700,
1.50, 1.51, 1.52, 1.53, 1.54
); 执行没有报错，但显示影响行数为0。语句不生效。
你安装的时候哪个版本？表名中是不能有 点 号的，即使使用 飘号 引起来也不行，应该会报错。
这是我执行的情况：
taos> insert into test.`fb_data_100000.sz` using meters tags(11, '100000_sz') (ts, current) values('2025-12-22 10:38:18.000', 22);
DB error: The table name cannot contain '.' [0x80002617] (0.000100s)
create stable if not exists fb_data (
datetime timestamp,
msg_id nchar(64),
is_opening bool,
pre_close double,
open double,
new_price double,
high double,
low double,
avg_price double,
last_vol bigint,
last_money bigint,
original_vol bigint,
original_money bigint,
vol bigint,
money bigint,
num_trades bigint,
hl_percent nchar(32),
change nchar(32),
bs nchar(8),
buy_vol1 bigint,
buy_vol2 bigint,
buy_vol3 bigint,
buy_vol4 bigint,
buy_vol5 bigint,
buy_price1 double,
buy_price2 double,
buy_price3 double,
buy_price4 double,
buy_price5 double,
sell_vol1 bigint,
sell_vol2 bigint,
sell_vol3 bigint,
sell_vol4 bigint,
sell_vol5 bigint,
sell_price1 double,
sell_price2 double,
sell_price3 double,
sell_price4 double,
sell_price5 double
) tags (
code nchar(9)
);我的版本是3.3.8.8。如果确实不行的话我想想别的办法。
