Questions tagged as 'sql'

My problem is this, I have a BD and a Java application, we forgot the BD, let's focus on the App, I created a connection to a database that SI works, very all right. Now I propose to create a method in JAVA that returns an integer, the probl...

$sql = "INSERT INTO USUARIOS (partidas,partidas_ganas,turnos) VALUES ((select partidas FROM usuarios WHERE nombre like='$nombre') + 1, (SELECT partidas_perdidas FROM usuarios WHERE nombre LIKE = '$nombre') + 1)";     

Could you support me? I need to insert 100 records at the same time in a user table and I know that it can be done through a query, unfortunately I do not know much about SQL to do so and insert one at a time would be very slow. The table con...