Questions tagged as 'mariadb'

Tagged questions
0
answers

How to save a record with a form in a modal with related tables in Laravel?

I'm trying to save a record in a modal. But in that record there is a relationship. I have a code that supposedly mind does. When I register the information, I do not get an error, but it does not save my record. The function is as follows: i...
asked by 10.10.2018 / 20:53
0
answers

MySQL, MariaDB with Jupyter Notebook

I have a sample database "Sakila" about MariaDB locally with which I practice with HeidiSQL, I would like to know if there is a way to get the same BD with Jupyter Notebook, to be able to practice and comment code from there same and that I stay...
asked by 04.10.2018 / 15:18
0
answers

Update stock with trigger

I have 2 tables, a "Products" table composed of the following CREATE TABLE PRODUCTS ( id_product BIGINT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY, code VARCHAR(6) NOT NULL UNIQUE, name VARCHAR(30) NOT NULL, price FLOAT(6,2) UNSIG...
asked by 23.05.2018 / 01:02
0
answers

Error connector Mysql with mariadb OX

I have Conflicts with when installing pip install Mysql-python it seems that the error is the connector with mariadb and I use the following:    Virtualenv    Python 2.7    Homebrew - > contains mariabd    macO...
asked by 23.05.2018 / 18:52
0
answers

Deadlocks without transactions in MySQL (MariaDB)

I'm having a very strange problem. I'm working on a project with PHP 7.1.17 and MariaDB 5.5.56. The tables use the InnoDB engine. The dynamic is as follows. A user will place an order with an X number of items. When they make this request, th...
asked by 22.05.2018 / 11:53
0
answers

Problem with MariaDB database, InnoDB tables, queries are blocked

Since a few weeks ago I am having problems with one of my databases, all the queries made are blocked and they take a long time to execute, regardless of which table they are made in (Even queries like SHOW PROCESSLIST are slow) This a...
asked by 12.05.2018 / 21:09
1
answer

Problem when making a query with the MATCH and AGAINTS in mysql

I have the following problem is that I want to perform a user search, with the use of match againts and it is the next fragment of code. SELECT pur.url_product, us.Name,us.LastName, pur.fecha_compra, count.Name_country, ci.Name_city...
asked by 26.04.2018 / 21:52
1
answer

Problems with MariaDB, slow query

On the server I have two databases. db production and db_test production, the two are the same in fields, tables, relationships, etc, since tests are done with db_test production. The problem arises when I want to make a simple query in PHPMYADM...
asked by 26.02.2018 / 21:36
2
answers

auto_increment at the top mariadb

I am creating an information system fincareport.com and one of my doubts that I have something thoughtful is that it happens with the tables where the column has id with auto_increment of typo Int reaches its maximum value. In case you chang...
asked by 16.02.2018 / 17:14
1
answer

Why does not this trigger insert anything in any of the two tables?

The syntax does not mark any error which means that I have bad logic, the problem is that I am new in phpmyadmin and I do not know very well if I place the if correctly DELIMITER $$ CREATE TRIGGER VALIDADOR BEFORE INSERT ON validacion...
asked by 07.03.2018 / 20:16