Questions tagged as 'sql'

Tagged questions
1
answer

Doubt in line commands with sql

Good, I am trying to modify the history box with what I entered, but for that it must coincide with the cc and date, I have a command line in sql but it is not saving me in the database sql="UPDATE Cita set Historias='"+str(AGGH.get())+"' WHER...
asked by 10.07.2017 / 23:44
1
answer

There are no primary or candidate keys in the table referenced

Hi, I have a problem with
asked by 13.07.2017 / 05:08
1
answer

java.sql.SQLException: No suitable driver found for jdbc: mysql // localhost: 3306 / java

package conexion; import com.mysql.jdbc.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class conexion { Connection co; Statement stm; //jdbc:mysql:/...
asked by 28.06.2017 / 01:46
1
answer

Query about SQL INNER JOIN SELECT TOP 1

I have the following question: in a table I have a ID that is related to the other table, but the daughter table has several ID of the table Father then at the time of doing the INNER JOIN brings me N records. I'm tr...
asked by 13.06.2017 / 18:55
2
answers

Fatal error: Call to a member function fetch_assoc () on boolean

I'm trying to make a php page with a login by copying a fragment that a partner passed me but at the time of executing it I skip that error:    Fatal error: Call to a member function fetch_assoc () on boolean. I do not know how to solve i...
asked by 10.06.2017 / 19:35
1
answer

HELP! I'm trying to update a table and send error

Try to update the score field in my dashboard but send me an error:    code: 1093 You can not specify target table 'partitioned' for update in   FROM clause I leave my sentence use noble; update dpartida set score=1 where id...
asked by 22.05.2017 / 00:47
1
answer

Netbeans, java and database. Problems when inserting

Hello, I have this part of the code: public void inserir(Assignatura as) throws GestorException { //TODO codificar el metode inserir String sentenciaSQL = null; PreparedStatement elm = null; try{ elm =...
asked by 06.03.2018 / 18:09
1
answer

Error with query ();

Good morning, I've been with this error for a while and I'm unable to solve it to see if anyone can help me out, I'd really appreciate it! $base=new PDO('mysql:host=localhost; dbname=pruebas', 'root', ''); $base->setAttribute(PDO::ATTR_ERRM...
asked by 06.07.2017 / 10:54
1
answer

Search with stored procedure

Good morning classmates I have a stored procedure to search by code and it works fine but I would like to know if there is a way that by searching for example the 1.5 in addition to looking for those with the 1.5 also drag the record with code 1...
asked by 05.07.2017 / 15:24
2
answers

Laravel Make: Auth with SQL SERVER

Hi, I'm using Laravel 5.2. * with PHP 5.6+, everything is working as it should be when it comes to connections, use the Make:auth to create the login with Laravel, but at the time of registration (or ok using the register by default) give...
asked by 23.02.2017 / 15:43