Best answeres tagged with mysql

3

answers

Can I use MySQL Server and PostgreSQL at the same time without port conflicts or other problems?

Sorry to ask you this but I have hardly any knowledge on this subject. I'm doing a project on Spring Roo and gvNIX using IDE Eclipse. I have seen tutorials that use Postgre SQL to do certain actions and examples how to use GEO components, I n...

asked by 09.05.2016 / 18:12

2

answers

What does the use of (+) mean in an Oracle query? [duplicate]

I would like to know the use of the operator (+) in the following query and what is its possible equivalence in MySQL. SELECT 'E' tipo_envase, DECODE(NVL(pasi_parametro1,'-'),'-','CRE','CON') tipo_pago, vaca_serie, vaca_numero, vaca_l...

asked by 04.10.2016 / 00:05

2

answers

Problems with the following MySQL query

I have a table in MySql with the following data, where id_pers is a foreign key to another table people. -------------------------------------------- id | id_pers | created_at | -----------------------------------------...

asked by 12.09.2016 / 18:59

2

answers

JOINS with chains delimited by commas

asked by 02.07.2018 / 22:01

2

answers

Error executing prepared query

$user = $_COOKIE['c_username']; $filter = filter_var($_POST['buscar_inventario'], FILTER_SANITIZE_STRING); $query = "SELECT Inv_Id, Inv_Ref, Inv_Name,...

asked by 26.09.2017 / 10:47

2

answers

MySQL returns "# 1054 - The column 'person.type' in on clause is unknown"

I have this sentence: SELECT registro_vehiculo.fecha_entrada, persona.nombre,tipo_servicio.tipo_servicio FROM registro_vehiculo,persona,tipo_servicio INNER JOIN tipo_persona ON tipo_persona.id_tipop=persona.tipo WHERE registro_vehiculo.fech...

asked by 08.06.2017 / 14:59

3

answers

Query with LEFT JOIN and LIMIT 1 in the JOIN does not work for me

I have the following 2 tables order and tracking . The structures are the following: Order ( columns and data ): id fecha nroorder description 1 2017-22-01 1000001 Order1 2 2017-22-01 1000002 Order2 3 2017-2...

asked by 24.01.2017 / 21:20

2

answers

Obtain records from the previous day

What friends do I need to return the records of the previous day in CodeIgniter, what is the correct way to do it? Here is the code in my model: public function getOrdenes(){ $this->db->where("fecha", date("Y-m-d")); $this->...

asked by 31.08.2018 / 16:35

1

answer

Apply a WHERE to my SQL statement in a selective and total SUM

guys I have the following conflict: I have the following SQL statement SELECT SUM(monto) AS 'total', SUM(CASE WHEN status_pago = 'PENDIENTE' THEN 1 ELSE 0 END) AS 'pendiente', SUM(CASE WHEN status_pago = 'APROBADO' THEN 1 ELSE 0 E...

asked by 10.10.2018 / 04:43

1

answer

SQL query in MySQL between 3 tables

I have in MySql 3 tables, of which 1 contains the code of the other two tables I try to make a select that shows me the first table and instead of the ID of the other 2 tables show me the corresponding name tabla_1 int id_tabla1 varchar nombre...

asked by 29.07.2018 / 02:52

Questions tagged as 'mysql'