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
-
16
votes2
answers7274
viewsDifference in result between Mysql 5.5 and Mariadb 5.5
I have a query running on my site that is installed the Mysql 5.5.43, but when I went up on the server (which has the MariaDB 5.5.38 and I only came to know now) the query does not return the same…
-
10
votes2
answers3110
viewsMysql = Mariadb, huh?
It’s been a few days since I’ve been listening to the teacher in my class saying,: Oracle purchased the MySQL and just renamed it to MariaDB. As I am not easy to believe in the things spoken, I went…
-
7
votes2
answers798
viewsMariadb ERROR: ERROR 1709 (HY000): Index column size Too large. The Maximum column size is 767 bytes
When I run this code on Mariadb, it gives me this error when trying to create the toy table: ERROR 1709 (HY000): Index column size Too large. The Maximum column size is 767 bytes. I don’t know how…
-
5
votes3
answers2021
viewsHow to connect Mariadb with python3?
Friends, is there any way to connect Python 3 with Mariadb? Also, could indicate some material in English or Portuguese? Thank you in advance!
-
5
votes1
answer1244
viewsUsing multiple databases
I don’t know much about databases, and I’ve never worked with large systems... I’m creating an application with Cakephp that will serve as a webservice for two distinct client types, one client is…
-
5
votes2
answers2146
viewsWhat is the difference between mysql-server and mysql-client?
It is said that using the command apt-get install mariadb-server would also install the mariadb-cliente. I understand that the server can be said to be where the data persist, however I lack an…
-
4
votes0
answers599
viewsMariadb for when I have many hits on wordpress
I have a Wordpress site, used Mysql before in Centos, I decided to migrate to a Debian 7 with Mariadb, but when I have more than 30 simultaneous blog accesses, the database to. Go on down mine…
-
3
votes1
answer5798
viewsInsert into table if not available
How to insert data into a table only if it does not exist? the following attempt returns an error, the basic idea is to insert a mode record unique,if already existing ignore, otherwise enter the…
-
3
votes1
answer11657
viewsDuplicate database record with new id
I have a table in the database called user, with n fields, how can I duplicate a particular record only with a new id? insert into usuarios * select * from usuarios where id = x? Obs: this id is a…
-
3
votes1
answer3038
viewsForeign key creation error in Mariadb
When trying to create the toy table, the following error appears: ERROR 1005 (HY000): Can’t create table brinquedos.brinquedo (Rrno: 150 "Foreign key Constraint is incorrectly Formed") Follows the…
-
3
votes1
answer59
viewsIs it possible to use Mariadb for Clusterization?
I am studying about SQL database analysis, and to go deeper I intend to run some practical tests with a DBMS, and I chose Mariadb for this. Therefore, I would like to know if it is possible to use…
-
3
votes2
answers868
viewsWhen trying to define column as Unique, error is generated by talking 767 bytes
When I try to run a Migration on Laravel, the following error is generated: [Illuminate Database Queryexception] SQLSTATE[HY000]: General error: 1709 Index column size Too large. The Maximum column…
-
3
votes0
answers88
viewsC# EF Core - simultaneous conflict with Trigger mariadb
I’m using EF Core with mariadb, in the database I have fields with defined default values and a trigger "before insert". In fluent mapping, I report the default values to the field normally.…
-
3
votes2
answers48
viewsInsert WHERE into query giving error
I have this query here that is pulling right. However, now I want to put those who have the registration only within the current month (for example September). My created_at is datetime. I’m…
-
3
votes1
answer90
viewsHow to limit rows per month in SQL
I have a list of products purchased with date and price, I wanted to organize in a query the ten most purchased of each month, type: mes | nome | total janeiro | arroz | 100 janeiro | feijão | 87…
-
3
votes2
answers124
viewsALTER TABLE CHANGE is not renaming constraints automatically on the production server
According to the Mysql documentation (which in this case, I believe, also applies to Mariadb), when the command CHANGE is used to rename a column, the constraints are automatically renamed as well:…
-
2
votes1
answer261
viewsMysql to Mariadb Migration
I have a Mysql server that has several banks; some gigantic ones. I have been studying and saw that several services have migrated from Mysql to Mariadb. As it is a Fork, I could simply migrate this…
-
2
votes0
answers44
viewsSwitching from MYSQL to MYSQLI
PHP Deprecated: mysql_connect(): The mysql Extension is deprecated and will be Removed in the Future: use mysqli or PDO Instead in /resocubatao/public_html/includes/Bancodedados.php on line 6 on my…
-
2
votes4
answers4316
viewsHow to import a csv file to Mysql?
I am starting my studies in Mysql. I decided to install Mariadb 10.1.14 in Centos. I want to create a database from a file . csv with about 166 million lines. I looked for tutorials on the internet,…
-
2
votes0
answers182
viewsEngine with lower RAM consumption than Innodb/Xtradb in Mariadb?
Innodb allows you to make several INSERT and also UPDATE without creating LOCKING, while in Myisam it is not possible to make several INSERT at the same time and to make matters worse Myisam does…
-
2
votes2
answers224
viewsCondition for INSERT INTO
I need SQL to check that in the '@variable' sent there is a value equal to 1, 2 or 3; If true enter the value 1, otherwise enter the value 0. Note: the table and column can be given as examples as…
-
2
votes2
answers1469
viewsHow to automatically add two columns from two different tables and perform Insert in another table in Mysql?
I am starting work with database and would like to perform an intelligent action in the bank. I have two tables that store information from different sensors, each with its respective columns. I…
-
2
votes2
answers562
viewsMysql alias in all Columns
Good afternoon Galera. I have a little problem to join some tables by INNER JOIN, and because the columns name are equal, I imagine that the ALIAS can save me by changing the columns name pro front.…
-
2
votes1
answer80
viewsPlots - PHP Financial System
I am making a financial system, but due to insecurity and ignorance of the subject, I have the following doubt... Let’s assume that: We have a value of R $ 1299,99 or similar. What would be the…
-
1
votes1
answer115
viewsSelect to List data from another table
I have a system that registers personal data enc_dados_pessoais and another table that stores complementary data enc_dados_complementares. In the table personal data the user registers only the…
-
1
votes0
answers87
viewschanges in linked tables (CASCADE etc...)
I am learning MYSQL on my own due to the teaching restriction that there is in my city and its vicinity, so I would like information on how to use CASCADE in the table that I have with this…
-
1
votes2
answers167
viewsError with SQL and Mariadb (Current position is before the first Row)
I have a problem in my database and I have no idea what it is. public String getBlockPermission(String blockstring){ String permission = ""; try{ ResultSet res =…
-
1
votes1
answer94
viewsGroup continuous repeats with Mysql
I was wondering if there is any way to group repetitions using Mysql only. If you make a SELECT * from tabela WHERE id_usuario = 1 ORDER BY id ASC will return: id | id_usuario | Data | Texto 0 | 1 |…
-
1
votes1
answer1283
viewsmariadb connection error
Today I installed the lamp in my manjaro and everything was working normally, until I went to test php with mysql and typed the code: $conexao = mysqli_connect('localhost','root','','data'); I…
-
1
votes0
answers15
viewsHow to reorder the result of a query if it has a specific result?
I have a query (select nome from coisas;) that returns to me for example: escova mesa cadeira garfo How do I make so that if there is a "chair" in the results, it always appears first, and the…
-
1
votes1
answer196
viewsIs using specific data types like SMALLINT and MEDIUMINT instead of INT and marking columns with UNSIGNED an exaggeration?
Speaking of databases, we know that they have several data types to be used in each specific situation. But, following the data types to the letter can be considered an exaggeration in most cases or…
-
1
votes1
answer128
viewsDesktop and cloud system integration
I have a desktop system where I need to send some data to the service Firebase of Google. I would like an idea of what would be the best way to send this data to the Firebase, and it can sometimes…
-
1
votes1
answer68
viewsUPDATE SET Does not work on Mariadb
I have the following code on phpmyadmin, Mariadb UPDATE bairro SET NM_BAIRRO = 'Bairro' ,CD_CIDADE = 1 ,CD_ZONA = 1 WHERE CD_BAIRRO = 1 Someone can tell me, just because this command doesn’t work?…
-
1
votes1
answer1147
viewsSELECT in a parent table where ALL children are in the same situation - Mariadb/Mysql
I need to select in a parent table, where all children in that table NEED to be in the same situation. For example: In the parent table I have the following fields: pai_id, pai_nome In the table son…
-
1
votes1
answer142
viewsInsert in Mariadb giving timeout
What are the reasons that the simple Insert described below would take so long that it even gives timeout on the server? INSERT INTO wkvmk_postmeta (post_id, meta_key, meta_value) VALUES(904,…
-
1
votes0
answers30
viewsAccelerate selection by varchar - Mariadb 10
I have an Innodb table with 105 columns and about 300,000 rows. There is a varchar(24) where the username is stored. When I execute queries like these: SELECT * FROM users WHERE BINARY…
-
1
votes1
answer173
viewsSequelize Associantions
I have 2 models: user Features: const DataTypes = require('sequelize'); const database = require('../config/dbconnection'); const user= require('./user'); const user_features =…
mysql node.js join mariadb sequelize-jsasked 5 years, 7 months ago Guilherme Monteiro de Oliveira 21 -
1
votes1
answer156
viewsBD creation with Mysql - Mariadb - Workbench
I’m trying to create a BD as Diagram done in Workbench but returns the error below: ERROR 1064 (42000) at line 45: You have an error in your SQL syntax; check the manual that corresponds to your…
-
1
votes0
answers29
viewsHow to fix error num_rows Property
Folks I have a question regarding this error: Notice: Trying to get Property 'num_rows' of non-object in C: xampp htdocs control inc database.php on line 94. Follows part of the code. function find(…
-
1
votes0
answers57
viewsINNER JOIN does not return all records
Talk people, good morning. I have two tables in my bank (client and phone), where some clients have several records and others none. Initially I was having trouble "nesting" all the phone table…
-
1
votes1
answer33
viewsLaravel. How to use request to perform APP search
Good morning gentlemen I am starting my studies in Latin working with version 6 of the framework, and I came across problem that is probably a detail that I missed in my code. When trying to perform…
-
1
votes1
answer104
views<mariadb has no attribute Error> no python/windows
Hello, I’m trying to use mariadb with python in windows. My system is: Windows 10 Python 3.8.6rc1 Pip 20.2.3 I installed the connector: download mariadb-Connector-odbc-3.1.0-Win64. msi And installed…
-
1
votes1
answer39
viewsCatch the lowest and highest value of a category with the count and ID
I need some help to make a SELECT that returns me the highest and lowest value of a category with its respective IDs and the amount of each category. The algorithm is complex, because it needs to…
-
1
votes0
answers27
viewsDuplicate entry '78161' for key 'PRIMARY' (Not duplicated)
I have a table that stores people’s data and when I give an input to add a new record it says that the 'id' (primary key) is duplicated, however it is not duplicated. The table where I am entering…
-
1
votes0
answers60
viewsHow to include words without accent in search results - PHP, Mariadb
Please, I need a little bit of your wisdom and patience. I’m developing a website, which has a search page, and I need to make the results presented "Accent insensitives". That is, if the person…
-
1
votes1
answer35
viewsGroup by records by date and user id
Good afternoon! I have a table like this: I need to perform a SELECT that counts how many records I have per month and year, but grouping together the "repeated" records...(Records repeated in this…
-
0
votes1
answer66
viewsIF Mariadb phpmyadmin
I’m trying to create a Rigger using phpmyadmin with Mariadb bank but when it gets on the line if it gives a message: unrecognized statement type. (near IF) Trigger is the one: SET @TOTAL = (SELECT…
-
0
votes2
answers227
viewsSQL Query, Join 4 tables, 2 group_concats + conditional, Help
Hello, I created an sql query to return all the client data in a single query, this query works partially if all conditions are satisfied, but this system uses soft delete, where all records cannot…
-
0
votes1
answer117
viewsError installing Mariadb
I am trying to install mariadb and the system returns the following error My question is the following, how to install in a directory other than the /var/cache...…
-
0
votes1
answer253
viewsMaster detail table, totalizing fields
I am doing a service order control where in a service order several users will register products and labor, so I have three tables: - Order of service (master) - Products (detail) - Manpower…