Menu ▾ ▴

#1334 Generate SQL query to use later

Needs_planning
duplicate
nobody
Data insertion/extraction/manipulation (148)
5
2013-07-11
2011-11-09
Anonymous
No

Hello,

Many times I want to add a new column, change another column, and add an index for the same table.
But, once the table is already large, all these changes should be made at the same time (same query).

It's hard to me to make the SQL query manually, so, phpMyAdmin would help me allot if I could just "generate" the SQL for each change BEFORE applying. Unfortunately, I must have a table for tests, so that I test there, and copy the generated query after it applied there, and then I accommodate it to the table I want.

So, if phpMyAdmin had this feature, I could just "simulate" the queries, and then I join all of them manually into a single "ALTER TABLE" query (adding commas).

Discussion

  • Michal Čihař

    Michal Čihař - 2011-11-10

    This artifact has been marked as a duplicate of artifact 2521245 with reason:
    already requested

     

  • Michal Čihař

    Michal Čihař - 2011-11-10
    • status: open --> closed
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed
     

  • Nuno

    Nuno - 2013-07-11

    Hello,

    I see this is marked as fixed, but I don't see it in the newest version of phpMyAdmin yet, neither I see the change logs of the non-released versions suggesting that: http://www.phpmyadmin.net/documentation/changelog.php

    Which version is this planned to?

    Thank you.

     

  • Michal Čihař

    Michal Čihař - 2013-07-11
    • status: fixed --> duplicate
     

  • Michal Čihař

    Michal Čihař - 2013-07-11

    The state was wrong as you could read from above comments - it was closed as a duplicate.