Questions tagged as 'mysql'

Tagged questions
1
answer

Error in MySql Stored Procedure

I am new trying to work with stored procedures in MySql this SP that I try to create next is to verify the access of a user to the system ... DROP PROCEDURE IF EXISTS verificarUsuarios; DELIMITER // CREATE PROCEDURE verifica...
asked by 08.12.2017 / 21:23
2
answers

Replace a text part in MYSQL table

With which statement you can replace ONLY part of the text in the table. I have a table that has several entries with a text such that: http://miweb.com/textoquequieromantener and I want it to become this: https://miweb.com...
asked by 21.11.2017 / 12:52
1
answer

Error in SELECT with BETWEEN between a range of dates

My problem is this, I am trying to show a table with the people who must cancel in the month of January or any month, I do it in the following way: First step in a link the initial data via GET <a href="calendario.php?dato=<?php echo...
asked by 08.01.2018 / 02:45
1
answer

Doubt about the behavior of lc_time_names in MySQL

The MySQL documentation indicates that to control the language in which the names of days and months are presented, as well as their abbreviations, lc_time_names must be used. So to establish this configuration in Spanish I do for exam...
asked by 08.01.2018 / 12:43
2
answers

Use variables when formulating query to filter data from a table

I am working with Python and MySQL in a Tkinter application. I'm trying to do a search filter to only show me the entries in my table that correspond to what I entered with the keyboard but I do not know how to set it in the SQL statement. Th...
asked by 26.12.2017 / 19:46
2
answers

Function MYSQL - IF

Create a function that modifies the sale price of a product based on the quantity in stock: a) If the amount is 300, the price increase will be of a value of 5 * / I am trying to do this exercise and it does not work out in any way. I leave...
asked by 27.12.2017 / 00:39
2
answers

SQL query followers

Good! I have two tables ( users and relationship ) and I want to show the followers (users that I follow, but they do not). At the moment I only have to show me the users that I follow and they also show me. Query (Users that follow):...
asked by 19.12.2017 / 17:35
2
answers

Problem with WHERE in temporary field

I have this query that calculates the distance between 2 points given certain coordinates. The query runs well, the problem is the WHERE of the query, this is the error:    Error Code: 1054. Unknown column 'dist' in 'where clause' If I...
asked by 13.10.2017 / 00:41
1
answer

Query in mysql to select the current record depending on the date

They could help me with a consultation I have this query select jornada, min(date_game_large) as date_start, max(date_game_large) as date_end from mi_tabla group by jornada order by jornada where you return this to me: journay dat...
asked by 09.10.2017 / 21:11
2
answers

I do not work fetch_all (MYSQLI_ASSOC)

I am a student and in one of my video classes I realize that my code is broken by using the function fetch_all (MYSQLI_ASSOC) verify the syntax of my code again and again until I have done it practically from the beginning and not yet I can solv...
asked by 03.10.2017 / 00:19