How to create dynamic query in mySql

Question

Hello, How to create dynamic string in where clause in stored produce in MySql

Rajkiran Swain · Answer

REATE DEFINER=`root`@`localhost` PROCEDURE `test`(input VARCHAR(15)) BEGIN SET @input = input; if @input= "asc" then SET @sort = " order by ActivityLogKey asc" ; elseif @input = "desc" then SET @sort = " order by ActivityLogKey desc" ; else SET @sort = "" ; end if ; SET @query = CONCAT( 'select * from activitylog ' ,@sort, ' limit 0, 5' ); PREPARE stmt FROM @query; EXECUTE stmt; DEALLOCATE PREPARE stmt; END

Edward paul · Answer

Thanks Rajkiran Swain your answer ....... is really worked a lot for me in creating pasting dynamic query in mySql.

Sundaram Subramanian · Answer

whereClause = "WHERE 1 = 1" if(keywords is not null) { whereClause += "AND description LIKE '%keywords%'" } if(price is not null) { whereClause += "AND price = '%price%'" }

Abhilash J A · Answer

Do you mean this ? MySqlConnection dbConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings[ "qscanConnectionStrings" ].ConnectionString); public void deleteLog( int logId) { string sql = "UPDATE Tble_UserSetUp SET IsActive = 0 WHERE Id='" + logId + "'" ; MySqlCommand insertSQL = new MySqlCommand(sql, (MySqlConnection)dbConnection); try { dbConnection.Open(); insertSQL.ExecuteNonQuery(); dbConnection.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } }

How to create dynamic query in mySql

Answers (4)