how to pass array in mysql procedure parameter
For All IT I have Data string “123″. How to create procedure (MySQL) for string “123″ to Be : 1. 123 2. 132 3. 231 4. 213 5. 312 6. 321 Point 1-6 is array. Please Help Me an Thanks Thanksss
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.
Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I got [...]
Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE [...]
Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won’t accept this stored procedure and cites ‘Incorrect Number of Arguments; expected 1, got 0′. Im pretty new to MySQL and perhaps I shouldn’t be creating stored procs the way I do: CREATE DEFINER=`admin`@`localhost` [...]





