Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Linting is disabled for this query because it exceeds the maximum lengt

Next I have a problem with mysql which is as follows when I am going to add an image in the text editor of my content manager, this image is converted to base64, this editor is summernote, however the code is added by half on the bank in the tex...
asked by 22.02.2018 / 19:28
0
answers

Generate random characters in SQL

Hello, I have a question in PHP My Admin that is as follows: I have a table that I need to put as a default value in a column a random value. Could anyone give me a light on this? I know how to do TRIGGER in PHP My Admin, the problem is...
asked by 19.02.2018 / 21:01
0
answers

Error Connecting to database?

I'm trying to make a connection to a database and giving the following error    "ERROR: SQLSTATE [HY000] [2003] Can not connect to MySQL server on   '167.114.173.210' (13) " And I have a "Navicat" program and I can access this DB, just t...
asked by 12.02.2018 / 03:55
0
answers

phpmyadmin icons do not work

I installed phpmyadmin and I have the problem of the icons / images, just as everything in the themes folder does not work. How much the permission of this folder stays the same as others drw-r-r-- 11 root root 4096 Feb 5 22:48 templ...
asked by 15.02.2018 / 15:41
1
answer

Query works in phpmyadmin, but does not work in PHP

I'm trying to make a query via php in Mysql, but it's not working in PHP, but it works in PHPMYADMIN. $check_in = strtotime($arrival); $check_out = strtotime($departure); Queries I've tried in PHP ... $query = "SELECT * FROM wp_st_availab...
asked by 15.02.2018 / 17:26
1
answer

Synchronization of tables PhpMyAdmin

I needed a help in PHP My Admin about synchronizing fields in different tables and in the same database. For example: Database: Test Test Table1 columns: - col1 - col2 Test table2 columns: - col1 - col3 It needed that, when...
asked by 15.02.2018 / 20:05
0
answers

Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I changed the host to Locaweb, and after I changed I made my database and got the confirmation, the page was working normal in the Hospedameusite but because the change stopped working and is now giving the following error:    Can not connect...
asked by 25.01.2018 / 16:52
4
answers

Using MySQL to create a Select that looks for words "together"

In MySQL how to create a select that looks for words "together". For example: SELECT pessoa FROM tabela WHERE pessoa like '%josedasilva%' But this way it does not return anything. Because it is registered as "José da Silva". I would like y...
asked by 17.01.2018 / 20:13
1
answer

I have two entries grouped but only one is changed in the update

I've mounted an update by grouping the presenca field that should change from two arrays to one repeat loop, follow query : UPDATE acessos AS a JOIN ( SELECT usr_id, presenca FROM acessos GROUP BY presenca...
asked by 09.01.2018 / 01:29
0
answers

Sum of hours obtained through a query in mysql

SELECT TIMEDIFF( atendimento_ticket.close_atendimento, atendimento_ticket.open_atendimento ) AS duracao FROM atendimento_ticket WHERE id_tec = '$id_tec'     
asked by 27.12.2017 / 20:53