Questions tagged as 'mariadb'

Tagged questions
1
answer

JPA read-only database

Good morning, I have an affair, atypical for me. A database where I need to do select and update in 1 or 2 columns of a table. I would like to know how to configure my persistence.xml Persistence.xml <?xml version="1.0" encoding="UTF-8"?...
asked by 10.01.2018 / 15:10
1
answer

Error 1005: MySQL - does not create foreign key

I have a problem with MariaDB. I have created two tables tbl_estoque and tbl_adiciona . Basically, I do not want to add data directly to tbl_estoque . I want it to be trigger to check if the last record of tbl_...
asked by 24.09.2017 / 16:36
1
answer

I can not access MySQL through PHP

I have the following problem, I use Ubuntu and I installed mariadb, and when I try to access mysql with: mysql -u root The following error appears: ERROR 1698 (28000): Access denied for user 'root'@'localhost' And then I can access it...
asked by 31.07.2017 / 02:42
1
answer

How can I pass the COUNT attribute on my sql string, since "COUNT" is a reserved php word?

Follow the select string: $resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";     
asked by 28.04.2017 / 18:54
1
answer

Detail master table, totalizing fields

I am doing a work order control where in a work order several users will register products and labor, so I have three tables: - Service order (master) - Products (detail) - Labor (detail) The detail tables generate values that will have to repre...
asked by 31.03.2017 / 04:02
2
answers

Doubt SELECT Mysql

In a given select I can reference two tables by foreign keys. Ex: IdA / IdB IdA = IdB Table A has a column named C Table B has three columns called D, E, F Both tables have similar contents for returns in SELECT Ex: Select ... fr...
asked by 19.09.2018 / 13:06
1
answer

nav pills bringing mysql info in pdo

<div class="video-sec"> <h4 class="heading-small">Mídias</h4> <div class="video-block"> <ul class="nav nav-pills justify-content-center mb-4" id="pills-nav" role="tablist"> <?php // Atribui uma con...
asked by 17.11.2018 / 21:07
1
answer

UTF-8 Charset error when returning from database

My system has a charset error, but it is only with the data returned from the database. My charset in the HTML is right, the database is also right, and php.ini is also right. How do I solve the problem? Special characters are returnin...
asked by 25.09.2015 / 16:53
1
answer

No suitable driver found MariaDB

I'm trying to insert a tuple of data into a DB using JDBC through a web page. I made a ConnectionFactory class to encapsulate the connection with MariaDB, I imported the driver for the classpath, I tried inserting some data with a...
asked by 11.09.2018 / 21:08