Questions tagged as 'mysql'

Tagged questions
3
answers

How to check for javascript if a new li tag entered through setInterval?

Is it possible to ask through javascript if there is anything new in a list ul - li ? I'm working with a refresh of serInterval , but it's not very dynamic, why? When the box receives a new message the Scroll Height...
asked by 31.07.2015 / 15:32
1
answer

Search without SUBMIT

I have the following code and I do not know how to make it search without needing to give submit, can someone help me? HTML <html> <head> <title>Data Searching Without Page Refresh</title> </head> <bod...
asked by 01.05.2015 / 18:49
1
answer

Automation of registers (MySQL)

Hello, everyone! I have a problem and I need your help to create a solution. My situation is this: There is a .php page that will be accessed daily by several people, this page will execute a .sql script and return a value ... Only that is wh...
asked by 24.05.2015 / 23:47
1
answer

Help for - Optimizing MySQL

I'm having trouble optimizing my MySQL VPS that I use. I have a plan in RamNode with the following specs: Intel® Xeon® CPU E3-1240 V2 @ 3.40GHz (4 Colors) 4GB Ram 135 GB SSD Raid 10 I'm having problems with slowness in one of...
asked by 30.03.2015 / 17:55
1
answer

Searching for data by MySQL in PostgreSQL

Is there any way to connect MySQL with PostgreSQL, so that MySQL DBMS is used but selecting data that is in PostgreSQL?     
asked by 02.04.2015 / 17:08
1
answer

How to do this sql

I have the following table: table http://i62.tinypic.com/35mjjhz.jpg I use a command SELECT , type: SELECT estudante, conceito_1, conceito_2 FROM estudante WHERE etapa = '1ª' How could I make a single select to get the 2nd and...
asked by 15.08.2015 / 16:39
2
answers

Asynchronous execution problem on node server with Express, MySQL and Socket.IO

I'm developing a project on Node.JS with Express, MySQL and Socket.IO. When the user opens the main page provided by the server, the request must cause data to be read from the database and sent to the client for it to be listed on the page....
asked by 12.08.2015 / 16:27
2
answers

Display field information date - php symfony

I have a table in the database with data of type date, the dates in the database are in this format: 2009-09-10. I'm trying to get them via json from symfony like this: linha 7: date("d/m/Y", strtotime($tbdeliberacoes->getData()))...
asked by 14.08.2015 / 20:05
1
answer

Perform mysql query of two tables via php

Good afternoon, guys. I have a problem that I no longer know how to solve. I have the following mysql query in php: mysql_select_db("banco", $conexao); $resultado = mysql_query("SELECT * FROM pessoa WHERE id = '" . $cod . "'"); whil...
asked by 14.05.2015 / 22:08
1
answer

Query not identifying value

SQL command: SELECT message, count(message) as amount FROM 'messages' WHERE LENGTH(message) >= 4 AND amount < 30 AND message != '#ddd' AND message != 'ddd' GROUP BY message ORDER BY amount DESC LIMIT 3 # 1054 - Unknown column 'amoun...
asked by 08.03.2015 / 17:28