Questions tagged as 'mysql'

Tagged questions
3
answers

Count rows obtained in a query with INNER JOIN in Mysql

I have a fairly long query, if it works, but I do not know how to use COUNT to get how many rows are in total but not the information itself, query in question: SELECT DISTINCT tbl_docente.doc_cedula, tbl_docente.doc_nombre, tbl_docente...
asked by 24.10.2018 / 03:05
1
answer

How to save my data that I have stored in SQLITE to remote MYSQL (Volley)?

I'm trying to decipher and the truth is that I'm already very burned and I can not figure out how to store my SQLITE list (cart of articles and prices) in a remote MYSQL database (I'm working with volley); The theme is like this first I retri...
asked by 28.11.2018 / 16:40
0
answers

Blank page when creating table

I have a query that the following appears in the logs of the web server and does not show me anything in the Browser:    PHP Warning: mysql_fetch_array () expects parameter 1 to be resource, boolean given The code I have is the followin...
asked by 13.11.2018 / 01:06
0
answers

Export query to csv with php

I have the following code to export a query to csv with php but it does not work, you know how I can get export the query to csv with php require '../conn.php'; $sql = '(SELECT *) UNION ALL (SELECT * FROM senders INTO OUTFILE 'prueba....
asked by 14.10.2018 / 04:48
1
answer

How can I solve this problem in a procedure stored in MYSQL?

Greetings to the community I have this error in the creation of this procedure stored in MYSQL DELIMITER $$ CREATE PROCEDURE insertarnuevo15( IN Vnumfact BIGINT(20), IN Vserfact BIGINT(20) ) BEGIN DECLARE Vnumfact BIGINT(20); SET V...
asked by 11.10.2018 / 04:19
1
answer

Print laravel inquiries

I'm doing a project, I'm new to php and laravel, what I want to do is when I ask a question to be able to print separately already generating a pdf report or opening a view with that data, I have tried everything and I can not . I share the code...
asked by 06.10.2018 / 01:41
0
answers

Problem with singleton pattern Nodejs and MySql

I turn to you to see if you can help me, since I am trying to implement a singleton pattern with node, but I have a problem since I can not generate the corresponding connection with instance, if you can guide me in what I have to change or with...
asked by 08.10.2018 / 05:22
1
answer

Globe orders auto refresh

I'm with the back of a website that is a store, and I'm preparing the typical balloons that are on top of the cart, to notify you how many orders there are new on the web, check them in the database. Script with which I check and print every...
asked by 08.10.2018 / 09:16
1
answer

Error installing flask-mysql

I am new using python3 and I want you to help me because when you insert the command sudo pip3 install flask-mysqldb the following error occurs     
asked by 16.10.2018 / 21:10
0
answers

Take days apart

In the next query the column ' ROUPMJ ' I use it as a date to know when a product is available, but when I came in Juliana I converted it to smalldatetime . I need to take the difference of days to the current day in another column t...
asked by 30.10.2018 / 20:13