Questions tagged as 'mariadb'

Tagged questions
1
answer

Error in Trigger "AFTER INSERT ON ..." from MySql

I'm having problems with creating a trigger in mysql, but I do not know why it's causing me an error. The table in which I want to insert once the trigger is activated is the following: CREATE TABLE 'reportes' ( 'id' int(11) NOT NULL, 'tip...
asked by 26.05.2018 / 07:50
1
answer

MariaDB choose storage engine

I was reading about the different storage engines supported in Mysql. The most known ones seem to be InnoDB and MyISAM, but with MariaDB it seems that there are more options, the issue is that I do not know which one to use, so I am resorting to...
asked by 12.03.2018 / 23:27
0
answers

Open port 3306 iptables

I am setting up a virtual machine as a database server on a CentOS 7 and I want to open port 3306 to connect from the host machine. The rule that I have set is the one shown in the capture However, it does not allow me to connect, wh...
asked by 19.02.2018 / 20:42
1
answer

Replicate database taking into account possible changes in the source BD

Good day, I need to "replicate" some fields of some a database, the problem is that I must contemplate the fact that some data in the source DB are modified to update those in the new DB and not generate a new record. In my first load of data, I...
asked by 13.11.2017 / 17:13
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

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
2
answers

Laravel error Primary Key

Good, I'm introducing myself a bit in Laravel and I'm passing a code that I have in pdo, I'm with the creation of tables and tells me this error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; che...
asked by 01.06.2017 / 23:59
1
answer

(SQL) perform Inner Join via conditional

I am trying to make a query of three tables in my MariaDB of a gym: Clases Instructores Usuarios What the query asks me is the following:    "Know which is the class that has more students and display" class ",   "Full name of the instr...
asked by 03.05.2017 / 18:18
0
answers

Problems with Mariadb when creating table from java

Good morning, I can not find the solution to my problem. From java, I create a table in phpmyadmin and insert data, which apparently does it well, I do not get any errors, however I find that if I want to enter data in a column that I created...
asked by 01.03.2017 / 21:31
1
answer

How to prevent mysql from always connecting to localhost?

I'm trying to do a mail service and I'm using dovecot but at the moment of wanting to login as a dovecot user it always throws me the same error posftfix @ localhost does not exist which is true because it is not using my domain. Try to enter...
asked by 23.11.2017 / 20:07