Need a few example queries for updating hundreds of MySQL databases with similar table prefix in their names
$30-250 USD
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.
ID dự án: #37712828
Về dự án
76 freelancer chào giá trung bình$152 cho công việc này
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
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
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
I'll execute queries like updating all databases' table records simultaneously. Let's optimize your processes! Eagerly awaiting your reply, Ravinder Singh
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
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
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
yeah i m well versed with the WHMCS so as i have got your task ready to start work from now
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
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
⭐⭐⭐⭐⭐ 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
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.
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