Follow these steps:
CREATE TABLE `users` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1;
- Now click to the GO button. The output that you see is like this:
- To view the structure click on the STRUCTURE button
- And you see this:
Open this link: https://maccacomputer.altervista.org/mcls/register.html