Need a few example queries for updating hundreds of MySQL databases with similar table prefix in their names

Đã Đóng Đã đăng vào 3 tháng trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

I have a project on CPanel (and I have a WHM) on my VPS. We have hundreds of basic/core php sites with MySQL databases that all start with samename_ like: samename_dbname1, samename_dbname2 and so forth. Each database has the same, identical structure and tables and columns.

I think I can use the schema naming logic to update the same table, column and record in ALL of my tables from one query but I am not experienced in which schema names identify:

All databases

A particular table within those databases

A particular record within those databases

For example, what if I want this query?

UPDATE [login to view URL] SET title = "Learn XYZ" WHERE id=1

I guess that db would simply need to be some schema name that identifies any database or any database that starts with samename_

Sometimes I'll need to insert the same exact record into the same table in every database also.

MySQL PHP Quản trị cơ sở dữ liệu Lập trình cơ sở dữ liệu phpMyAdmin

ID dự án: #37712828

Về dự án

76 đề xuất Dự án từ xa 2 tháng trước đang mở

76 freelancer chào giá trung bình$152 cho công việc này

ahmadayaz

Hi, As an experienced full stack developer with a decade of successful project delivery, including countless complex tasks in MySQL and PHP, I believe I'm the ideal candidate for your database updating project. My prof Thêm

$250 USD trong 7 ngày
(309 Nhận xét)
8.7
mascotindia123

Hello Employer, Hope you're doing well! I'm an expert having 11+ years of vast and proven experience in PHP, MYSQL, HTML, DATABASE MANAGEMENT, phpMyAdmin, DATABASE PROGRAMMING, CSS and many other. I request you to re Thêm

$140 USD trong 7 ngày
(320 Nhận xét)
7.8
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Thêm

$180 USD trong 5 ngày
(145 Nhận xét)
7.3
shihan033010

Hi I have read your project requirement. Can you please tell me do you want to run the script for php in in the msyql. I can create the php script to update the data in all database. For that you need a common user an Thêm

$70 USD trong 3 ngày
(327 Nhận xét)
6.8
rubal45

I'll execute queries like updating all databases' table records simultaneously. Let's optimize your processes! Eagerly awaiting your reply, Ravinder Singh

$100 USD trong 7 ngày
(352 Nhận xét)
6.4
anaya8777

I ca help you with this. Please initiate a message for further discussion.

$120 USD trong 2 ngày
(80 Nhận xét)
6.6
Truonggiang86

Hello there, there's a couple of way to do the same query on different table. 1: use the schema information to get all the database (if all in the same machine), then make dynamic SQL to execute immediate of the SQL re Thêm

$250 USD trong 2 ngày
(51 Nhận xét)
6.2
priyank086

Hello, Greetings of the day!! I have understood that you need a few example queries for updating hundreds of MySQL databases with similar table prefix in their names. You have a project on CPanel (and you have a WHM) Thêm

$155.9 USD trong 7 ngày
(72 Nhận xét)
6.5
solutionsplayers

With my extensive background in database programming using MySQL and PHP, I believe I am well-suited for your project. Over the past 7 years, I have built various web applications that involved managing large databases Thêm

$140 USD trong 7 ngày
(58 Nhận xét)
6.0
omnamasshivay

yeah i m well versed with the WHMCS so as i have got your task ready to start work from now

$500 USD trong 2 ngày
(24 Nhận xét)
6.0
MohanKumar28

Hi I have gone through the requirements. Good experience in creating custom softwares using Laravel framework. Will achieve this query task using laravel. I'm available to start now. Please contact for further discussi Thêm

$150 USD trong 3 ngày
(211 Nhận xét)
6.2
NZDevelopers

hi there we are professional php and MySQL developers. we understood your requirement and its possible to update all databases tables in one query kindly come in chat so we can start working on it right now thank you

$100 USD trong 1 ngày
(40 Nhận xét)
5.9
prakash2813

⭐⭐⭐⭐⭐ Hi there, I am full stack developer with 7+ years of experience in website and desktop app development with Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, MongoDB and more. I have strong expertise in Database d Thêm

$120 USD trong 1 ngày
(58 Nhận xét)
6.2
usamae

I'm excited to collaborate on this challenging project! With my skills in PHP, MySQL, Database Administration, and Database Programming, I can help you update hundreds of MySQL databases with similar table prefixes. I Thêm

$250 USD trong 7 ngày
(85 Nhận xét)
6.3
Nehag510

Hello With over years of experience in Full stack development and my strong skills in Database Administration, Database Programming, MySQL and phpMyAdmin, I am well-equipped to handle your project with a high level of Thêm

$250 USD trong 7 ngày
(20 Nhận xét)
5.7
arbu1499

Hello, How are you doing? I have read your job description properly, I am 110% confident to do some schema name that identifies any database as per your requirements with full satisfaction. I am a Senior Website develo Thêm

$109 USD trong 2 ngày
(25 Nhận xét)
5.0
johnbright03

Hello Sir , I have more than 8 years of experience in website development field and have many satisfied clients till now. Hope you will be the next satisfied clients of our's.

$100 USD trong 2 ngày
(13 Nhận xét)
4.7
Demenntor

Dear Client, I hope this message finds you well. I am writing to express my interest in your project involving CPanel and WHM on your VPS. With a comprehensive understanding of your requirements, I am confident in my Thêm

$236 USD trong 7 ngày
(20 Nhận xét)
4.9
atifuiux

Hey there! I just read your project detail and it matches my skills. I've been doing this stuff for the last 10+ years. My versatile skill covers services PHP, WordPress, Woocommerce, Cake Php, CodeIgniter, Magento, La Thêm

$40 USD trong 1 ngày
(41 Nhận xét)
4.8
Webtechfusion23

With your unique challenge of updating hundreds of MySQL databases with a similar table prefix in their names, my 10 years of experience as a Full Stack Web developer, particularly in Core PHP and MySQL, make me an ide Thêm

$50 USD trong 2 ngày
(16 Nhận xét)
4.6