- 博客(4)
- 收藏
- 关注
原创 PGSQL 使用mysql_fdw连接MySQL外库
CREATE SERVER "mysql_nash_invoice" FOREIGN DATA WRAPPER "mysql_fdw" OPTIONS (host '172.20.10.23', port '3306');ALTER SERVER "mysql_nash_invoice" OWNER TO "shujupingtai";CREATE USER M
2018-06-25 10:53:52 976
原创 Postgre SQL 中Json字段新增数据
select json字段名::jsonb || ‘新增字段JSon格式’::jsonb from 表名;例:select invoice_base_info::jsonb || '{"info":"male"}'::jsonb from nash_invoice;来源:http://francs3.blog.163.com/blog/static/4057672720157153719...
2018-06-19 14:32:09 3521 1
原创 Larval安装使用Excel步骤
Larval 安装调用Excelcomposer require maatwebsite/excel ~2.0.0报错信息:报错:Your requirements could not be resolved to an installable set of packages. Problem 1 - Conclusion: don't install maatwebs...
2018-06-19 14:30:51 1356
原创 Postgre Sql 写入Json字段数据
update nash_invoice set invoice_express='{"express_type":"","express_status":"","express_number":""}'; // 更新json字段数据delete from nash_invoice; //
2018-06-19 14:26:56 2903 2
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人