Most voted "mariadb" questions
Mariadb is a database server that offers functionality and replacement for Mysql. Mariadb is built by some of the original Mysql authors, with the help of the large community of free software developers and open source software.
Learn more…111 questions
Sort by count of
-
0
votes1
answer91
viewsHow do I pass the COUNT attribute in my sql string, since "COUNT" is a reserved php word?
Follows the string of select: $resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";
-
0
votes3
answers525
viewsLogin without differentiating between capital letters and minusculas?
I am making a login system. In the table is registered a user "User01", when the customer will log in if he puts it in the field "user01" I want it to be valid anyway. Here’s the code I’m using.…
-
0
votes1
answer26
viewsimporting backup by Mariadb terminal
Yesterday I was doing a test in Postgresql of insertion and backup import and export and Postgresql has an SQL import command as follows: psql# \i backup.sql Has something to do with that in…
-
0
votes1
answer39
viewsSyntax error when executing database query
<?php class train{ var $units; var $Units; var $cl_units; var $db; var $recruited = array(); function train(){ global $cl_units, $db, $arr_farm; $this->cl_units = $cl_units; $this->db =…
-
0
votes1
answer17
viewsMariadb returns null with between dates
Someone already had this problem after updating Mariadb, it seems that he ignores the between... On my server these schemas returns null do not know why. Has this ever happened to someone there ?…
-
0
votes1
answer45
viewsBring all necessary results in a query - Mariadb
I need to reformulate a small system, which today, works but opening multiple connections to the database, and when there are too many records, the database falls, or when that doesn’t happen, the…
-
0
votes1
answer41
viewsUser connection location in Mysql or Mariadb
It is recommended that I change a user’s connection location from the table mysql.user? For example, I create a user 'danilo'@'localhost' but then I want it to connect from any machine, there’s…
-
0
votes2
answers82
viewsSQL Updating Wrong Value
I am creating a QUERY to change every day of the dates registered in the BD to the last day of the month of that record... what happens is that when I play the QUERY selecting a record in the month…
-
0
votes1
answer108
viewsDouble INSERT no stored
Currently what I have is basically this: CREATE PROCEDURE `Teste`( IN `@valorX` INT, IN `@valorY` INT ) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER INSERT INTO tabelaX(colunaX) VALUES…
-
0
votes1
answer793
viewsI am unable to access Mysql from PHP
I have the following problem, I use Ubunto and installed mariadb, and when I try to access mysql with: mysql -u root The following error appears: ERROR 1698 (28000): Access denied for user…
-
0
votes2
answers1665
viewsLimit Inner Join Result
I’ve been in trouble for a few days. I have a select that does some Inners and should return 3 lines, but one of the Inners has several results linked to the searched result; how to limit this Inner…
-
0
votes1
answer1355
viewsError 1005 : Mysql - does not create foreign key
I have a problem with Mariadb. I created two tables tbl_estoque and tbl_adiciona. Basically, I don’t want to add data directly to tbl_estoque. I want by means of a trigger, he checks the latest…
-
0
votes1
answer28
viewsSQL performing wrong query
I am trying to identify which products in stock have reached the minimum capacity or are below it. I tried it this way: SELECT * FROM produtos WHERE quantidade_minima <= quantidade And I get the…
-
0
votes1
answer40
viewsReference between two tables by Heidisql
Friends, I am using Heidisql and I have a database: Mariadb created two tables and I want to reference client table id, with user_id of table posts. And I forgot how to reference, using the app…
-
0
votes0
answers325
viewsError starting Mariadb in Centos7
Good morning. I have a dedicated server running Centos7 and Mariadb stopped and I can’t restart the service. [root@new ~]# mysqld start 2018-01-17 13:31:10 140236707752192 [Note] mysqld (mysqld…
-
0
votes1
answer72
viewsSQL - Decimal out of range
I have a table that represents products in stock, it has a quantity field DECIMAL(5,3), i understood that are 5 digits before the comma and 3 after the comma, up to 2 decimal places before the comma…
-
0
votes1
answer79
viewsDifferent DECIMAL type field between Mysql4 and Mariadb
I have the following problem: I have a decimal field(11,2) When the calculated value gives (example) 60,345 My SQL 4 Insert saves 60.34 But Mariadb Insert 10.4 (and Mysql 8) record 60.35 This is…
-
0
votes1
answer116
viewsJPA read-only database
Good morning, I have an unusual case for me. A database where I need to make selects and update in 1 or 2 columns of a table. I would like to know how to configure my persistence.xml Persistence.xml…
-
0
votes0
answers21
viewsNumber of aborted connections too high MYSQL/Mariad
we have a Mariadb server here, and was analyzing these days because the same is a little slow, and I came across these numbers, someone could explain to me better what this means, and if possible…
-
0
votes0
answers14
viewsConfigure Mysql connection in Eclipse for PHP
I use Eclipse for PHP and want to know if there is a way to connect the BD to my IDE, in order to suggest tables and other BD information in the autocomplete when writing Mysql queries in the…
-
0
votes1
answer2450
viewsINNER JOIN sql query with WHERE and GROUP BY
I have this query in my database only that I wanted to insert a sum in a.preco_produto and do to GROUP BY only if I put GROUP BY a.codigo_loja in this query of this error> #1064 - You have an…
-
0
votes1
answer120
viewsError while creating table
I have a users table and a friendship table, a friend is also a user and when I add a user as a friend he also has to be my friend, now that the concept is clear, I would like to know how to create…
mariadbasked 6 years, 9 months ago Danrley Fernandes Lopes 1 -
0
votes1
answer47
viewsJoin two Mariadb SQL queries
Two tables tab_Ord_Ser and tab_Pos_Alb. In two different queries I can know the values but I’m not able to unite them in just one. Are they: SELECT Prazo_Producao as Data, COUNT( `Numero OS` ) AS…
-
0
votes1
answer56
viewsMMN ranking query
Hello, I have the following problem: I made a micro-social network for managers, where initially the registration is made only by invitation, thus "measuring" the influence of each one. My problem…
-
0
votes1
answer62
viewsMysql above 5mil lines
Good people I am developing a code only that I came across the following problem, when I performed performance test with 5,000 lines he exceeded the limit of 30 sec... what can be wrong?…
-
0
votes1
answer29
viewsTanning system with Stored Procedure
I’m trying to make a stored Precedent for a simple likes system, my table is organized like this: Likes id INT(11) - Auto Increment post INT(11) - foreign key (id - post) user INT(11) - foreign key…
-
0
votes0
answers154
viewsUse INNER JOIN with WHERE clauses
Guys, I am reassembling a system before in ASP now in PHP already with database loaded and mounted, but I need to do some filters where I need to fetch data from at least 3 different tables and…
-
0
votes0
answers51
viewsQuery in mysql grouped by hour
Good afternoon. I am performing a query in mysql and this returns the precise values. My problem is to display the values that do not return by e.g.: I asked to group by hour or day it only returns…
-
0
votes0
answers271
viewsMysql has stopped working
Hello I am using Mariadb 10.2, I executed the TRUNCATE command in a table with 4 GB and Mysql stopped funionar, I can no longer access any other database, I am using Mysql in xampp and it presents…
-
0
votes1
answer48
viewsRecover the highest value in a column according to the repetition of the second
Good night to you all! I have a system in my company that records an entire value in a table every moment of the day. It also records the date and time in Datetime format; The table in the bank is…
-
0
votes2
answers1353
viewsHow to change a table to enter a foreign key field?
Hello, I’m trying to set a field user_status in an existing name table cl_users using Mariadb in Dbeaver, the table in question will reference another already existing table with 4 status fields…
-
0
votes2
answers1811
viewsI cannot access my Mysql Mariadb database
I’m on Linux Deepin 15.19 and installed for Web Development, however when I can’t create new databases by Mysql Worckbench say: Your Connection Attempt failed for user 'root' from your host to…
-
0
votes1
answer279
viewsINSERT with clause SELECT WHERE NOT EXISTS
I found in the Sopt a response to the same case that mine, but something unexpected happens because this is new to me, the SQL statement below returns an error while running. $sql = " INSERT INTO…
-
0
votes1
answer184
viewsForeign key creation error Mariadb
Hello, I am creating the following tables in my Mariadb database: CREATE TABLE `compras` ( `id` int PRIMARY KEY, `aberto_por` int, `titulo` varchar(255) NOT NULL, `empresa` int NOT NULL, `orcamento`…
-
0
votes1
answer22
viewsError of procedure call
I’m having a problem calling one procedure within a function in the SQL. When I call the function CHECK_LOGIN for SGBD, does the operation without any problem, but I need to do this operation by a…
-
0
votes1
answer104
viewsDocker Compose Wordpress Plugin Does Not Install: Connection Refused
I’m trying to create an application in wordpress, through Docker, however plug-ins are not getting installed: Docker-Compose.yml: version: '3' services: mysql: image: mariadb ports: - "3260:3260"…
-
0
votes2
answers122
viewsIs using the Mariadb JSON type a good one for saving primary keys?
I’m developing a database for a local travel agency: I need to pick up all the passengers and store them in one entity Viagem, so that in the "passengers" field of the latter would be of the JSON…
-
0
votes0
answers34
viewsField timestamp does not insert in Mariadb
I have a local server to program using shaman and his database is mariaDB. I made a system that inserts a record in the table but the data_separation field is a timestamp that by default is NULL. At…
-
0
votes1
answer90
viewsField of type ENUM empty arrow when not a valid value
Test scenario Data set: 10.4.11-Mariadb Table: tabela Campos: id (INT, PK, NOT NULL), ativo (ENUM('S','N'), NOT NULL) Instruction UPDATE tabela SET ativo = 'XXX' WHERE id = 1 Return 1 Row(s)…
-
0
votes1
answer65
viewsProblem with dynamic delete procedure in mysql
I’ve been doing some research on the Internet but I haven’t had much success. I am mounting a precedent to delete values dynamically relative to the dependencies of a given table but I can pass only…
-
0
votes0
answers38
viewsAccess denied for user 'root'@'localhost' (using password: YES)
Good afternoon Guys, I’m trying to create a table using Hibernate in Java, the database used is Mariadb, but when compiling my Java class this error occurs below. I have already checked the class…
-
0
votes1
answer19
viewsDetermining the top-20 in a given year from a last.fm scrobbles table
Good afternoon! I created a table in a Mariadb test base (XAMPP) to store all my scrobbles (times I listened to some music) from the site Last.FM. I used that tool to generate the CSV and imported…
-
0
votes0
answers57
viewsSQL Select INNER JOIN table contacts join all phones in single related record
I am facing the following dilemma: I have 3 tables (Supplier, Representative and Contacts). And the following query: select * from Fornecedor F inner join Representante R as on R.id_provider = F.id…
-
0
votes0
answers73
viewsHow to execute a query using Python function
I set up a function that connects me to the BD and returns me a query: def consult(self, query): try: conn = mariadb.connect( user="XXXXX", password="XXXXX", host="192.168.000.000", port=3306,…
-
0
votes0
answers33
viewsDifference of results between sum with pivot and sum of counters
Hello, I would like a support to understand why the following two querys produce different results. The strategy I searched with them is the same, to count and group Sip results with different…
-
0
votes1
answer26
viewsChanging primitive fields and constraints Modify with MARIA DB
The commands Modify and change column are used to change both the primitive fields and the constraints and field name. alter table pessoa modify column profissao varchar (30) not null; alter table…
-
0
votes0
answers13
viewsHow to increment a variable in the middle of an sql query in Flask?
Hello, I’ve been trying for a while to receive and insert an image that needs to be BLOB type in Mariadb bank with Flask. However, when I try to insert the image into the bank with flask I get the…
-
-1
votes2
answers53
viewsDoubt SELECT Mysql
In a certain select I can reference two tables by foreign keys. Ex:Ida/ Idb Ida = Idb Table A has a column called C Table B has three columns called D, E, F Both tables have similar contents to…
-
-1
votes2
answers26
viewsGROUP BY grouping data from another column into another column
all right? I need a help, I will explain below what I am doing and what I need: I am developing for a digital advertising agency an automatic e-mail system that contains all the campaigns and…
-
-1
votes1
answer118
viewsQuick doubt with Collate on Mariadb
I set Collate to Latin_swedish_ci to accept accentuated characters, but as in the second image, the date is not stored in Portuguese format. How to make it be stored in Portuguese? This is standard…