Executing SQL Statements from a Text File

Asked Nov 03 '16 at 03:18

Active Nov 03 '16 at 04:46

Viewed 18 times

i have data base problems due to miss organized

to solve this problem i have to run 137073 mysql queries

this is the query sample

update wp_posts set post_author = replace(post_author, '43', '235099');

i create a text file contain 137073 line what is best way to run this queries one by one as a script or some thing

Thanks

edited Nov 03 '16 at 04:46

Drew

asked Nov 03 '16 at 03:18

Mohamed

Are you replacing `137073` numbers? `43` is not replacing forty three. – chris85 Nov 03 '16 at 03:21
do you have access to command line mysql? or do you have phpMyAdmin? – WEBjuju Nov 03 '16 at 03:26
no i am replacing 43 with 235099 and 137071 it total quires number – Mohamed Nov 03 '16 at 03:54
i have phpMyAdmin access – Mohamed Nov 03 '16 at 03:55
I mean if `post_author` is full of integers, `143`, `243`, etc, the `43` there will also be replaced with `235099`. – chris85 Nov 03 '16 at 03:59
The dupe target is about loading a .sql with browse / import / go. Ignore the thing "the other guy" is doing. Focus on how one runs a script with that dupe target – Drew Nov 03 '16 at 04:39

0 Answers0