Questions tagged as 'mysql'

Tagged questions
0
answers

Comparing three column records in a mysql table

I make a query in COL1 which has the total of rows and then I make a query in COL2, but it is less than COL1. How do I get COL2 to return the IDs that are the same as COL1 so that they are side by side according to the ID of COL1 so I can see wh...
asked by 31.05.2018 / 16:06
1
answer

Check if a username already exists in angular database 2 + php

I need to check if a user already exists before registering. I have the following methods: register.component.ts: import { AlertService } from './../alert.service'; import { Component, OnInit } from '@angular/core'; import { Router } fro...
asked by 31.05.2018 / 22:14
3
answers

Filter data with INNER JOIN - MYSQL

Good afternoon, I'm new to the group and wanted to know where I'm going wrong ... I have a search on the database as well ** SELECT * FROM Users INNER JOIN naturezanegocio ON Users.emaillogin = naturezanegocio.emaillogin AND Users.paisor...
asked by 07.06.2018 / 18:13
0
answers

Select with case inside (date)

Well, I have a problem with my select. I need this select to count how many estadoVisu has, but if the date is nula inside the case it should have a subquery inside checking if estadoVisu is VisualizadoTec2 or Visu...
asked by 31.05.2018 / 06:40
0
answers

Limit of rows database Joomla

Good afternoon, I'm trying to limit the display of database results to 200, but when I use the "LIMIT 200" command nothing happens: Follow the code below the connection: <?php if(!defined('_VALID_MOS')){ define('_VALID_MOS', 1); } if...
asked by 04.06.2018 / 18:18
0
answers

Difficulties in trigger creation in MYSQL

You are giving the error # 1064, I do not know what I do, please help me ... CREATE TRIGGER comissao ON tb_Pedido FOR INSERT, UPDATE, DELETE AS BEGIN DECLARE v_codFuncionario INT DEFAULT NULL; DECLARE v_...
asked by 06.06.2018 / 01:15
1
answer

Error creating Trigger with more than one table

I'm having trouble creating a Trigger that modifies more than one table. DROP TRIGGER IF EXISTS vendedor_pago; DELIMITER $$ CREATE TRIGGER vendedor_pago AFTER UPDATE ON parcelas FOR EACH ROW BEGIN UPDATE vendas, comissao, parcelas...
asked by 05.06.2018 / 22:45
1
answer

Virtual column extracted from a json in MySql does not get NULL

I have a virtual column named '_cpf' which is extracted from the '_document' column in json. Here is the following query: CREATE TABLE 'user' ( '_document' json DEFAULT NULL, '_id' varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract...
asked by 05.06.2018 / 23:33
1
answer

Problem inserting special characters in Mysql

When I enter some information in Mysql through the form on my system everything is wrong in BD, the characters ç ~ '^' buga everything, but manually entered in phpmyadmin. In HTML I put the meta charset UTF-8 tag and in php ini speech charset UT...
asked by 05.06.2018 / 17:46
0
answers

Mysql database, strange characters

I use a database online, and the tables, which I saved, I noticed that the accents, made them all confused, for example. SUMMARY ANDRÃÆ'à ¢ â,¬Å RUA SÃÆ'à † â € ™ THE DAMIà€ ™ O, JOÃÆ'à † â € ™ O help, how can I solve this without lo...
asked by 29.05.2018 / 22:09