Run SQL queries via outside of phpmyadmin

S

shaymiller

Regular Member

Dec 3, 2016

456

45

• Jul 18, 2019

• #1

I have list of many sql queries I run directly in my phpmyadmin for data moving around from one table to another, updating, multiplication etc

I have these queries saved into a Notepad and whenever I need to run one, I just copy/paste into phpmyadmin.

I am looking for a simple solution, where I can save all of these queries into an database and run it by click "RUN" button. Note, all of these queries has to be run in order, so I can't paste 10 sql queries at once.

 

blackcommoner

Power Member

Jr. VIP

Jun 7, 2015

621

178

• Jul 18, 2019

• #2

shaymiller said:

run it by click "RUN" button.

Click to expand...

You need programming language for that.

 

S

shaymiller

Regular Member

Dec 3, 2016

456

45

• Jul 18, 2019
• Thread Starter Thread Starter

• #3

blackcommoner said:

You need programming language for that.

Click to expand...

I know

Looking for a script in php

 

PHPInjected

Elite Member

Executive VIP

Jr. VIP

Apr 25, 2014

6,918

12,423

• Jul 18, 2019

• #4

shaymiller said:

I know

Looking for a script in php

Click to expand...

Are you looking for a premade script or are you attempting to hire someone?

 

alexio

Senior Member

Jan 10, 2013

995

304

• Jul 18, 2019

• #5

maybe the software heidySQL can do this job

 

blackcommoner

Power Member

Jr. VIP

Jun 7, 2015

621

178

• Jul 18, 2019

• #6

If you have basic programming knowledge, try this:

https://www.w3schools.com/php/php_mysql_update.asp

 

MrAttribution

Junior Member

Jun 16, 2019

102

40

• Jul 19, 2019

• #7

Googling "sql queries one after another" will give you code examples for multiple database engines. MySQL, Postgres, SQLite etc. are all different, so there is no one approach.