Questions tagged as 'mariadb'

Tagged questions
2
answers

Insert values in database using php

It gives me an error when inserting some values in the database. I've been watching for a while now and I'm not right with the error. This is my code: HTML form: <form action="#" method="post"> <f...
asked by 06.06.2016 / 13:54
1
answer

What is the best collation for my MySQL Database?

Greetings! I am working in a database which has planned to answer many queries, the case is that I want to know what would be the advantages of using utf8_spanish2_ci, utf16_spanish2_ci and utf32_spanish2_ci? They wanted me to explain thei...
asked by 10.04.2017 / 22:55
1
answer

update in chain

I have a table that has several tasks, the idea is to "finish one" and start another, but I do not know how to formulate a query like this I have the following: create table tareas( id int not null PRIMARY key AUTO_INCREMENT, idvinedo int...
asked by 01.10.2018 / 05:23
2
answers

MySQL (MariaDB) saves everything in UTF8 correctly, but PHP prints it wrong. Why? [duplicate]

I'm making PHP, configured in default_charset = UTF-8 , put data brought from the MySQL database, also configured with all character variables and collation in UTF-8, within a select element, but it does not correctly encode characters...
asked by 28.04.2017 / 22:09
1
answer

It does not let me create the database in phpmyadmin and it gives me this error: # 1064

The error he gives me is this:    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 'KEY (id))' at line 8 and this is what I programmed: CREA...
asked by 08.06.2016 / 14:38
1
answer

MariaDB & Galera, what happens if a cluster node is lost?

I'm following this tutorial to mount a cluster with MariaDB yy Galera. My question is, if for whatever reason (the machine is turned off, it is removed from the network, etc ..) node 1 is affected, the rest of the nodes continue to maintain...
asked by 28.11.2018 / 12:42
1
answer

Save fixes in database

I have arrangements that I want to save in the database, the arrays have around 1000 elements, should I save them in string or in what type? +--------------------+ tabla caracteristicas piel [datos] ojos [datos] expresi...
asked by 17.08.2018 / 19:50
2
answers

Error showing BD data in Java

I have the following: Home public Principal() { tabla = new DefaultTableModel(null, getColumnas()); setFilas(); initComponents(); } private String[] getColumnas(){ String columna[]= new String[]{"...
asked by 01.12.2016 / 01:25
1
answer

How to create sequences in MariaDB Server?

Within database managers as they are: Oracle PostgreSQL SQL Server We have the possibility to create sequences, which help us for example to generate the incremental auto key that distinguishes each of the records of a table in a data...
asked by 18.09.2018 / 01:33
1
answer

Insert and Search in Datetime field

I'm trying to insert a date with milliseconds, but I can not do it. The bash date has the following format: "%d%m%Y%H%M%S%2N" While in BBDD I see the following: MariaDB [db]> INSERT INTO access_wifi(DATA) VALUES ('0511201813450367'); Q...
asked by 05.11.2018 / 15:47