MySQL

本文档使用 MrDoc 发布

根据字段生成自定义SQL语句

## 表结构
```sql
mysql> desc app_doc_doc;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | int(11)      | NO   | PRI | NULL    | auto_increment |
| name           | varchar(255) | NO   |     | NULL    |                |
| content        | longtext     | YES  |     | NULL    |                |
| top_doc        | int(11)      | NO   | MUL | NULL    |                |
| create_time    | datetime(6)  | NO   |     | NULL    |                |
| modify_time    | datetime(6)  | NO   |     | NULL    |                |
| create_user_id | int(11)      | NO   | MUL | NULL    |                |
| pre_content    | longtext     | YES  |     | NULL    |                |
| parent_doc     | int(11)      | NO   |     | NULL    |                |
| sort           | int(11)      | NO   | MUL | NULL    |                |
| status         | int(11)      | NO   |     | NULL    |                |
| editor_mode    | int(11)      | NO   |     | NULL    |                |
| open_children  | tinyint(1)   | NO   |     | NULL    |                |
| show_children  | tinyint(1)   | NO   |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)
```

## 自定义SQL

```sql
select concat('update app_doc_doc set sort=',id,' where id=',id,';') as \
updatesql from app_doc_doc where top_doc = 8 and parent_doc = 62 order by \
name;
```

Nathan 2022年7月30日 23:30 收藏文档

上一篇

下一篇

联系邮箱：service@netimed.cn