Questions tagged as 'mariadb'

Tagged questions
1
answer

Insert in a Mysql table which in turn depends on two other tables

I'm trying to insert into a table called badges_members which in turn depends on two additional tables, one is called badges and the other members . The badges_members table has the following structure: And I am trying to insert...
asked by 23.04.2018 / 19:45
1
answer

In MySQL the general_log registers queries that can not be executed?

In MySQL the general_log can register for example a UPDATE in the log even though the server is configured only in read mode read_only ?     
asked by 22.05.2018 / 12:59
1
answer

Codeigniter - transactions stored procedure

Is it possible ?, they work as they should? do transactions by invoking store procedure from query builder ?, that is, the changes are reversed with rollback in case of error ?, thanks. $this->db->trans_start(); $this->db->quer...
asked by 13.05.2018 / 07:44
2
answers

Error sending data with prepare and mysqli

I am trying to send information to my database after making two queries, the first if the user already exists and the second if the email already exists subsequently made the "upload of information" to my database with my sentence prepared This...
asked by 03.04.2018 / 04:12
1
answer

How can I get rid of this UNION?

The truth is that for a long time, in a system that I have, there are three tables that are used to save settlements: At the request of the user, these tables must be duplicated in their final version and their temporal version, for which th...
asked by 09.03.2018 / 16:45
1
answer

Execute If within a For Each

I'm doing a project using: Php, css, html, mariadb "mysql" I am trying to execute an If statement within a ForEach loop, but the "if" only executes in the first execution of the Foreach, in the rest everything is executed, except for the If....
asked by 25.09.2017 / 18:45
2
answers

Error: "You have an error in your SQL syntax"

The error that returns to me is: A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0) VALUES ('admin@hotmail...
asked by 04.06.2017 / 03:29
2
answers

Does not show me bd in console

Good afternoon The question is simple, I do not know how much the answer is I have these databases in phpmyadmin : But when consulting them by console, it only shows me these: Does anyone know why you do not show me the othe...
asked by 16.05.2017 / 22:19
1
answer

SQL Error BLOB Syntax

I am using XAMPP MySQL and I have created a table to which I have named users and within it created the following: userid: INT type PRYMARY KEY AUTO_INCREMENT name: of type VARCHAR (20) photo: BLOB type When I try to save the photo in...
asked by 30.05.2017 / 02:45
1
answer

MariaDB does not recognize a field name in a table when using load data infile

I have a small problem with MariaDB: I have a table with several columns, one of which is called fecha_hora . When trying to insert data with load data infile , MariaDB tells me that it does not recognize this column. I deleted an...
asked by 25.11.2016 / 23:44