It is possible with MySQL, and it doesn’t seem to create any problem with wordpress’s dbDelta()
Here is the line you need to change
$charset_collate = $wpdb->get_charset_collate() . ' engine = innoDB';
You simply have to add engine = innoDB
at the end of the SQL query and the correct engine will be used by MySQL
Related Posts:
- WordPress Scheduled Event Request Blocking
- Accessing the database from a plugin outside of action hooks
- Update results, Before deleting the related category [closed]
- Store a default value for a transient on plugin activation
- Execute long and heavy processes
- wpdb prepare insert table doesn’t work
- Building a REST API for your web app exposes primary keys of DB records?
- How do I make this Metabox show current DB value?
- select a single val though a table in wordpress
- wp_update_post gives 500 internal error
- code that I can run, or a plug in to show what sql tables something pulls information from
- How to edit the default database of WordPress [closed]
- Create custom table for wordpress custom registration flow
- Should I use spl_autoload_register() in my plugin?
- How do I make an HTML table from a database table?
- How can I save a multiple select array with the settings API for a plug-in options page?
- Using register_activation_hook in classes
- Is there a way for a plugin to add an attribute to the tag of a theme?
- Gutenberg Blocks doesn’t render correctly when using do_blocks
- Does WordPress cache get_user_meta() results?
- Why WordPress uses 4 tables to manage terms
- My shortcode is showing up twice
- Database “Migration” for Plugins?
- No wp-config.php file on local install of wordpress – site still displays
- How to find the output of contact form 7 shortcode? [closed]
- Issue with foreach on duplicate meta_key’s
- Does wp-cron runs all tasks scheduled at same time together or one after other?
- Making Quote Plugin more efficient
- Different database query in function.php using mysqli
- How do I use the Simple HTML DOM Parser in plugin when other plugin already uses it?
- Will simple function names in a class structure conflict with other plugins?
- Instantiate class to be available to all plugin functions
- How to test nonce with AJAX – Plugin development
- How can i upload images in an admin page?
- Retrieve $_POST data submitted from external URL in WordPress(NOT API)
- Reprinting tags with all attributes
- How WordPress reacts to a lack of memory of the server [closed]
- database sent to a JSON file
- Adding function to Genesis genesis_header [closed]
- how to update and display an option without reloading the page
- How to obtain the current website URL in my theme?
- Filtering a Database Query
- Plugin Generate Unexpected output during activation
- Issue running db create table query from static method
- Undefined method class::construct() when creating a plugin
- Blob file download problem
- Hook called before text widget save
- How can I find the cause of a 500 server error?
- I can’t update my data through $wpdb
- Can’t successfully check if post with title exist in database
- Delete database record using plugin from admin panel
- Using admin-post.php for admin form but it directs me to admin-post.php white screen
- Hooks for post saving make a post-new.php to load latest post’s data
- Adding Additional Variables on Menus Page
- Add row to custom database Table and delete all rows older than 1 day
- Using flickr api in custom wordpress plugin
- Toolbar Hidden in a Virtual Page
- PHP: $_SESSION destroyed after page reload for my custom session
- How to correctly escape an echo
- Using PHP Code Snippets to query a database, $dbconnection->get_results is outputting nothing
- Payment field disappears on custom Paypal plugin
- Adding image upload in tag section – WordPress plugin development
- How to Remove Theme Style CSS inside Custom Plugin?
- Please help! I have a problem with getting wordpress databas
- Creating plugin with front-end pages
- How to Send Pingbacks for all Posts in WordPress?
- I am having errors with checkout on wordpress
- Error establishing a database connection (configuration)
- How can I update the price when someone enters postcode or zip code in woocommerce checkout page?
- 400 bad request admin-ajax file upload
- get Woocommerce product format json for WP_Query
- Update user meta when an external link in admin notice is clicked
- Is there an option to execute javascript file only on plugin activation
- How do I remove an action hook inside a class that is called by another class?
- The plugin generated 225 characters of unexpected output during activation
- Ajax in a class instantiated via shortcode
- Parsing webhook from Shopify in WordPress
- How do I fetch a data from an external database into my wordpress homepage
- Shortcode Works for Logged in Users but Not Working for Guest
- Submit to itself don’t work
- WordPress / PhpStorm / XDebug and plugin_dir_path issues
- direct query to post_meta table
- Send data from plugin to external database
- special characters not supporting in wordpress
- How to set max users to 17.000
- Unserializeing multiple column values that are stored in one database results variable
- Best way to define a database with product codes and back-end support?
- See output of a sql query while plugin installation in wordpress
- Why this plugin is not working?
- Permission error on plugin save
- Querying multiple meta_keys in WordPress SQL query
- Trying to post information from a remote database to wordpress page
- How to execute add_action() function from custom plugin to Crontrol plugin or do_action()?
- PHP Call to External Database
- base64_encode conflict with convert_smilies in wordpress
- Properly process a custom WP REST API request (Authenticate, Authorize + Validate)?
- Login user into magento using wordpress account
- save array of objects with update_option
- Customize create table SQL statement in any WordPress plugin
- Can’t insert into a database wordpress