Questions tagged as 'mysql'

3
answers

Filter a select, without duplicate SQL queries being returned

The problem is to return a SELECT with only the schedules that have not already been accepted by the user. I am trying to use the table of schedules that have already been accepted, which have both the user ID and the scheduling it has accepted...
asked by 29.09.2017 / 06:01
0
answers

# 2002 - No such file or directory in phpmyadmin [closed]

I'm using Mac OS Sierra (safari 10.0.3), MAMP 4.0.6, phpMyAdmin and netBeans. All was well, I had run the application sometime until the computer crashed. I restarted the laptop and when I opened MAMP again the MySql server indication does...
asked by 08.03.2017 / 17:02
1
answer

How to import / export categories in Magento?

I'm trying to import products and categories from one store to another, but in magento there's only the option to export only the products and customers. Is there any way to do this?     
asked by 07.03.2014 / 19:26
2
answers

How do I get the position of a user individually in a rank, if in the database I only have your score?

With the code below I can display all users, because I put DESC and variable $num and it increments the placement with $num++; . But what if I want to get the / rank from the guy who is logged in ($_SESSION) and n...
asked by 30.04.2014 / 18:24
1
answer

What is the most efficient way to connect an Oracle DB to a MySQL DB [closed]

Having the following scenario: a simple telephony application "writes" to a Mysql BD and a BD Oracle needed from time to time to look for information in this BD MySql. Has anyone done this yet? What would be the best practice? ps Actua...
asked by 26.06.2015 / 18:29
2
answers

import MySQL 1.2GB database

I'm having a hard time importing it into the process halfway. How long does it take to import a 1.2GB MySQL base into a Core 2 Duo with linux?     
asked by 19.06.2015 / 14:29
1
answer

How to make a query with Node.js and MySQL

Hello, I'm starting with Node.js and MySQL , and I have some problems right now. Well, I have a table called users, and I need to make the data request for verification, for example: My site has a registration form, but it needs to...
asked by 11.05.2015 / 03:22
1
answer

How to use the class PDO in this situation

I am using the PDO class to connect the database but in this particular situation I do not know how to use the PDO because in the mysql_fetch parameter I need to put a variable and for what I researched with the class PDO it is not the same way....
asked by 25.11.2014 / 15:57
0
answers

Artificial Intelligence using PHP and MySQL [closed]

I'm looking for information on artificial intelligence using MySQL and PHP only, I did not find much information to guide me correctly, I want to develop a small chat with virtual intelligence capable of responding to the user based on what he s...
asked by 30.12.2014 / 22:16
1
answer

Get the last message of a conversation (GROUP BY)

I have the following query: SELECT cp_mensagem.mensagem, cp_mensagem.dh_envio, cp_projeto.id as id_projeto, cp_projeto.nome as nome_projeto, cp_pessoa.id as id_freelancer, cp_pessoa.nome as nome_freelancer FROM c...
asked by 25.04.2014 / 17:58