Questions tagged as 'mysql'

Tagged questions
1
answer

Problems with Django, when installing the cymysql plugin to connect to the database

What I am using: Operating system: Debian 9 Database: MySQL 5.5 Django 1.11.4 I execute the command: python manage.py migrate The following error message is displayed in the terminal: django.core.exceptions.ImproperlyConfigured...
asked by 28.02.2018 / 04:46
1
answer

When trying to insert data into the DB I get an error [HY093]

The fact is that I am trying to insert users through PDO and CRUD and this is generating an error which I can not solve. The error is exactly this    SQLSTATE [HY093]: Invalid parameter number: parameter was not defined File containing...
asked by 22.03.2018 / 12:40
1
answer

Error 1064 SQL in query [closed]

I can not see the error of this statement create table authority ( id int GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) primary key, name varchar(50));     
asked by 12.03.2018 / 11:41
1
answer

Select the records that are not in another table

This is the logic in a project involved many users and a user participates in many projects, I have these tables projects id |name | ---|-----------| 8 |Proyecto 1 | 9 |Proyecto 2 | projects_users id |projects_id |users_id |role | ---...
asked by 26.03.2018 / 00:59
2
answers

Use "WHERE" as a subquery with INSERT

My idea is to be able to insert the sum between 2018-07-12 and 9 days ( SELECT "" + interval 9 day) ) in the column fechaFin of the same table. But first I want to identify a row of T_tarifa with where but it...
asked by 21.03.2018 / 21:29
3
answers

Syntax error, unexpected 'if' (T_IF) [closed]

When I try to run my page, I get this error:    Parse error: syntax error, unexpected 'if' (T_IF) in   C: \ xampp \ htdocs \ Login18 \ Login \ vista \ admin.php on line 143 <form method="POST" action="<?php echo $_SERVER["PHP_...
asked by 04.06.2018 / 15:05
2
answers

Error in PHP Array to string conversion

I'm trying to get an id from a database but the following error has come up: Array to string conversion My code is as follows: <?php require 'funciones.php'; $pwd=md5('pwd'); $respuesta = funciones::login('user', $pwd); if ($respuesta)...
asked by 23.02.2018 / 22:04
2
answers

How to get part of a group of data that is repeated only once and the rest is repeated in MySQL?

It has the following tables: inspection ----------------------------------- Columna Tipo Nulo Predeterminado id_inspection int(9) No machines_numbers int(1) No shift_shifts_id in...
asked by 22.02.2018 / 16:27
1
answer

how can I create this mysql query in doctrine is it possible?

I have this query that I did in mysql SELECT 'formulario' as formulario, 'persona' as persona, 'uds' as uds, GROUP_CONCAT(pg.enunciado SEPARATOR ';') as valores_respuestas FROM preguntas_de_formularios as pdf INNER JOIN preguntas as...
asked by 26.02.2018 / 06:24
1
answer

I want to enter each element of an array as a record of each mysql column

What I want is to enter each element of an array in a field of my database this is my structure example table record has four fields value1, value2 value3, value4 I want to enter the following records that are generated from the following code...
asked by 22.02.2018 / 22:20