我一直在嘗試評論我創建的表 comment = 'this is a comment'
但它總是導致錯誤。我嘗試通過以下方式放置它：
create table info comment = 'this is a comment about table info' (
...
);
create table info (
places varchar(15) not null,
solar_system varchar(20),
primary key (places),
comment = 'this is a comment about table info'
);
create table info (
places varchar(15) not null,
solar_system varchar(20),
comment = 'this is a comment about table info',
primary key (places)
);
create table info (comment = 'this is a comment about table info',
places varchar(15) not null,
solar_system varchar(20),
primary key (places)
);
我應該怎么做才能使桌子上的評論起作用？
uj5u.com熱心網友回復：
您可以評論列和表格
CREATE TABLE example (
example_column INT COMMENT "This is an example column",
another_column2 VARCHAR(100) COMMENT "One more column"
) COMMENT="This is a comment about table";
所以在你的情況下
create table info (
places varchar(15) not null,
solar_system varchar(20),
primary key (places)
) comment = 'this is a comment about table info';
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/463075.html
上一篇：影像比較不適用于相機捕獲的影像
下一篇：SQL日期過濾器|模型性能