Questions tagged as 'mysql'

Tagged questions
1
answer

Measure distance from multiple points using Google

I'm working on an app where the user can see the establishments closest to him. In the bank I keep latitude and longitude, and in mobile I retrieve the user's position. I made a LIMIT in SQL to bring paged this data by ordering by the shortes...
asked by 22.01.2018 / 13:41
1
answer

Compare two totals using LEFT JOIN in MySql

I have two tables: Venda and ProdutosVenda , where the Venda table has a field named 'Co_Id' and the ProdutosVenda , which stores the products of that sale, has a field called 'Id_Reference', which is the reference of t...
asked by 22.01.2018 / 14:13
1
answer

SQL query syntax

Can anyone help to produce the SQL query syntax to get the result below? I need all the values in the "Budgets" table to be listed, but at the same time that all the categories are listed as well (even if you do not have budgets registered fo...
asked by 22.01.2018 / 02:21
1
answer

Error uploading mysql container (with volume)

Good Night. I'm learning docker and I can not upload a MySQL container when I add a volume mapping . Follow the errors and the docker-compose.yml file below. I'm using the docker toolbox in windows 10. mysql_teste | 2018-01-21 22:37:02 7ff00...
asked by 21.01.2018 / 23:40
1
answer

Google API does not auto complete in the bank

I'm using the Google API on an html page to grab the user's location. When the user types EX: Bon Street (options will appear for him, for example he clicks Bonnard Street ...) in the text field fills in all the missing content. But at the time...
asked by 22.01.2018 / 10:34
0
answers

Is there any way to set up a CRUD with boostrap, javascript and node.js?

Hello everyone, I've been studying programming for a year now and I'm having trouble finding a way to build a crud that has javascript, Bootstrap and node.js? I did not find any tutorial to help me in this case, until I know how to create the sys...
asked by 02.02.2018 / 04:44
2
answers

Problem in SQL Query

I'm developing a C # application and I use a BD in MySql. In a part of the system, I need to increment the inventory of a particular product, test the command in the Workbench and it worked fine, but when I execute this command inside visual stu...
asked by 02.02.2018 / 14:04
1
answer

Import database without table data directly by Mysql

I need to import a very large database into Mysql. For phpmyadmin almost stopped the server. So I tried directly through Mysql using the command: source /var/www/html/sistema/basedados.sql Ok, I was able to import, but with all the data of...
asked by 20.01.2018 / 16:55
0
answers

Python: Redeem html mysql text

I'm using Bottle.py for study and testing ... I'm having a problem retrieving a database information. The table looks like this: create table if not exists postagens ( idPostagem INTEGER NOT NULL auto_increment PRIMARY KEY, tituloPosta...
asked by 28.01.2018 / 04:47
0
answers

Connect Heroku application to an external (Mysql) database

I'm testing a laravel build in Heroku, but I wanted to use an external database that I have on a shared server. I have already set the environment variables and also added the variable DATABASE_URL = mysql: // username: password_db @ host: 33...
asked by 22.01.2018 / 19:30