Questions tagged as 'mysql'

Tagged questions
0
answers

Application Service connect to external MySQL database of azure

I'm trying to connect wordpress that is running on an Azure Application Service. In the main domain I have an ASP NET MVC application and I configured an application to run wordpress in the same domain. PHP is working normally because I can run...
asked by 12.04.2017 / 00:10
0
answers

SQLSTATE [HY000]: General error: 2053 when I call a Stored Procedure?

I am using Laravel 4.2 and am calling a Stored Procedure from a database on the server. Locally it works fine, but on the server, using the same DB, it gives error. The call is as follows: $result = DB::select('CALL sp_precos_...
asked by 07.02.2017 / 18:21
0
answers

HTML Form Does Not Work on Data Change

The "Insert" and "Delete" forms are interacting with the data from the MySQL database table. Except The form manager-registry that has the "Change" registry function: <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-/...
asked by 08.02.2017 / 12:09
0
answers

Identifying duplications and possible duplicities through scores / ranking

I have a database in mysql that has user information where I have to define what is duplicity or not. Notes: The fields MA_NAME and DATA_NASC are not required. Examples of records: Only sounding the name of the person and the mother's n...
asked by 06.02.2017 / 14:44
1
answer

View Query of Related Tables Mysql

I found some answers on the subject, but I still have some doubts, I will try to be as clear as possible. My Bank Example. I have the following Tables Table Client > id | name | request client_system > customer_id | system_name...
asked by 15.02.2017 / 15:46
1
answer

PHP; MySQL; calculate / insert data automatically according to certain parameters

Good afternoon, I have 3 tables. I want to automatically calculate and insert times in the scales table according to some parameters. ex: 4 days work mornings, 2 days off, 4 days late work (data table schedules id-1 = morning; id-2 = late;...
asked by 06.03.2017 / 20:24
1
answer

Python / MySQL- How to get the id of a table comparing two different

I have the following two tables as you can see in the following image: I would like for example comparing username (at the session level of each user) of each one to remove their id. I have used the following query but it...
asked by 02.02.2017 / 22:54
2
answers

Change the collation and character set of the database, tables and corresponding columns

Some older projects were thought of in their immediate purpose and based on this the databases, tables and columns were prepared in a way limited to the intended scenario. In the sense of updating and adapting to a greater scalability of thes...
asked by 28.02.2014 / 22:51
1
answer

Dynamic form in PHP and MySQL

I need a dynamic form that operates as follows: The page should generate Y textboxes according to a Y number that is in the database. My reasoning is as follows: a. Do the select in the bank to see the number B. I do a while or a for with...
asked by 20.02.2017 / 18:05
1
answer

Button executing a function in js and another in php

Good afternoon, I'm having a question about how I would click on the button to call a function in js and another in php? I have a problem, I want a variable in the $ name case to receive the value that you type in an input, and when I click t...
asked by 20.02.2017 / 20:21