Questions tagged as 'mysql'

1
answer

How to show results with different id of the same query?

I have the following code which I want to show all the people of the same day, I have managed to show it but it shows me only the same id. What can I be doing wrong? $mm=date('M'); $dd=date('d'); $strConsulta = "SELECT id FROM user WH...
asked by 29.08.2016 / 17:56
2
answers

I can not import data from excel to mysql

I have the problem that I need to import data from excel to mysql, however I can not even with code and through the button that is in mysql, I also have the heidi application and it does not allow me to send me errors, I want to review what is i...
asked by 03.08.2016 / 01:22
2
answers

Configure Amazon RDS Database in Workbench

Cordial greeting. I created a database in RDS (Mysql), I did the connection tests, in this case using NodeJS the test was successful, but the database does not have any table, I want to make the connection of the base of data to Workbench to...
asked by 15.09.2016 / 19:05
0
answers

Mysql replication BD

my problem is the following create a replica of a database in mysql, but when I do the incersion to my master server from Worbench or phpmyadmin if the data is updated in the slave. My surprise is that when I insert from a program only they s...
asked by 05.07.2016 / 18:43
2
answers

Select the immediate minor SQL [duplicated]

I need to ask a question in mysql where I have two sales and purchase tables these have the date field and I want to take c.fechacompra < v.fechaventa The problem is that I have many purchase date less than the date-of-sale and th...
asked by 07.07.2016 / 06:48
3
answers

SQL query to get the purchase price before the sale

I have a database (attached BD open BD to import ), in where I want to get a report in which I take out the sale list of each product in invoices, showing how much I sold it and how much it cost me. The problem is that the query I get: SELEC...
asked by 07.07.2016 / 15:48
3
answers

PDO, I did not return results

It's been a while since I touched mysql, for various reasons I had to do it I have a file of tests, when I execute my consula in phpmyadmin it works and returns data, if I place the query in a stored procedure it returns data, but I should not u...
asked by 14.11.2016 / 09:33
1
answer

vb.net Update datatable to MySQL

Good morning: At this moment I am developing a small app in VS.2015 (VB), I have two databases, the first in MySQL and the second in Ms-SQL, both have the same structure, first I make a select and bring the data from a table of each database...
asked by 30.06.2016 / 18:13
0
answers

Help with Medoo framework, mysql and php

require_once 'medo/medoo.php'; $database = new medoo([ 'database_type' => 'mysql', 'database_name' => '#', 'server' => 'localhost', 'username' => '#', 'password' => '#', 'charset' => 'utf8', 'port...
asked by 13.06.2016 / 16:49
1
answer

I try to log users with password encrypted with hash, using password_verify [duplicate]

<?php session_start(); $connect = mysqli_connect("localhost","root","","dbvasco"); if(!empty($_POST["user"]) && !empty($_POST["pass"])) { // $user = $_POST["user"]; //$pass = $_POST["pass"]; $user = htmlspecialchars(mysqli_...
asked by 26.09.2016 / 02:24