windowsxp — 2012-10-05T05:29:54-04:00 — #1
Is there any tool which would help to write store procedure with less typing ?
some sort of visual designing or auto completion is required.
rcashell — 2012-10-05T15:18:42-04:00 — #2
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/
windowsxp — 2012-10-06T00:54:18-04:00 — #3
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 ?
lemon_juice — 2012-10-07T16:29:59-04:00 — #4
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.
rcashell — 2012-10-08T04:45:36-04:00 — #5
Did you have a quick read and look at the video? That would be the extent of the learning curve.