[Important] I have a problem MYSQL

Hi, I have a problem when I add a code in my database (mysql) this function but its adds nothing at all. look

my code mysql :

CREATE TABLE IF NOT EXISTS `users` (
  `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  `bank` int(11) DEFAULT NULL,
  `permission_level` int(11) DEFAULT NULL,
  `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

Does it make me :

https://image.noelshack.com/fichiers/2017/34/7/1503849935-d.png

UP, can you help me pls it si important

Nothing wrong here, the table is empty.

The “CREATE TABLE” syntax will just create the structure for the table. Not actually insert anything.

@syntaxique How to create a structure?

Thanks

you did create the structure with your code as @Syntasu said.

i guess the thing you want to do is to INSERT data into this table , the sql command is :

 INSERT INTO users (`identifier`,`licence`,`money`) VALUES('playerIdent','playerLicence','1500');

ps: why this IMPORTANT tag in the title ? what make your problem more important then all others ?

1 Like