Laravel应用MySQL脚本

In my previous job, if you needed to update some records on their application, you created a sql script in the 'patches' folder, and once on deployment, a program would run all the new scripts in the folder. It was much like migrations, but it was for updating records, rather than just updating table structure. Does Laravel offer something similar to that? I looked up everywhere for this concept, outside of Laravel and failed to find something similar.

If one wants to automate updating some records in the production database, how does one do it? I know that I can manually run the scripts manually but I want some automation on it.

Thanks

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dtevhgk028372 2014-11-07 16:52
关注
Aren't Laravel Migrations what you are looking for?

You can easily create scripts for manipulation with database records and you can run them from CL via Artisan.

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

Laravel应用MySQL脚本 laravel mysql php
2014-11-07 16:35

回答 1 已采纳 Aren't Laravel Migrations what you are looking for? You can easily create scripts for manipulatio
如何使用Laravel构建MySQL查询 laravel mysql php
2018-01-23 09:43

回答 3 已采纳 You can pass the necessary variables from the parent scope into the closure with the use keyword .
如何使用laravel加速Mysql查询 laravel mysql php
2016-09-09 16:57

回答 2 已采纳 This would be a lot to put in the view but here's the basic concept of what I think you are lookin
docker-compose-laravel:一个简单的shell脚本，使用docker-compose在具有nginx，mysql和php服务的docker容器中运行Laravel应用程序
2021-05-27 22:51

docker-compose-laravel 此存储库中的代码使用外壳程序脚本（launch.sh）在Docker容器中运行开源laravel应用程序。 Shell脚本会检查docker和docker-compose的安装并进行安装（如果找不到）。然后使用docker-compose...
Laravel mysql迁移错误 laravel mysql php
2018-04-20 20:49

回答 5 已采纳 I finally found the solutions a days ago and I remembered this post. In the config/database.php fi
Laravel Eloquent的Mysql索引 laravel mysql php
2018-06-13 09:40

回答 3 已采纳 Just use where('published_date', $date) or wherePublishedDate($date). MySQL can only use an index
Laravel / MySQL数据库连接 database laravel mysql php
2015-05-14 13:53

回答 1 已采纳 I solved the problem by following the solution in the link provided by Bulk. I just have to run su
laravel mysql 配置_laravel 配置MySQL读写分离
2021-01-20 20:56

A玩具爆款孙大帅的博客前言：说到应对大流量、高并发...框架：laravel5.7说明：Laravel默认将 select 的语句让 read 指定的数据库执行，insert/update/delete 则交给 write 指定的数据库，达到读写分离的作用。这些设置对原始查询 raw que...
使用Laravel的MySQL时区 mysql php
2017-01-03 13:15

回答 1 已采纳 MySQL doesn't provide any features to store Timestamp with Timezone. You have to separately mainta
将MYSQL查询转换为Eloquent Laravel laravel mysql php
2018-11-29 04:35

回答 3 已采纳 Use DB:raw() ProductTask::select( 'product_tasks.id as product_task_id', 'tasks.id as tasks_id'
在Laravel 4迁移中创建MYSQL功能 laravel mysql php
2017-01-10 15:26

回答 2 已采纳 I figured out what the problem was, it's the delimiters. it worked after i removed the lignes DELI
laravel编写Console定时脚本
2022-04-22 16:10

书生及第的博客 console任务脚本定时执行
Mysql中脚本应用数据库时出错 java mysql python
2022-11-04 22:30

回答 1 已采纳字符集编码问题吧，修改下彪马格式再试试看
laravel:Laravel 应用程序的样板设置（NGINX、PHP-FPM 和 MySQL）
2021-07-06 12:44

此设置包含一台服务器（ nodes/laravel.yml ），带有Nginx 、 PHP 5.5 （带有 php-fpm 和 composer）和MySQL 5.5 （带有“laravel”用户和“larvel”数据库）我们还包含了一个任务（ tasks/build-laravel.yml ）：...
laravel mysql 视图_php – 在Laravel 4中通过迁移脚本创建MySQL视图
2021-01-19 14:08

weixin_39637921的博客 } 然后,要从应用中的其他位置访问该视图,您可以像查询任何其他模型一样查询该视图,例如 MyView::all(); // returns all rows from your view MyView::where( 'price', '>', '100.00' )->get(); // gets rows from ...
没有解决我的问题, 去提问

悬赏问题

¥15 python中transformers可以正常下载，但是没有办法使用pipeline
¥50 分布式追踪trace异常问题
¥15 人在外地出差，速帮一点点
¥15 如何使用canvas在图片上进行如下的标注，以下代码不起作用,如何修改
¥15 Windows 系统cmd后提示“加载用户设置时遇到错误”
¥50 vue router 动态路由问题
¥15 关于#.net#的问题：End Function
¥15 无法import pycausal
¥15 weditor无法连接模拟器Local server not started, start with？
¥20 6-3 String类定义

Laravel应用MySQL脚本

1条回答 默认 最新

悬赏问题

1条回答默认最新