Is it possible? I'm using 4.1.something on my development site. I looked at ch.19 of the manual, and that seems like an awful lot to go through just to create a simple stored procecdure. There w...
http://www.experts-exchange.com/Database/MySQL/Q_21790608.html
Zones:
MySQL ServerDate Answered: 03/27/2006 Rating: 9.6 Views: 0
I'm trying to create a procedure using the same syntax successfully used on a different server with the same version of MySQL. This is a new LAMP server (CentOS 5.2) so mysql may not be configured...
http://www.experts-exchange.com/Database/MySQL/Q_24274098.html
Zones:
MySQL ServerDate Answered: 04/14/2009 Rating: 6.8 Views: 132
I recently transitioned from MSaccess to Mysql database and i am a bit confused on creating the stored procedures in mysql. In MSaccess, alls i had to do was type the sql select statement and drop...
http://www.experts-exchange.com/Database/MySQL/Q_21281848.html
Zones:
MySQL ServerDate Answered: 01/27/2005 Rating: 8.4 Views: 0
hi,
Please kindly assist on creating stored procedure mysql 4.1
in MS
create proc sp_test
@var int
as
select * from table1 where score = @var
in mysql ???
Thanks.
http://www.experts-exchange.com/Database/MySQL/Q_21594835.html
Zones:
MySQL ServerDate Answered: 10/14/2005 Rating: 8.6 Views: 0
Hello,
Please could you help me with the Stored Procedure below, I am new to working with Stored Procedures in MySQL 5.0, converting over from SQLServer, and keep getting errors.
Using phpMyA...
http://www.experts-exchange.com/Database/MySQL/Q_21671644.html
Zones:
MySQL ServerDate Answered: 12/22/2005 Rating: 8.6 Views: 52
Hi
I have (2) Questions
Q.1: I try to create a stored procedure, but I am getting syntax error each time.
What is wrong?
Syntax 1
mysql> delimiter //
mysql> create procedure AgentAnswr...
http://www.experts-exchange.com/Database/MySQL/Q_22835869.html
i have many stored procedures to change from ms sql to mysql i ave no experiance whatsoever in doing stored procedures, is there anyone who could change this simple one for me to give me a platform...
http://www.experts-exchange.com/Database/MySQL/Q_22856238.html
hi,
Please kindly assist how can we create a stored procedure in mysql 5.
thanks.
i.e.
1.
create proc sp_list_employees
as
select * from table1
2.
create proc sp_date_grade_list
@...
http://www.experts-exchange.com/Database/MySQL/Q_21631158.html
Zones:
MySQL ServerDate Answered: 11/15/2005 Rating: 9.2 Views: 0
Does anybody know of an application that will automatically create INSERT, UPDATE and DELETE procedures/functions if you pass it a reference to a mysql table?
http://www.experts-exchange.com/Database/MySQL/Q_22124506.html
Zones:
MySQL ServerDate Answered: 01/17/2007 Rating: 7.6 Views: 0
I am having trouble createing a stored procedure on a remote database hosted by my ISP and am getting the following error:
Access denied for user 'ABCDEF'@'%' to database 'test_db'
I can take...
http://www.experts-exchange.com/Database/MySQL/Q_22710804.html
Zones:
MySQL ServerDate Answered: 07/25/2007 Rating: 7.2 Views: 0
