Questions tagged as 'mysql'

Tagged questions
1
answer

Is it possible to select a table column without entering its name in SQL?

So I was searching but I did not find anything about it, but I need to sort the first and second columns of the table without knowing what they are. My code is this: <?php $preparaNormalizacao=$con->prepare("SELECT * FROM ".$tabelaExtern...
asked by 19.06.2016 / 00:18
3
answers

Registration of text with emoticons

I have a page where a textarea allows the user to paste news. the content inserted there is saved in a MYSQL database to be displayed on the site page in the future. I need that if the user paste in this textarea a text that contains some emotic...
asked by 25.05.2016 / 02:29
1
answer

Configure MySQL connection in eclipse

I would like to know if you have a MySQL connection to Eclipse. Thank you in advance.     
asked by 30.06.2016 / 20:03
1
answer

Saving users in DB

Good morning. I have a login and registration system via PHP, with MySQL database. In this database I have a table with login, password, name and other details of the users. When implementing the Facebook login, I had a question. To sto...
asked by 23.07.2016 / 09:41
1
answer

Multiple MySQL Banks?

Good evening. I'm creating a system in PHP that, say, resembles a virtual mall (several "stores" and each store with its products). For this I need to store data from users, stores, companies, products, schedules, days, orders, payments, e...
asked by 24.07.2016 / 02:07
1
answer

how to use SUM within an ORDER BY (mysql) [closed]

I have the following select in mysql: SELECT DISTINCT a.id, a.unidade, a.posicao, a.nome, a.peso FROM produtos a, produtos_pedidos b WHERE a.id = b.id_produto and b.id_pedido IN (13,12,11) ORDER BY a.nome...
asked by 03.05.2016 / 21:52
2
answers

Remove record in database without giving refresh

Good! I looked for some topics about the same doubt as mine - and I found, but I could not understand how to do it ... I have the following code snippet: $c = array(); $c = buscaUsuario($conexao); while($b = mysqli_fetch_assoc($c)) {?>...
asked by 04.05.2016 / 20:53
1
answer

Problems NodeJS and MySql

Hello I'm having problems with over connection with node-mysql2 using a connection pool. I would like to know if there is a better implementation practice, and what is the best driver to use with nodejs and mysql ? Note: M...
asked by 04.05.2016 / 22:34
1
answer

Remaining Records

It has a function in the Laravel ORM that does LIMIT MySQL . What is Take and Skip . I'm going to make three Owl Sliders on the page, one underneath the other. And the images I'm going to put come from a table in the databas...
asked by 05.05.2016 / 13:20
1
answer

how to return two distinct arrays using union all

$stmt = $this->db->query(" SELECT COUNT(*) AS total, status as tipo FROM tabela1 WHERE status=1 GROUP BY SEXO UNION ALL SELECT COUNT(*) AS total, status as tipo FROM tabela2 WHERE status=1 GROUP BY FAIXA_ETARIA "); $total = $stm...
asked by 08.05.2016 / 23:05