SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: store procedure

  1. #1
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    301
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    store procedure

    Is there any tool which would help to write store procedure with less typing ?

    some sort of visual designing or auto completion is required.

    Database: MySQL

  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Location
    San Sebastian, Spain
    Posts
    93
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I had developed a nice utility which uses PHP to connect to a database and generates stored procedures which reads all records, reads a single record with input parameters based on a primary key, updates based on the primary key and deletes based on the primary key. Have a look here http://www.it-iss.com/mysql/phpcrud-for-mysql/

  3. #3
    SitePoint Addict
    Join Date
    Dec 2009
    Posts
    301
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Do I need to learn PHP first to use your tool before writing Store Proc.

    I'm worried about learning curve . I don't work in PHP. I also dont want to learn PHP to write store proc.

    Is there any other easy to use tool ?

  4. #4
    SitePoint Guru bronze trophy
    Join Date
    Dec 2003
    Location
    Poland
    Posts
    930
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by windowsxp View Post
    some sort of visual designing or auto completion is required.
    I can't imagine how visual designing can be used for writing stored procedures because stored procedures is computer language code - it's not like a database table structure that you can visually represent - or maybe I am missing something?

    As to auto-completion you can use one of the mysql database management software, a free one with auto-completion is HeidiSQL, a paid one is SQLYog - perhaps others can add their favourites.

  5. #5
    SitePoint Enthusiast
    Join Date
    Jul 2007
    Location
    San Sebastian, Spain
    Posts
    93
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Did you have a quick read and look at the video? That would be the extent of the learning curve.


Bookmarks

Posting Permissions

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