Questions tagged as 'mysql'

Tagged questions
0
answers

How does this SQL code work?

I was studying SQL and found the following question: What is the result of the following query: SELECT SUM (V2.VALOR - V.VALOR) FROM VIAGEM AS V INNER JOIN VIAGEM AS V2 ON (V.VALOR = V2.DISTANCIA / 100) And the table: Viagem Val...
asked by 14.02.2018 / 19:15
0
answers

Possible reading of data in firebase

Good afternoon  I would like to ask a question regarding the Firebase Realtime Database.  I have some data stored in my firebase but wanted to make a compilation or reading them through an HTML page is possible and how to do     
asked by 22.02.2018 / 14:24
0
answers

Mysql + Python (Save Login in Variable to make Connection)

import os import getpass import mysql.connector class AcessDataBase(): UserName = "" PassWard = "" DataBase = "" def LoginDB(self): self.UserName = input("Username: ") os.system("cls") self.PassWard = getpass.getpass("Passwa...
asked by 08.02.2018 / 12:39
0
answers

Website - Edit a contact (form)

I'm creating a website where each user has their contacts. If a contact is added, it can also be edited. But I'm getting two errors that say:    Undefined variable: with e Fatal error: Uncaught Error: Call to a   member function close () on n...
asked by 07.02.2018 / 23:37
0
answers

I can not connect to the database

Hello, I'm studying php, but when it comes to connecting to DB, it does not connect at all, the bank names are correct, I've imported the bank, and does not anyone know what it can be? > Connection to the Database <?php /** * clas...
asked by 08.02.2018 / 04:04
0
answers

What is the best way to display an item classification without overloading the system?

Hello The site I am currently working on was developed using Laravel, having MYSQL as the database. The base currently has 500 thousand players registered. Each player has a score. Currently the system shows the top 50, so I make an appointme...
asked by 08.02.2018 / 01:46
2
answers

Why are you giving this error and how do I reverse it?

I have this table: create table lagoa_azul( id_lagoa_azul int not null auto_increment, sem_epi int not null, p1 smallint, p2 smallint, p3 smallint, p4 smallint, p5 smallint, p6 smallint, p7 smallint, p8 smallint, p9 smallint, totOvos int,...
asked by 07.02.2018 / 21:58
0
answers

Trigger to update several lines MariaDB

I'm trying to create a trigger to update the stock value of the products table, according to the status of the note. ex. on the note have 2 products 1 | Qty: 3 2 | Qty: 5 When the status is updated to "0" which means that the note ha...
asked by 08.02.2018 / 15:27
0
answers

Problem opening Xamarin connection with MySql

I'm a beginner in Xamarin , and I'm having a hard time connecting to MySql . I'm trying to use a simple connection just to test, but it returns an error when I click connect. Unhandled Exception: System.TypeInitializationException...
asked by 08.02.2018 / 18:55
1
answer

Crud with Edit within the table itself and search for data + database

Could someone tell me a way to do a CRUD with editing by the table itself? I want to be able to do this, but I do not know how to do it. the person enters the page where the data is displayed click on the table cell, edit the wrong data and R...
asked by 08.02.2018 / 15:59