This query is trying to insert data into three tables: 'tab_goods', 'tab_outbound', and 'tab_warehouse'.

The columns being inserted into the 'tab_goods' table are 'gid', 'gcategory', 'gname', 'gmodel', 'gprice', 'gnumber'. The values being inserted for these columns are 11, '哈哈', '会话', 'd', 222, and 100 respectively.

The columns being inserted into the 'tab_outbound' table are 'o_gid', 'o_wid', 'odate', 'outbound', and 'outmoney'. The values being inserted for these columns are 11, 1, 2023-08-01, 20, and 479374 respectively.

The columns being inserted into the 'tab_warehouse' table are 'wid', 'wname', 'waddress', and 'wmoney'. The values being inserted for these columns are 1, '仓库1', '地址1', and 2000 respectively.

Overall, this query is attempting to insert data into multiple tables in one statement, linking the data through common columns.

SQL INSERT Statement: Inserting Data into Multiple Tables

原文地址: https://www.cveoy.top/t/topic/qqqg 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录