Questions tagged as 'mysql'

Tagged questions
2
answers

Format date on MySql

When executing the following statement, the error occurs: Unabled to convert Date/time . I try to show the information that this query brings in a DataGridView . SELECT codigo, nombre, marca, precio, CONVERT(fechaexpira, DATE) FROM...
asked by 23.08.2016 / 20:38
1
answer

Group by by date using left join mysql

I am trying to make a query that involves 3 tables, post, comments and likes. I need to know the date of the post and the title of the post, the number of people who have commented on the post and the number of likes for each person, the detail...
asked by 28.02.2018 / 20:35
1
answer

Sum of the hours between two dates

I would like to know how I could get the hours between date_ini and end_date EQUIPO TIPO_MANTE FECHA_INI FECHA_FIN Horas TOTAL LAPTOP A 12/20/18 12/21/18 24 50 DESKTOP A 12/20/18 12/21...
asked by 24.12.2018 / 18:07
1
answer

MySQL - Detail with a query

I have a database called messaging , consisting of 3 tables    Table - users Here the personal information of each user is stored. ______ _________ _________ ________ | idUs | nomUs | emailUs | codeUs | ────── ───────── ─────────...
asked by 18.01.2017 / 07:59
1
answer

Differences between "identifying" and "non identifying relationship"

I started using the Workbench and was doing a database model, but those two relationships appear in the tables, what is the difference? "identifying": "non identifying relationship":     
asked by 05.06.2017 / 21:34
2
answers

Is it possible to maintain the text format of a textarea by inserting it into MySQL and recovering it?

I'm making a website that has a news section. The page will have an administrative sector in which people (with almost no knowledge of computers) will write news. The idea is that the news is formatted (by format I mean the line breaks). H...
asked by 04.11.2016 / 01:16
1
answer

mysqli_fetch_object () expects parameter 1

I have a problem with my php code that sends me the following error    "Warning: mysqli_fetch_object () expects parameter 1 to be   mysqli_result, boolean ", This is my php code where I get an error. <?php include("connecti...
asked by 25.08.2016 / 16:49
2
answers

Alternative column to use in a JOIN in MySQL

I have a table called liturgia_calendario with the following structure: calendario_id ff_yy ff_mm ff_dd id_liturgia pre 1 2018 06 01 198 0 2 201...
asked by 02.06.2018 / 14:10
2
answers

I would like to apply for phone numbers in MySQL

I need help As in SQL you can format phone numbers, with a N_Cel varchar(8) check((N_Cel)like '[2|7|8|5][0-9][0-9][0-9][0-9][0-9][0-9][0-9]') NOT NULL, I want to do the same in MySQL but it makes a mistake, could someone explain to me?...
asked by 29.06.2018 / 23:39
1
answer

How to get the last registration if I use group by

I need to list all the users who have created a vote, a user can create many votes and that user belongs to a company. I'm grouping them because I need the last vote per user, but I need to order the voting in progress first (4) and then the...
asked by 08.10.2018 / 03:19