0

is it possible to go through the whole database and where value equals value to change it to other value at any key name?? like go through the tables and change the value at any key.

Database>
    table1>
        somekey> x
    table2>
        otherkey> x

now I want to change the x at any key to a y value

Sagi zawi
  • 21
  • 4
  • 1
    *"is it possible to go through the whole database and where value equals value to change it to other value at any key name??"* Maybe, do you want to know more see [Why should I provide a Minimal Reproducible Example for a very simple SQL query?](https://meta.stackoverflow.com/questions/333952/why-should-i-provide-a-minimal-reproducible-example-for-a-very-simple-sql-query) – Raymond Nijland Oct 22 '19 at 08:34
  • 2
    Please make this a complete question by adding some sample data. – Tim Biegeleisen Oct 22 '19 at 08:34
  • Look at this question: [Get table column names in MySQL?](https://stackoverflow.com/questions/639531/search-in-all-fields-from-every-table-of-a-mysql-database) – StephaneM Oct 22 '19 at 14:24

0 Answers0