Questions tagged as 'mysql'

Tagged questions
0
answers

PHP, MYSQL -Trying to get property of non-object

Good evening! I have an error with a query in Mysql, and I'm going around and I do not see it, to see if you can help me. The error is:    Trying to get property of non-object I know the error comes from the query. I've tried wit...
asked by 19.09.2018 / 20:56
0
answers

Sequelizejs include on relating to several fields

I'm trying to relate some tables with sequelizejs. Table 1 has a field with an ID that is used for the relationship and table 2 has 2 fields for the relationship, one is module (string) and the ID for the relationship. The MySQL syntax wou...
asked by 10.09.2018 / 16:01
0
answers

Export stored procedures from MySQL with phpmyadmin

How can I export only the stored procedures from MySQL? Only the tables appear to me ... I tried removing the structure, but neither. I have seen that they do it from here, but I can not find the form. Please omit solutions by linux or...
asked by 07.09.2018 / 13:45
0
answers

Detect error in MySQLi query from PHP, using stored procedure

I have a question, I am developing a small PHP to obtain the data of a query in a procedure stored in MySQL, the problem is that I can not find a way to detect if this query ended in error, to perform the procedure if necessary corresponding in...
asked by 11.09.2018 / 02:26
0
answers

Help in MYSQL Query

Veran I am trying to do a series of exercises in MYSQL, using the SAKILA database, the problem that I have, is an exercise where I am asked for a query where I return the id of a client, the amount of movies not rented and the name of the...
asked by 11.09.2018 / 00:10
2
answers

add hours type time

I have a variable that is 18:00:00 bone at 6:00:00 pm and I want to add another 19:30:00 hours so that the resulting variable is 1:30 pm but the next day. To then generate a condition with that new resulting variable: for example that such hour...
asked by 07.09.2018 / 20:37
0
answers

Error in my registry mod_fcgid: stderr PHP 7

I have an error in my log of logs, when I try to upload the images through the Back-end, I do not load the images and it does not upload to the folders that are addressed in the php 7.1 script and I throw this error "mod_fcgid: stderr thrown in...
asked by 07.09.2018 / 18:44
1
answer

UPDATE from a query with conditions

with this query: SELECT id AS wrcId, st AS wrcSt, detail AS wrcDetail, CONVERT(SUBSTR(detail,(LOCATE('#',detail) +1)), UNSIGNED INTEGER)AS ordenId FROM box_12.warehouse_rc WHERE LOCATE('#',detail)>0 AND id IN( SELECT id FROM box_12.esal...
asked by 08.09.2018 / 00:33
0
answers

how to compare dates and times with php

I want to buy the dates and times for example: invoices received from 8:30 a.m. to 1:30 p.m. which are "on time" if delivered until 6:00 p.m., on the same day, but are "out of time". <?php include('conexion.php'); $query=mysql_query("SELECT...
asked by 05.09.2018 / 18:20
0
answers

PDO query changing table

I need the following query made to a mysql database with the php function "PDO" allow me to send the name of the table from URL parameter and that in turn returns all the data in the table in JSON format consulted with the webservice through a b...
asked by 05.09.2018 / 21:00