Questions tagged as 'mysql'

Tagged questions
2
answers

How to connect with SQLALCHEMY to a database?

I am doing a test in Python to verify that the database of a machine is active. My problem is that when I connect it gives me the error:    "sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1045," Access denied for us...
asked by 17.11.2016 / 10:59
3
answers

Consult two tables and use of min ()

We start with two tables: Aminales: ID_animal, nombre, especie, incenter 1 Toby 2 1 2 Micke 2 1 3 Jake 2 1 4 Tom 2...
asked by 19.11.2016 / 20:53
0
answers

AppServ phpmyadmin # 2002 - No connection could be made because of the target machine

I'm having trouble accessing mysql through phpmyadmin. I had never had problems, but out of nowhere when I try to connect I jump the following error: #2002 - No connection could be made because the target machine actively refused it. <br /&...
asked by 19.11.2016 / 17:46
1
answer

Foreings Keys in MySQL with other Database

Is it possible to perform FK between fields in different databases? I'm using the IDE MySQL Workbench and apparently the IDE does not allow it, but I would like to get out of doubt.     
asked by 21.11.2016 / 15:48
1
answer

Separate Bill Receipts

I am in a situation where I need your help, I have a sales system made in Javafx (well it is more like a CRM), the fact is that in one of the modules is a billing or sales system, what happens is that for legal issues I have to correct or redo s...
asked by 05.11.2016 / 21:35
0
answers

Google Maps: Android Studio Get the ID of a Marker and move on to another activity

Hello, I am trying from a map to be able to select a marker and send it to a new activity by passing the information of "ID", "lat" and "long", but when selecting it, it sends me to the activity with other information, someone knows how I should...
asked by 31.10.2016 / 20:34
1
answer

Push notifications on android with mysql, php and firebase

I have two tables A and B in MySQL. When a new record is inserted in A, a trigger inserts another one in B. What would be the correct way of doing that when creating that record in B I can execute a query that allows me to send the notification...
asked by 15.11.2016 / 15:01
0
answers

Error editing records in PHP with related tables

I have a small problem when updating my CRUD. To start I have three related tables: Table User, Table location and Table Sepomex ( This last one is the one that provides emails from Mexico ) . The user table has the foreign key of...
asked by 24.11.2016 / 17:13
0
answers

Create new column in event based on query

I want to create a new column every 28th of every month, the problem is that I want it to have a specific name based on a query. This is what I have: CREATE DEFINER='root'@'localhost' EVENT 'evento_mes' ON SCHEDULE EVERY 1 MONTH STARTS...
asked by 24.11.2016 / 16:55
1
answer

Availability datepicker (mysql, php)

Hello, I am making a reservation system in which I need to show on my datepicker the dates that are occupied and those that are not. the reservation table is like this (this summary) CREATE TABLE if not exists reservas( id_reserva integer(...
asked by 03.12.2016 / 23:19