Questions tagged as 'mysql'

Tagged questions
5
answers

Query grouped with different counters

Good afternoon, I hope you are well. I have a problem with a SQL query that paints to be simple but I think it is not, I have the following table with this information: id pais sexo == ======== ==== 1 Venezuela F 2 Venezuela F 3 Venez...
asked by 06.12.2016 / 22:12
2
answers

php - Problems inserting MYSQL data

Good, I am trying to insert data from my form, but when I press the submit button it sends me the message of: "Connection made" What is the message of my php file of connection , nothing more. The code to insert I have it in another fil...
asked by 16.06.2016 / 05:50
3
answers

When to use MyISAM and when InnoDB?

When choosing the MySQL storage engine, when should I use InnoDB and when MyISAM and what does the choice depend on? Is it any higher than another? In my case I have 8 tables, some of half a million records, other small and all are related in...
asked by 16.03.2017 / 13:33
2
answers

DATE () vs DATE_FORMAT () in MySQL

The doubt came to me by answering a question here on Stackoverflow. The aim was to obtain only the date (without the time) of a column DATETIME , to compare it using BETWEEN . Obtaining that date can be done: Using DATE...
asked by 25.10.2017 / 12:49
4
answers

Query in MYSQL DATETIME ()

I have a database in which the packages of some clients are stored and the date of creation of said package. I need to check out how many packages a client makes each day in a month. I've tried with SELECT distinct fecha_creacion FROM paque...
asked by 25.10.2017 / 11:31
2
answers

Export mysql table in CSV

I am trying to export a table from mysql to csv. This I have already achieved but in the csv file the fields of the exported columns do not appear. The code I have used is the following: select Nombre,Direccion INTO OUTFILE 'prueba.csv'...
asked by 08.06.2016 / 22:47
3
answers

Help with the logic of a query for MySQLi

Greetings guys I have the following sentence: $query = "SELECT * FROM pedidos WHERE usuario = '$usua AND status_pedido = 'ESPERANDO' "; Just as it works perfectly but I would like it to also select if the condition is met status_qualifie...
asked by 10.10.2018 / 16:10
1
answer

Identify null values in Laravel and MySQL

I need to make a query to update a data from the relation of two tables, where if the given date (variable $fecha_actualizar ) is the same for perfiles_evento and to check, update the stage in which it is to 4, I think the query is...
asked by 29.06.2018 / 16:32
1
answer

Query to have only the names of records

I need a query that shows me a table name in which are last names and names separated by a comma example: Martinez Nutero, Juan Alberto and I need you to only show me the value from the comma. I tried this query but it does not work fo...
asked by 14.09.2016 / 22:56
1
answer

Does anyone know how to send a message by whatsapp using PHP? [closed]

Good, I'm in a problem that I've been looking for for several days, if you can send a message by whatsapp using PHP, I do not know if there is a php class for it, something I read with an unofficial WhatsApp API, but I do not achieve make it wor...
asked by 17.05.2016 / 08:22