Questions tagged as 'mysql'

Tagged questions
2
answers

Trigger for table optimization

I'm trying to create a trigger that runs the OPTIMIZE command of MySQL. In short, I have a table A and I created a table B that will write a datetime where this value will be updated every time the table A receives the OPTIM...
asked by 19.05.2017 / 20:01
2
answers

Python takes the first column value instead of the last one

I'm trying to get the last record from a column in MySQL but Python only returns "1", it's an auto_incriment ID record. I tried in several ways, in some the whole column was returned to me, in other era it returns "1". Currently the code looks l...
asked by 19.05.2017 / 22:57
1
answer

How do I show a php error in jQuery?

I have one (.html), one (.php) and my jQuery. In my jQuery (I am sending the information to (.php) do the CRUD and etc. The transactions are occurring quietly, however, they are not displaying error messages of type ("Person_id field can n...
asked by 02.05.2017 / 16:08
1
answer

filter data from a small query without spaces

How do I query the database that ignores accents and other special characters? I have the products table that has the name field with the following values: " shoes", "Tennis", "Karaoke and Videokê", etc ... No BD product names a...
asked by 27.04.2017 / 22:39
1
answer

Where in Yii2 do the connection to the database

In the Yii2 Framework application I am using the "advanced" template, I am having difficulty making the connection. Where in the framework is the connection to the mysql database made?     
asked by 28.04.2017 / 00:54
1
answer

Kendo grid XML remote data

I have a WCF that returns the data of a remote MySQL database, the return is a simple XML, I believe that being a simple XML is not populating my kendo grid. I would like an example to mount my return XML and meet the kendo grid requirements,...
asked by 27.04.2017 / 22:55
1
answer

Docker: Upload large sql file

I'm having problems with Docker. I am using Docker and docker-compose to create and configure a web environment quickly and practically. I've been a docker user for some time, but I've never had to upload a large file to a bunch of...
asked by 28.04.2017 / 00:21
0
answers

Table does not display name relative to Foreign Key PHP Table

I need to query the table and return the Date in the first column, Name (FK) in the second column, and other FK-dependent data in their respective columns . I've tried the various forms of INNER JOIN and I can not show the patient's name,...
asked by 27.04.2017 / 02:26
2
answers

Verify that the user is active in the database

I need to make a query if the user is active. Ex. My client logs in to the panel, if my status is disabled, it shows me a message, if my status is active on the page. follow my code <?php // inclui o arquivo de inicialização...
asked by 27.04.2017 / 21:20
1
answer

database modeling in php doubt

I'm going to make a system for a colleague so I'm in doubt as to how I model the database I have a table with tbl_leituraText tbl_leituraPrevious tbl_consumo tbl_fatorCorrecao = tbl_total How do I do this total get the result of this calcu...
asked by 26.04.2017 / 01:21