How can I employ “if exists” for creating or dropping an index in MySQL?

by

Here is my 4 liner:

set @exist := (select count(*) from information_schema.statistics where table_name="table" and index_name="index" and table_schema = database());
set @sqlstmt := if( @exist > 0, 'select ''INFO: Index already exists.''', 'create index i_index on tablename ( columnname )');
PREPARE stmt FROM @sqlstmt;
EXECUTE stmt;

More Related Contents:

  1. Problame with files on SQL
  2. Php date() Date and time is stuck [closed]
  3. mysqli or die, does it have to die?
  4. Project Links do not work on Wamp Server
  5. MySQL vs MySQLi when using PHP [closed]
  6. PHP/MySQL insert row then get ‘id’
  7. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  8. How can I store and retrieve images from a MySQL database using PHP?
  9. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  10. PHP file cannot enter some part of code
  11. Laravel migration: unique key is too long, even if specified
  12. Laravel: PDOException: could not find driver
  13. Laravel Eloquent select all rows with max created_at
  14. MySQL – count total number of rows in php
  15. Advantages Of MySQLi over MySQL [closed]
  16. Grouping WHERE clauses in Codeigniter
  17. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  18. check if the query results empty row mysqli [duplicate]
  19. SELECT COUNT() vs mysql_num_rows();
  20. Store procedures in phpMyAdmin
  21. double results in my array ( mysql_fetch_array )
  22. How best to get someone’s ‘rank’ from a scores table with php and mysql without looping
  23. How to get rid of MySQL error ‘Prepared statement needs to be re-prepared’
  24. Get MySQL database output via PHP to XML
  25. Using MySQL’s TIMESTAMP vs storing timestamps directly
  26. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment