Questions tagged as 'mysql'

Tagged questions
0
answers

Mysql Connector C ++ 1.1.9 conflicting declaration "typedef long int int32_t"

After all the morning investigating, I still do not solve this problem. I am trying to link mysql and codeblocks 16.1 and a type declaration error occurs, the declaration is repeated in 2 files .h in config.h (library that comes with Mysql co...
asked by 03.10.2017 / 21:16
0
answers

Doubts about the management of purchases and sales of products in MySQL

My question is that if I have a product table and an inventory table, it will save the amount of product that I have in total, but in the product table will keep each product regardless of the same? I mean, if I buy 50 soft drinks and X the supp...
asked by 02.10.2017 / 17:54
1
answer

invalid attempt to read when reader is closed

I'm having problems with an exception thrown at me by an application I'm developing with c # and MySQL. The exception is: "invalid attempt to read when reader is closed." and it happens to me when I enter for the second time a code that I should...
asked by 29.09.2017 / 17:10
1
answer

Count MySQL occurrences

This would be my table called numeros with its columns called N1 N2 N3 N4 and their respective numeros in each column. What I can not do is to tell me how many times each numero came out in each column. EXAMPLE...
asked by 30.09.2017 / 10:05
1
answer

SQL query in WD_usermeta DB

I want to make a query in the Wordpress database because I am creating a page that does the following, according to the user who is registered, this has some referrals, the referrals when registering there is a custom field that is a sponsor whi...
asked by 03.10.2017 / 09:06
3
answers

Help query MySql

I'm trying some consultations and I can not get one to work for me. I need to get the list of orders each of which with the name of the associated carrier . I only have 8 orders so I should have 8 results but it returns a lot more ... SQL...
asked by 03.10.2017 / 11:51
1
answer

Error creating store procedure in MariaDB

I'm creating a procedure stored in Mysql 01 CREATE PROCEDURE prcGrabarLocationGPS ( 02 _latitude DECIMAL (10,7), 03 _longitude DECIMAL (10,7), 04 _speed INT (10), 05 _direction INT (10), 06 _distance DECIMAL (10,1), 07 _date TIMESTAMP,...
asked by 28.09.2017 / 22:01
1
answer

Messages in MySQL

In PostgresSQL I could raise exceptions from a triguer with the Raise Exception, so I ask how can I display a message from a trigger as it did in postgres with the Raise Exception in MySQL?     
asked by 01.10.2017 / 22:06
2
answers

Problem retrieving datetime

I have a problem retrieving the dates in my Rest API. I insert a data and the datetime is automatically filled in my BD. for example. 2017-09-27T23:16:46.000Z this value that is generated automatically and I can see it with mysql wo...
asked by 27.09.2017 / 22:40
1
answer

Error downloading the xml file

<?php error_reporting(E_ALL); // Datos de conexión a la base de datos require('mysql_connect.script.php'); $conn = mysql_connect("localhost","root",""); mysql_select_db(""); mysqli_set_charset($conexion,"utf8"); //...
asked by 27.09.2017 / 23:13