Hi,
A database table can use different engines like MyISAM or InnoDB. To create an InnoDB table, specify that the engine must be InnoDB as below:
example:
DROP TABLE IF EXISTS `test_inno`;
CREATE TABLE IF NOT EXISTS `test_inno` (
`test_id` int(11) NOT NULL,
`test_name` varchar(15) NOT NULL,
`test_value` varchar(20) NOT NULL,
PRIMARY KEY (`test_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
If you do not specify a motor, it will be the default engine that will be used, and the default engine for all MySQL versions of Wampserver is MyISAM.
This is done to avoid problems for beginners, the InnoDB engine being more complex to use than the MyISAM engine.
However, this does not preclude, although the default engine is MyISAM, to create InnoDB tables, just specify it. It is possible to have MyISAM and InnoDB tables cohabit within the same database.
If an installation is found with MyISAM tables, it means that it does not need InnoDB tables, otherwise the engine would have been specified. As I wrote above, you should only use InnoDB tables if you really need them. I think that with this long thread, you understand why.
---------------------------------------------------------------
Documentation Apache -
Documentation PHP -
Documentation MySQL -
Wampserver install files & addons