Questions tagged as 'mysql'

Tagged questions
0
answers

LogIn, Connect a Local DB to a mobile BD, synchronize data manually

I have a school project where I am asked to create a login by consulting a mobile BD, this database must be connected to a local database with a button that updates the information of the Mobile Database in the local database, I leave a diagram...
asked by 13.05.2018 / 05:19
1
answer

Problem with entering data with hibernate in java

When I enter a data via jsp with hibernate and mysql, this error is thrown at me:    Exception Report Type       message Execution of the Servlet launched an exception       description The server encountered an internal error that caused...
asked by 13.05.2018 / 03:39
0
answers

How do I print data in an orderly pdf if I am using FPDF through a mysql query?

<?php require('fpdf/fpdf.php'); $consulta= mysqli_query($consulta, " SELECT ventas.nrofactura, fecha, cliente, rfc, ccresponsable, nombre, precioventa, cantidad, direccion FROM detalleventas INNER JOIN productos INNER JOIN ventas WHERE ventas...
asked by 11.05.2018 / 00:46
0
answers

Temporary data table in memory of the client computer

I am a Delphi programmer and I know that the clientdataset creates temporary tables with different functions so that I do not have to consult the database server for each filter I made. I searched how to do the same in php, that is, if we do...
asked by 11.05.2018 / 10:12
1
answer

Do a keyword search with mySql? I need to make the query query

I need to make a search engine that searches for keywords in my database. I have a word field where I keep all the keywords I want for the product. For example I have a product with keywords 'red shirt', I need the user to put those words in...
asked by 10.05.2018 / 20:15
0
answers

Problem with MariaDB database, InnoDB tables, queries are blocked

Since a few weeks ago I am having problems with one of my databases, all the queries made are blocked and they take a long time to execute, regardless of which table they are made in (Even queries like SHOW PROCESSLIST are slow) This a...
asked by 12.05.2018 / 19:09
1
answer

Total count add sql [duplicate]

I want to show the total registration and at the same time add that total SELECT t.empresa, COUNT(t.idespecialidad) AS count, e.nombre AS nombre_especialidad FROM tickets as t INNER JOIN especialidad AS e ON t.idespecialidad...
asked by 10.05.2018 / 19:49
0
answers

Yii I do not work the internal pages

I have a problem with internal tabs that can not be found but the routing is correct. I do not know why this error is due to the fact that only the Home view works, I would appreciate any support. this is a fragment in the modules file...
asked by 09.05.2018 / 19:09
0
answers

historical problem (txt) with loadata in mysql

I'm reading a history in a txt (there are 6 million records, that's why I only show a part) This way it is loaded in a table but I am interested in having the oldest date with its corresponding values ( estatus , token , suc...
asked by 09.05.2018 / 18:50
0
answers

Show information that is not in another table

I am trying to bring data that is not found in another table with codeigniter My model: public function getEntradas($proveedor){ //Mostrar entradas del proveedor que no estan en pagos $this->db->select('...
asked by 10.05.2018 / 00:24