Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010

    Unanswered: Create Stored Procedures From DB

    Since coming from the MSSQL world I would typically always start a project by creating stored procedures for selected tables (CRUD Stuff) and then fine tune them. There would be a GUI to select the tables and bang a stored procedure would be created for you.

    I have literally 50+ to do in the new project using MYSQL and have not found a tool to do so?

    Although I am loving MySQL as it's fast, easy to maintain and not such a PIA (Pain In Ass) as something MSSQL could be the tons of little tools like this is making it harder to get married to MYSQL, still dating now!


  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Hi Jim,

    I developed a PHP script that does this. Unfortunately it has to be run from the command line. This does not create the tables but reverse engineers the procedures for you based on the primary key of the tables that you have already created in the database.

    phpCrud for MySQL IT Integrated Business Solutions
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts