te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>mysql - Coda: Automating Row Addition in Secondary Table Based on New Multi-Select Options in a main Table - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>mysql - Coda: Automating Row Addition in Secondary Table Based on New Multi-Select Options in a main Table - Stack Overflow

    mysql - Coda: Automating Row Addition in Secondary Table Based on New Multi-Select Options in a main Table - Stack Overflow

    programmeradmin2浏览0评论

    I'm using Coda for managing some databases and need help with automating a specific task (it can be using a button also). I have two tables:

    • Table Companies, the main table, with two multi-select columns: "Product Type A" and "Product Type B". This will be the main table I will be using in the future.
    • Table Products, where I want to gather all the features mentioned in the two columns "Product Type A" and "Product Type B", as the ID column (I did not create a relation directly because I need to have two different columns in table Companies to characterize in different ways each product, but want to have a complete list in the table Products).

    What I need to do: Whenever a new option is added to either of the columns "Product Type A" and "Product Type B", I want to automatically add a new row to my "Products" table with the name of the new option, something that would follow this logic:

    1. Trigger: Detect when a new option is added to the "Product Type A" and "Product Type B" columns in the "Companies" table.

    2. Condition: Check if the new option is not already present in the "Products" table.

    3. Action: Add a new row to the "Products" table with the name of the new option.

    I've tried setting up an automation rule, but I'm having trouble with the formulae to check for new options and add them correctly. Any guidance on how to set this up would be greatly appreciated!

    Thanks in advance!

    继续浏览有关 的文章

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论