$wpdb and MySQL Create Trigger

In the question you linked to, the solution was to use mysqli_multi_query as the API for executing the SQL. $wpdb desen’t have an API to do a multi query therefor you can’t use it directly, but you can get the handle to the mysql interface from $wpdb->dbh and do something like 

$sql_trigger = "....";
mysqli_multi_query($wpdb->dbh,$sql_trigger);

Related Posts:

  1. How do you properly prepare a %LIKE% SQL statement?
  2. wpdb->prepare function remove single quote for %s in SQL statment
  3. Alternative to mysql_real_escape_string
  4. Increment value (value = value+1) of $wpdb->update
  5. wpdb Custom Meta Data with 2 conditions
  6. wpdb prepare syntax
  7. SQL query not working in alphabetical post title/content search
  8. MySQL LIKE not working
  9. Proper way to work with wpdb to get user’s firstname
  10. How to check for empty and not a failure
  11. Database: Custom table: sprintf value for DateTime column
  12. Converting mysql to $wpdb
  13. WP_USE_EXT_MYSQL
  14. wpdb insert and boolean fields
  15. Join new table with SQL query
  16. writing inner join in wpdb
  17. How to split the a table in database?
  18. MySQL Rank & $wpdb
  19. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  20. How do I join a $wpdb query with user meta using default value if not exist?
  21. How to translate this mySQL query to $wpdb query
  22. $wpdb select all meta for each post
  23. $wpdb to insert html form information
  24. Proper usage of $wpdb->update()?
  25. WordPress(wpdb class) and mysql stored procedures
  26. Can’t run database query
  27. Using WPDB->Insert()
  28. Active DB queries in WordPress?
  29. How to stop $wpdb from prepending database name
  30. WordPress $wpdb get posts from category and sort by custom meta
  31. How to get INSERT errors from $wpdb?
  32. Getting Error Trying to Create Table
  33. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  34. Understanding custom php that reads from WP MYSQL
  35. How to insert dash (-) into database using wpdb and new_to_publish hook?
  36. $wpdb->get_var multiple queries in one database check
  37. List users with the most posts in the last 30 days
  38. Insert two row in wordpress database
  39. WordPress $wpdb no result
  40. PHP variables in mysql query
  41. MySQL ‘duplicate entry’ error
  42. User set date and time from frontend doesn’t get stored into database
  43. Wpdb query with dynamic table name
  44. get posts whether meta_key exists or not
  45. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  46. How to search usermeta table
  47. How to add virtual column in wpdb get_result statement
  48. wpdb insert into point column in db
  49. WPDB delivers wrong results from complex queries
  50. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  51. CONCAT_WS in custom sql query
  52. Geographical proximity query using post_meta
  53. MySQL Select within WP Page template
  54. Saving custom term value to the database in new table
  55. why is $wpdb->update() causing a DB error from within wp_set_password()
  56. $wpdb->get_var returns 0
  57. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  58. MySQL Error “Operand should contain 1 column”
  59. MySQL server startup error ‘The server quit without updating PID file’
  60. Duplicating a MySQL table, indices, and data
  61. MySQL IF NOT NULL, then display 1, else display 0
  62. Get the new record primary key ID from MySQL insert query?
  63. How to change collation of database, table, column?
  64. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  65. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  66. Remove Primary Key in MySQL
  67. How to get the max of two values in MySQL?
  68. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  69. Using wpdb to connect to a separate database
  70. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  71. How to log mysql errors from wordpress core?
  72. Fulltext search in posts sorted by relevancy
  73. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  74. How to bulk delete all WordPress subscribers?
  75. Changing Table Prefix for an Existing WordPresss Site
  76. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  77. Connect another DB and fetch records from some tables
  78. Can I restart MySQL engine when WordPress website is live?
  79. Why my wordpress loopback traffic while socket is setup?
  80. wpdb custom tables without plugin
  81. Update or insert meta key value – On Duplicate key update
  82. Connect to MySQL using Windows Authentication
  83. Have working sql query… trying to adjust it to use $wpdb
  84. Export Yoast Keywords from MySQL/phpMyAdmin
  85. Same database; different WordPress
  86. How do I prepare strings for insertions as values into a MySQL table?
  87. Why won’t this wpdb get_results query return results?
  88. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  89. WordPress & MySQL , problem with use many array in meta_query
  90. Using wpdb to connect to a different database is not working
  91. WordPress Dutch characters encoding problem
  92. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  93. How do I insert content of various MySQL fields in post?
  94. Select latest 2 articles, but only from given category
  95. Query does not filter duplicate _sku numbers
  96. wp_postmeta – lot of meta fields
  97. MySQL database migration to WordPress
  98. MySQL: get post_tag items that are tags (not SEO keywords)
  99. cannot log in to the mysql server (wamp and wordpress)
  100. SQL command to export post_content from wp_posts using phpMyAdmin

Leave a Comment