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
-
-1
votes1
answer40
viewsSQL performance when dividing results into categories
I have a bank with all the products of my store, I want to list the products by categories but I do not know what is the most efficient way to do this, because it is a big bank. It would be better…
-
-1
votes1
answer22
viewsMysql - How to select previous month’s records?
Hello, I’m trying to select the 'Customers' table records that were registered last month. In this table there is the field 'Createdate' (datetime). I’m trying to do it this way but it’s not just…
-
-1
votes1
answer29
views -
-1
votes1
answer89
viewsProblem insert into Mariadb database images
I am using Mariadb and a LONGBLOB field to store my images, when I have insert small images (300KB or less) normally inserts, however larger images that this gives this error here: Mariadb [-1]…
-
-2
votes1
answer710
viewsUTF-8 Charset error when returning from database
My system has charset error, but it is only with the data returned from the database. My HTML charset is right, the one in the database is also right, and on php.ini is also right. How do I solve…
-
-2
votes2
answers250
viewsMysql - INNER JOIN - INDEX
Guys, I got one query here very simple with JOIN, Because banks have a lot of records, I need to index... But I’m getting it for kct... What is the best way to index in a JOIN? (That one query takes…
-
-2
votes2
answers260
viewsLog-in to mysql only with sudo
When I’m at the linux terminal, on my machine and give the command : mysql -u root -p The linux terminal presents : ERROR 1698 (28000): Access denied for user 'root'@'localhost' With sudo before the…
-
-2
votes2
answers93
viewsHow to allow null values in a field that was originally NOT NULL in SQL?
I have a table created this way: CREATE TABLE usuarios ( id INT NOT NULL AUTO_INCREMENT, nome VARCHAR(64) NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id) ); But I want to change the field…
-
-2
votes1
answer31
viewsI can’t enter data into the database
The page loads all right , however the columns are empty in the bank { <?php $servername = "localhost"; $database = "login"; $username = "root"; $passwd = "odair"; $conn =…
-
-3
votes1
answer105
viewsNo suitable driver found Mariadb
I am trying to insert a tuple of data into a DB using JDBC through a web page. I took a class ConnectionFactory to encapsulate the connection with Mariadb, I imported the driver to the classpath,…
-
-4
votes1
answer30
viewsError importing SQL wordpress database
When trying to import database the following error occurs: Erro Comando SQL: CREATE TABLE `wpzm_actionscheduler_actions` ( `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `hook`…