Questions tagged as 'mysql'

Tagged questions
1
answer

How to load MySQL info in Tkinter Entries by double-clicking the Listbox element consisting of two columns

In this GUI there are some Entries that what they do is allow to enter information to be stored in a MySQL database. The Listbox basically displays one of the fields in the database (the name), which in fact is one of the Entry. In additio...
asked by 25.05.2017 / 00:05
1
answer

bring information according to the user logged in mysql

I have a database with two tables, related to each other by ID. The T1 contains the entire record of a primary user, and T2 contains alternative users linked to the main user ID. What I need to do is that when an alternate user logs in,...
asked by 30.07.2018 / 03:56
1
answer

Python does not update the value of the database with PyMySQL

Code : import discord import asyncio from PyMySQL import pymysql # Código sin importancia if message.content.startswith('!points'): clist = message.content.split(' ') if len(clist) > 1: # Código sin importancia else:...
asked by 30.08.2017 / 19:11
1
answer

ERROR IN TRIGGER SQL BY MARIADB VERSION

I have inserted this trigger : DELIMITER // CREATE TRIGGER tr_updStockIngreso AFTER INSERT ON detalle_ingreso FOR EACH ROW BEGIN UPDATE producto SET STOCK_PRODUCTO = STOCK_PRODUCTO + NEW.CANTIDAD_INGRESO WHER...
asked by 26.06.2017 / 05:18
1
answer

How to compare two rows of different tables and get records that meet condition, if not, show null MySQL?

I have two tables with the same fields, but each user inserts different records (there is a range of 78 possible records that each user can insert in their table) what I want to be able to do is obtain in which fields the records are similar and...
asked by 26.06.2017 / 20:08
3
answers

Error logging php in mvc

Good evening everyone, after searching and searching (they are very much sticking with the code and look at things before asking for help), I resort to my first post on this page, because it is something that is bringing me head. I am in the...
asked by 25.05.2017 / 02:57
1
answer

How to assign a null value within a routine in MySQL

My question is how can I do in a MySQL routine assign a field to be null eg: I want to do the same thing that is shown in the line selected in blue in MySQL, that code belongs to SQLServer, How can I assign a null value from MySQL?...
asked by 25.05.2017 / 02:47
1
answer

Error: Column count does not match value count at row 1

Hi, I'm new to php. And I get this error. What happens is that I'm making an order form. But when I fill out the form, instead of adding the data to the order table I get this error: Column count does not match value count at row 1 This is...
asked by 25.05.2017 / 03:21
0
answers

Insert java.sql.Timestamp in MySQL

When I try to insert an object Timestamp of Java in a column of type Timestamp in MySQL I receive the following error:    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column '' f...
asked by 21.05.2017 / 23:46
2
answers

List query in MySQL

I am trying to perform a MySQL query from CodeIgniter, and the query goes fine but I would like to add a field within the select that counts the records that the query returns. SELECT r.fecha_inicio, r.fecha_fin, c.Nombre as cliente FROM reser...
asked by 30.05.2017 / 02:55