Flico
1
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
Flico
2
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.
Flico
4
@syntaxique How to create a structure?
Thanks
304bl
5
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