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.

Sundar · Answer

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

Mani Kandan · 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); } }