Questions tagged as 'mysql'

Tagged questions
3
answers

Error doing a Select in Mysql from C #

public string Usuario { get { return usuario; } set { usuario = value; } } public string Clave { get { return clave; } set { clave = value; } } public string Tipo { get { return tipo; } set { tipo = value; } } MySqlComma...
asked by 21.08.2017 / 21:30
3
answers

Syntax error in mysql script [closed]

$consulta = DB::Select(' SELECT nombrePerfilCargo, idPerfilCargo,porcentajeCargoHabilidad,porcentajeHabilidadCargo,c.Compania_idCompania FROM cargo c LEFT JOIN cargohabilidad ch ON c.idCargo = ch.Cargo_idCargo LEFT JOIN perfi...
asked by 01.03.2017 / 15:23
1
answer

Create an array in PL / SQL of MySQL

I am trying to create an array in MySQL as it is done in Oracle for a procedure ( procedure ), but I can not get it. With this code I am trying: # .... Código .... # DECLARE type array_letras IS VARRAY(6) OF VARCHAR(1); letra array...
asked by 23.04.2016 / 17:52
2
answers

Problem when trying to start mysql from xampp

Hi, I'm new to Linux but I have a doubt when starting xampp, everything starts correctly but when trying to enter mysql like this: / opt / lampp / bin $ mysql -u root -h localhost -p this appears to me: The "mysql" program can be found in...
asked by 02.06.2018 / 18:45
2
answers

Get user id logged in

How about, I'm trying to get the id of the logged in user within a function to be able to create a query (I do not know if the way I show it is correct). What I've been up to now is this: function obtener_notificaciones($conex...
asked by 06.06.2017 / 04:49
2
answers

What am I doing wrong with this code in mysql

Hi, I am a 2nd year student at ASIR and I have an exercise in the creation of tables, data insertion and queries that I must deliver shortly and I have been stuck for more than I review, I do not give with the problem. I appreciate a...
asked by 04.12.2018 / 15:54
4
answers

How to obtain data between a range of dates using MySQL?

I have a question and it is that I want to make a query between two dates by consulting the same column that is Fecha , the following query does me that search: SELECT * FROM view_listservicios a JOIN rel_franquiciaslavadores b...
asked by 10.02.2017 / 17:38
4
answers

select multiple tables in mysql

Good morning, I need to make the following query: I have 4 tables, the first is the main one, in which with id is foreign in the other 3 tables. I need to get the date and description of each of the tables where the id_tabla1 is...
asked by 30.12.2016 / 16:51
1
answer

Problem in consulting BD with related tables

Good morning. I have two tables, sessions and users. A field in the sessions table is related to a field in the users table (the "user" field in both). In the "users" table there will be users that will not have any value in the "num_acces...
asked by 24.10.2017 / 09:39
2
answers

do an if in the where of a select

How can I do an if in the where in mysql I want to validate this $parametro= mujer $parametro= Hombre $parametro= Indistinto select * from tabla s if field s.sexo = $parametro OR if the parameter is called No matter what the who...
asked by 11.06.2018 / 18:17