General SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > General SQL Development
Reload this Page

Stored Procedure & Trigger Problem.

Discuss Stored Procedure & Trigger Problem. in the General SQL Development forum on Dev Articles.
Stored Procedure & Trigger Problem. General SQL Development forum to discuss Oracle, PostgreSQL, and platform independent SQL related questions. Learn to utilize the power of SQL to manipulate relational databases.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old December 5th, 2002, 11:08 PM
hieunv hieunv is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2002
Location: Vietnam
Posts: 3 hieunv User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Stored Procedure & Trigger Problem.
Hello Everybody,

How to implement the stored procedure and trigger under MySQL?


Thanks,
Hieu.
Reply With Quote
  #2  
Old December 7th, 2002, 08:51 AM
peeyush peeyush is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Location: India
Posts: 17 peeyush User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Send a message via Yahoo to peeyush
I have been the part of this forum from last few weeks and I have seen this problem is being asked by a lot of people including myself. Is anyone out there who can help us???
Reply With Quote
  #3  
Old December 7th, 2002, 11:12 AM
darkvalley darkvalley is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Location: Netherland
Posts: 15 darkvalley User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
indeed very curious if it is even possible to implement a stored procedure in Mysql.
Reply With Quote
  #4  
Old December 7th, 2002, 01:58 PM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,246 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
From what I can see, stored procedures and triggers are planned for MySQL version 5.0:

Quote:
The planned update language will be able to handle stored procedures. Our aim is to have stored procedures implemented in MySQL Server around version 5.0. We are also looking at triggers.


Here's the link.
__________________
____________________________________________
Developer Shed Weekly Writer | DevArticles Forum Moderator
Build Your Own KlipFolio Klip With PHP
FrankManno.com - Under Construction
Design Interactive Group - Under Construction
Reply With Quote
  #5  
Old December 8th, 2002, 08:02 AM
darkvalley darkvalley is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Location: Netherland
Posts: 15 darkvalley User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanx for your reply.

Indeed good to hear version 5 will have SP's included.. Will make life, speed and reliability a lot better IMHO.
Reply With Quote
  #6  
Old December 8th, 2002, 10:37 AM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to Lindset Send a message via AIM to Lindset
MySQL 4 isn't even a stable release yet.. so I guess it will take some time before version 5 comes
__________________
Best Regards,
Håvard Lindset
Reply With Quote
  #7  
Old December 8th, 2002, 10:48 AM
darkvalley darkvalley is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Nov 2002
Location: Netherland
Posts: 15 darkvalley User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
By the way. I want to host a website on MySql using constant updates. If there is no possibility for stored views / procedures. is it faster than for instance access wher I created everything in stored procedures?

I must go to a new database system in my opinion for the hits on the site are around 120.000 per day. With 80.000 pageviews I have around 2 * 80.000 queries being fired per day.

(Around 2 queries on average per second.)

I don't know how much MySql can handle without database corruption etc. But at present everything works like a charm. Real fast etc. Is it worthwhile to go to MySql?

(Should perhaps be posted in another thread... but I thought, while we are at it... why not)
Reply With Quote
  #8  
Old March 4th, 2004, 04:49 AM
vpraveen24 vpraveen24 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2004
Posts: 1 vpraveen24 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
stored procedure in mysql
hi,

stored procedure is very much supported in mysql 5.0.But, you have to use through commandline, no visual tool is released as such now. System is given in the mysql site.

cheers

Praveen.V.
Reply With Quote
  #9  
Old December 8th, 2004, 05:21 AM
gilf gilf is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Dec 2004
Posts: 1 gilf User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Stored procedures are avaliable in version 5.0.1 and triggers will be available from release 5.0.3.

I'm currently developing a tutorial site, very much under construction and hasn't been released yet. If you would like to take an early peek check here.

www.mysqldevelopment.com

Also I have written a 2 part article on the basics which will be featured in the January and Feburary quest newsletters, to subscribe to the newsletter or get other mysql information check out the mysql pipline here.

www.quest-pipelines.com/pipelines/mysql/index.asp

Cheers

Andy G.
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > General SQL Development > Stored Procedure & Trigger Problem.

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.