CODEWITHSUNDEEP
mysqlsql-server
user1391078
user1391078

Reputation: 53

Transform Dynamic statement from SQL-Server into Mysql

Can anybody help me to find a mysql corespondent to the following MS SQL syntax?

CREATE PROCEDURE testsp @COLUMN_NAME VARCHAR(20), @COLUMN_VALUE VARCHAR(20)
AS

DECLARE @SQL VARCHAR(40)  
SET @SQL = 'UPDATE TableX set ''+@COLUMN_NAME+ ''=''+@COLUMN_VALUE+'' '
PRINT (@SQL)
EXEC (@SQL)

Is it possible to translate this code into Mysql?

Thanks!

Upvotes: 0

Views: 71

Answers (1)

Jeremy Goodell
Jeremy Goodell

Reputation: 19002

CREATE PROCEDURE testsp (COLUMN_NAME VARCHAR(20), COLUMN_VALUE VARCHAR(20))
BEGIN
    SET @SQL_COMMAND = CONCAT('UPDATE TableX SET ', COLUMN_NAME, ' = ?');
    SELECT @SQL_COMMAND; /* prints the command */
    PREPARE SQL_STMT FROM @SQL_COMMAND;
    EXECUTE SQL_STMT USING COLUMN_VALUE;
    DEALLOCATE SQL_STMT;
END

Upvotes: 2

Related Questions