Hej alle, Jeg mangler en command der gør så man kan indsætte flere brugere af gangen i en table.
Jeg kan allerede sætte én ind ad gangen, men dette er ikke nok.
jeg bruger den her nu: insert into tb_users (username, password, ip, email, pemail) values ("USERNAMEHERE", "PASSWORDHERE", "IPHERE","EMAILHERE", "ALERTEMAILHERE")
INSERT INTO INTO tb_users( username, PASSWORD ) VALUES ( "teethisking", "moneytalks" ) INSERT INTO INTO tb_users( username, PASSWORD ) VALUES ( "willsmitkinga", "moneytalks" ) INSERT INTO INTO tb_users( username, PASSWORD ) VALUES ( "danical-1", "moneytalks" ) INSERT INTO INTO tb_users( username, PASSWORD ) VALUES ( "stealinglol1", "moneytalks" )
MySQL returnerede: Dokumentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into tb_users (username, password) VALUES ("teethisking", "moneytalks") INSERT ' at line 1
Der skal nok ikke være flere into i din sql, prøv med: INSERT INTO tb_users( username, PASSWORD ) VALUES ( "teethisking", "moneytalks" ); INSERT INTO tb_users( username, PASSWORD ) VALUES ( "willsmitkinga", "moneytalks" ); INSERT INTO tb_users( username, PASSWORD ) VALUES ( "danical-1", "moneytalks" ); INSERT INTO tb_users( username, PASSWORD ) VALUES ( "stealinglol1", "moneytalks" );
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.