Questions tagged as 'mysql'

Tagged questions
3
answers

Error when consulting with eloquent in laravel 5.6

I'm trying to show data from a table that is related and I'm using Laravael Eloquent for the query. but it generates the sgt error:    SQLSTATE [42S22]: Column not found: 1054 Unknown column 'a.name' in       'where clause' (SQL: select co...
asked by 27.09.2018 / 01:04
3
answers

Consult MySql using indexes

I have a question that I can not solve with Mysql: How can I do the query in this case to obtain the name of the client and the name of the company? I hope for help since I am very involved with this. Thank you!! José     
asked by 05.04.2018 / 17:36
2
answers

Problem with mysql-server password

I just installed mysql-server in ubuntu and when I wanted to enter it asked for a password, which in the installation did not ask me for any password. I need help with this I have been doing more than 1 day doing things and doing nothing. I than...
asked by 09.07.2018 / 02:33
3
answers

How should I relate two tables

I have a question about how to relate two tables. The problem is I do not know what kind of relationship to create for this example. Bearing in mind that in my FUEL table I have 2 records: IDcombustible | Combustible --------------...
asked by 22.06.2016 / 06:19
1
answer

How do I add a query within a CASE in mysql?

I have the following query : select 'preguntas'.'tipo', 'preguntas'.'puntaje', 'preguntas'.'descrip', 'preguntas'.'numero', 'preguntas'.'v_f', 'preguntas'.'seleccion', 'preguntas'.'desarrollo', CASE 'preguntas'.'tipo' WHEN 2 THE...
asked by 06.07.2017 / 06:25
1
answer

Detect DOCTRINE date collisions

I have a table TAREAS formed in the following way: +--------+------------+---------------------+---------------------+ | id | informe_id | inicio | fin | +--------+------------+---------------------+----...
asked by 20.07.2017 / 10:59
3
answers

C #, 3 Layers, Windows Forms - Improve Performance

I need to fill out a datagridview with more than 7,000 records that I get through a method that returns a generic list of objects. My problem is that when I assign it to datagriview.DataSource = LN.ObtainAll () positions; through the load method...
asked by 16.07.2017 / 20:08
2
answers

Error inserting in Mysql. There is already an open DataReader associated with this Connection which must be closed first

What I want is to make a simple INSERT in C #, but I get this error:    There is already an open DataReader associated with this Connection   which must be closed first. Code to be inserted: string QueryCon = "SELECT Id_Categoria...
asked by 23.03.2017 / 19:17
1
answer

Because it does not give the sum of names in MySQL

I have the following: CREATE Table apellidos_completo (Completo varchar (255)) INSERT INTO apellidos_completo (Completo )values ('alvarez') UPDATE apellidos_completo set Completo = 'Rodriguez' + Completo I do SELECT SELECT * FROM apel...
asked by 30.06.2018 / 05:02
2
answers

Get the largest data from different fields - SQL

I have a table with 'STOCK_TIENDA1'-' STOCK_TIENDA2 'AND' STOCK_TIENDA3 ', I need to take the stock of the store that has the most value and pass it to a new variable 'SHOP_MAYOR' would be something like this: I thought of something lik...
asked by 28.06.2018 / 21:35