SELECT bill_code FROM bill AS b LEFT JOIN bill_owner AS o ON b.bill_id=o.bill_id WHERE owner_nm =
(SELECT owner_nm FROM bill WHERE '4be8060aa7a24ea88bc95864e02d6f10' = root_id) AND '4be8060aa7a24ea88bc95864e02d6f10' = root_id
输出结果大于一行,
在MySQL数据库中,
字段或列的注释是用属性comment来添加。
创建新表的脚本中,
可在字段定义脚本中添加comment属性来添加注释。
示例代码如下:
create table test(
id int not null default 0 comment ‘用户id’
)