Questions tagged as 'mysql'

Tagged questions
1
answer

Query by data of another MySQL table

I have a question, I want to know if it is possible to consult a data of a table and compare it with another data of another table, I mean, I have a table table which has its id, and another table which has as FK the id of the table of the previ...
asked by 10.11.2018 / 17:33
1
answer

Can you execute an SQL query with another "collation"?

I have a database in which all the tables have the collation: utf8_general_ci and I want a SELECT query to be executed with the collation: utf8_spanish_ci Is it possible without modifying the tables? Can it be with standard SQL? How? The p...
asked by 01.11.2018 / 14:01
1
answer

how to print an echo on a main page

someone can help me I would like the messages to appear below my form so that they do not send me to another page, this is my code. <?php require ("conexion.php"); $nombre= $_POST ['nombre']; $correo= $_POST ['correo']; $contr...
asked by 31.10.2018 / 22:08
2
answers

Slow query MySQL

If you could give me a hand. I am trying to perform a query to get a count of records that are in the activated table that belong to the point of sale 2 and at the same time the total of their records in number, but it takes up to 45 seconds i...
asked by 01.11.2018 / 18:13
1
answer

Add values of two different tables according to the selected id

I have the table "inventory_ticket" this has quantityTicket, and the table "inventory_list", what I want to do is a query that allows me to add the amounts of the two tables but according to the id that is set as fk_inventory in "inventoy_Ticket...
asked by 01.11.2018 / 18:20
0
answers

I inserted the time 3 hours ahead

I have a java.util.Date, which has a particular time (not the current one), and when I insert that Date in my database, it shows me the time 3 hours in advance, in the database I have a field DATETIME type that keeps the time, this is my code:...
asked by 28.10.2018 / 00:08
3
answers

Hide date Datatime php 0000-00-00 00:00:00

I have the following product table idproducto numero_orden modelo tipo fecha fecha2 status resultado the "date" is which the product is registered and "date2" is when the product is delivered or modified, the problem is that when regi...
asked by 27.10.2018 / 03:55
1
answer

Load MySql PHP data on Ionic with Wamp64

I have installed and configured the Wamp64 server and I have managed to load the localhost and phpadmin without any problems. It also accesses projects from localhost, opening the root folder of them and the green symbol is displayed. I cre...
asked by 28.10.2018 / 00:45
1
answer

MySQL How to assign the value of a Foreing Key, using the value of the primary key of another table

I started learning programming a little bit ago and I'm doing a small desktop application. Basically it has two parts, a client's calendar (client table) and a current account for these clients (table cta_currientes) I am using MYSQL for the man...
asked by 29.10.2018 / 18:26
1
answer

Fatal error: Call to a member function query () on null when making a query

I'm trying to do a project with php and mysql in MVC. but I get this error when I want to ask a question. The code of the connection and the query is the following: <?php class dbNBA{ private $host="localhost";...
asked by 24.10.2018 / 05:19