Questions tagged as 'mariadb'

Tagged questions
1
answer

SELECT on a parent table where ALL children are in the same situation - MariaDB / MySQL

I need to make a select in a parent table, where all the children in this 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 child table I have the follo...
asked by 12.11.2017 / 02:33
1
answer

MySQL migration to Mariadb

I have a MySQL server that has several banks; some gigantic. I've been studying and seen that various services migrated from MySQL to MariaDB. As this is a fork, could I simply migrate this data from one server to another or should I take some p...
asked by 14.03.2016 / 14:45
1
answer

Desktop and cloud system integration

I have a desktop system where I need to send some data to the Google Firebase service. I would like an idea of what would be the best way to send this data to Firebase , and it may happen sometimes that there is no internet connection. A...
asked by 02.07.2017 / 06:27
1
answer

UPDATE SET Does not work in MariaDB [closed]

I have the following code in phpmyadmin, MariaDB UPDATE bairro SET NM_BAIRRO = 'Bairro' ,CD_CIDADE = 1 ,CD_ZONA = 1 WHERE CD_BAIRRO = 1 Can anyone tell me, just because this command does not work? Command in php: public function...
asked by 30.03.2017 / 04:26
1
answer

Group continuous replications with MySQL

I wanted to know if there is any way to group repeats using only MySQL. If you do a SELECT * from tabela WHERE id_usuario = 1 ORDER BY id ASC will return: id | id_usuario | Data | Texto 0 | 1 | 2016-10-16 | Sua senha...
asked by 20.10.2016 / 16:25
0
answers

changes in linked tables (CASCADE etc ...)

I am learning MYSQL on my own because of the teaching restriction there is in my city and its vicinity, so I would like information on how to use CASCADE in the table I have with this structure: tblUser idu int not null auto_increment pk name...
asked by 27.05.2016 / 02:01
1
answer

Use multiple database

I'm not very knowledgeable about database and have never worked with large systems ... I'm creating an application with CakePHP that will serve as a webservice for two types of distinct clients, a client is simple and will only have a table rela...
asked by 21.04.2015 / 04:33
3
answers

Login without differentiating between uppercase and lowercase letters?

I am making a login system. In the table is registered a user "UseR01" , when the client will log in if he put in the "user01" field I want you to validate anyway. Here's the code I'm using. $Name = mysqli_real_escape_string($conn, $_POS...
asked by 18.08.2017 / 00:53
2
answers

SQL Updating Wrong Value

I'm creating a QUERY to change every day of the dates recorded in the DB for the last day of the month of that record ... what happens is that when I play QUERY by selecting a record in month 5 (May) it updates the value of the day with 30 ......
asked by 03.08.2018 / 16:22
1
answer

Error 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 it also has to be my friend, now that the concept is clear, I would like to know how do I create this table , because the following error is o...
asked by 09.04.2018 / 18:20