Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
-1
votes1
answer426
viewsConnect php container + Apache container + mysql container without Docker-Compose
I have access to a Linux server and I don’t have access to the internet. I only have Docker without Docker-Compose installed, and I have 3 images already loaded in Docker (apache, php and mysql).…
-
-1
votes1
answer71
viewsMysql Update on Average Students
Hi, good, I have a comic book with several students inserted, and in the exercise I need to average them and insert them in a new column. But when I do a test select before I update my command it…
-
-1
votes1
answer37
viewsHow do I create a view in mysql by taking data from 2 or more different tables?
To Starting to see View in database now, more has arisen a doubt in this exercise, I have to view items from 3 different tables but do not know how.…
-
-1
votes1
answer101
viewsWhat is the best way to store files in a webapplication?
I intend to store files of type docx, pdf, among others to access in my web application, where the database is Mysql, and the framework used is Codeigniter. Could someone explain me which way would…
-
-1
votes1
answer432
viewsDocker: Upload large sql file
People are having problems with Docker. I’m using Docker and the docker-compose to create and configure a web environment quickly and practically. I’ve been using Docker for a while, but I’ve never…
-
-1
votes1
answer118
viewsQuick doubt with Collate on Mariadb
I set Collate to Latin_swedish_ci to accept accentuated characters, but as in the second image, the date is not stored in Portuguese format. How to make it be stored in Portuguese? This is standard…
-
-1
votes2
answers517
viewsSlow response (PHP MYSQL)
<?php require('DB.class.php'); //$conexao = mysql_connect('xxx.xxx.xxx.xxx','base_dados','utilizador'); //$db = mysql_select_db('base_dados',$conexao); $SQl_list =…
-
-1
votes1
answer26
viewsreport in related tables (mysql)
Guys, I’m breaking into something super simple, but I don’t know where I’m going wrong Let’s say I have the tables below, all related to each other tabela1: nota_fiscal (id, data_emissao) 1…
-
-1
votes1
answer49
viewsWarning: Division by zero with dates
how can I calculate a date range for example: 24/08/2017 and 09/05/2017 and take the total amount of days? for example the result of this difference would have to give 106 days difference from one…
-
-1
votes1
answer134
viewsCheck if I have data in the query, when giving the next or prior
I have a query in Delphi, where I give the command next and prior, only I can’t check if it’s my first or last record, what I want specifically is, when pressing the next button, check if it’s my…
-
-1
votes1
answer66
viewsTake the values that were changed in the bank and match the new values
I have the following question. When making changes to a certain register, I need to keep the old information somewhere, I first thought of a log scheme, but it was time to take the old values, I…
-
-1
votes1
answer72
viewsCreate Product Pages - PHP + Mysql
Good night! I am making a virtual store and I would like to know if there is the possibility of making a single product page where the user clicks on the product and the information is loaded…
-
-1
votes2
answers40
viewsInsert mysql database
Hello! The first php code generates several inputs. Where the user informs how many inputs he wants in the $value variable. for ($i=1; $i <=$valor ; $i++) { echo " <label>Chamado…
-
-1
votes1
answer47
viewsvariable transport between pages, php
I have a login page where after the user and password entry he is redirected to a new page. How can I store this user’s data and make it available on the next pages?
-
-1
votes1
answer26
viewsCreate an event to delete from a time
I have an event that deletes records within the table that runs every 5 minutes.With the following parameters DELETE FROM redefinirsenha WHERE `Data` < NOW() But I wanted to make this event run…
-
-1
votes1
answer156
viewsProblems installing broken phpMyAdmin - dbconfig-*
I have a problem trying to install phpMyAdmin on my Ubuntu Server 16.04. I installed Mysql normally, but when I install PMA, the following error occurs in the dependent packages dbconfig-common,…
-
-1
votes2
answers69
viewsPHP Mysql Insert only works in Chrome
I have a page with a form where is inserted name, project, etc... only when I click the form Submit in Firefox or IE does not work, But in Chrome works normally. OBS: 1- I had an old bank. When I…
-
-1
votes2
answers322
viewsDate problem in spring boot + mysql
Good afternoon, I’m trying to make a findAll on spring boot because the date is coming with 1 day late. public List<ContaReceber> findAll() { return contaReceberRepository.findAll(); }…
-
-1
votes2
answers471
viewsWhen I perform a SELECT it returns multiple duplicate records
When I perform a SELECT it returns multiple table posts records with same id; I tried to use DISTINCT not to return these records but it’s still returning duplicate records. SELECT DISTINCT * FROM…
-
-1
votes1
answer403
viewsI want to compare in Mysql "IF" or "CASE"
I just want to do a comparison of dates in Mysql but I can’t. Help me, it’s to see if the date is greater than or equal to a date, and less than another date. SELECT (CASE WHEN '2019/12/05 00:00:00'…
mysqlasked 5 years, 4 months ago Caio Eduardo 1 -
-1
votes1
answer31
viewsReturn data within a period of time
I have the following query: SELECT raddb.FisioterapiaUtente.Id, DataConsulta, Inicio, Fim, raddb.UtentesCD.Utente, nome FROM raddb.FisioterapiaUtente LEFT OUTER JOIN raddb.usuarios ON…
-
-1
votes1
answer25
viewsHow to convert a Mysql view to Postgresql?
I’m making a migration from a Mysql database to Postgresql, but my view is not being accepted, I’ve been all over the internet looking for a way to modify it no longer worked, someone knows how it…
-
-1
votes1
answer609
viewsERROR 1045 (28000) MYSQL
I’m starting with the back-end and I’m having a hard time installing mysql, after installing and doing all procedures while trying to run the mysql the following error appears (it is worth…
-
-1
votes1
answer41
viewsPrint all pages of a PDF file
I would like to know if it is possible to print all the pages of a PDF file obtained from a database (BLOB). This database has image and PDF acquisitions, so the display page will show both formats.…
-
-1
votes1
answer125
viewsHello, I have a database - mysql and would like to decrease a value in an entire column
I’d like to use the command update to decrease an hour in the values you already have in the table of several values in the whole column. EX: Nome da Coluna Gostaria da coluna assim HORA HORA 13:45…
-
-1
votes1
answer55
viewsCopy content from one table to another
I have a table, a call "Cars" with the columns Carid | image another table called "Pictures" with the columns picID | Inname I would like to copy all photos from table "Cars" column "image" to table…
-
-1
votes1
answer49
viewsSQL script to find winners on auction site
I am developing an auction site in PHP and Mysql and I want to display the report of the winners - that is, of the people who made the biggest bids in different auctions (posts). This is the…
mysqlasked 5 years, 3 months ago octavio cossa 15 -
-1
votes1
answer27
viewsProblems with the database
Well guys I created an account in aws, to manage it with mysql I wrote the password the user and I’m sure that this disgrace does not log, already Mechi in ec2, I put to be accessed by any ip with…
-
-1
votes1
answer160
viewsCompare duplicate records in the database with PHP and Mysql
I am trying to make a condition that prevents you from saving the same login name of another already registered user. $login_fail=("SELECT DISTINCT $login FROM login"); if(empty($nome)){ $errMSG =…
-
-1
votes1
answer52
viewsInsert MYSQL error by data grid view
the code is as follows, I am making an Insert from values of a data grid view foreach (DataGridViewRow row in dgvCON.Rows) { MySqlCommand cmd = new MySqlCommand(); cmd =…
-
-1
votes1
answer31
viewsIs there any way to redirect if you can’t find the mysql database?
I’m having a question, is there any way to redirect the user to a page 404 in case you can’t find the database on the connection? follows my code $banco = 'qfood_'.$bdv; $conn1 =…
-
-1
votes1
answer22
viewsConvert query to RAW query
What this query looks like in Mysql RAW format? $user = User::query() ->where(static function ($query) use ($indicador) { $query->where('indicador_id', $indicador) ->orWhere('level_ref',…
-
-1
votes1
answer84
viewsI cannot use the shell in Docker-Compose
I am developing a Python application with MYSQL in Docker-Compose, but it is not a web application, would it have any way to run this application in the container by shell ? if there is, you could…
-
-1
votes1
answer178
viewsWorkbench shows error and does not connect
Workbench had stopped connecting, so I reinstalled it, but now the error is this, I have the xampp installed and it does not start mysql, already checked and has no active connection on port 3306, I…
-
-1
votes1
answer19
viewsFetching array Mysql
The code returns the error Warning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, string Given in uvas checkout.php on line 262 is the same structure used in other blocks. ???…
mysqlasked 5 years ago Ivan Zanoth 19 -
-1
votes1
answer76
viewsSQL queries of state names with their number of cities
Good evening, I am starting to study SQL and I am making small queries in the database to practice. But I fall for the one that asks to display the names of the states with the respective number of…
-
-1
votes1
answer405
viewsImage does not appear in view, in production environment
I have the path of the images saved in the database, and the images in a folder inside the public folder (filename/public/image-post/post_id_2.jpg). in development environment, it usually appears in…
-
-1
votes1
answer999
views'mysqldump.exe' not found in Dbeaver when exporting Mysql database
I use Dbeaver to manage my databases and need to export one of these databases, it happens that when trying to export this database, in tools/Dump Database, the following error is returned: Error…
-
-1
votes1
answer423
viewsRemove white space in select (SQL)
I wonder if you have any way to remove the blank space of the records returned in select. for example I have the NEIGHBORHOOD table with the records Bela Vista 'Amazonas' ' Gravel' but when I do…
-
-1
votes1
answer29
viewsInclude return of a foreach within the background-image url
Speak guys, I need to include the return of a foreach within the url of a background-image, please can help me: <!-- Slide 1 --> <% DTSection0.forEach(function(row){ %> <div…
-
-1
votes1
answer40
viewsQuery Optimization - Mysql
Greetings to you, gentlemen! I come once again to seek the guidance of the masters of DB! As the last time I have a query that returns a very specific result and that works,a but is slow and as the…
-
-1
votes1
answer226
viewssum in two tables in a single query
Have two queries, one in each table. select SUM(quantidade) as total1 FROM tbmateria GROUP by codigomateria select SUM(quantidade) as total2 FROM tbmateriaestoque GROUP by codigomateria need to do…
-
-1
votes2
answers689
viewsPHP Error " mysqli_query() expects at least 2 Parameters, 1 Given", when sending multiple input information
I am making a page with registration of product values, I would like to know how I do a Insert Into of the values of a while? <table style="width: 100%;"> <thead> <tr>…
-
-1
votes1
answer48
viewsConsuming Mysql with javascript
I have a database using Mysql but the server side does not run Ode, is it possible to consume a database using an Ajax request for example? Using Javascript
-
-1
votes1
answer857
viewsNetbeans is not connecting with mysql
I am trying to make the connection between netbeans and mysql, but when I follow the instructions from new connection wizard netbeans appears the following message: Obs.: Netbeans IDE8.2 Can’t…
-
-1
votes2
answers46
viewsHow to join edit/new button?
I would like, if there is already $nome registered in the table, it gives an update and if it does not exist, it gives an input. I do not understand what the problem in my code. $dbconn =…
-
-1
votes1
answer95
viewsGenerate a set of numbers in php
Friends need to automatically generate a sequence of numbers and comma separations in php, for example. 1,2,3,4,5,6,7,8,9,10,11,12 save in a variable and then make an Insert in a mysql database.…
-
-1
votes2
answers94
viewsHow to better optimize the Mysql connection and information listing script?
How to better optimize connection script and listing information from MySQL? Because I check in my researches several ways to do this, but I do not know if this is a correct practice both of…
-
-1
votes1
answer64
viewsHow to perform a bind_param() with SELECT UNION ALL
I have that code. <?php $link = new mysqli("localhost","root", "SENHAAAA", "BANCO"); $sql_saldo_total = $link->prepare( "SELECT sum(g) saldo_total FROM ( SELECT SUM(valor_pg) g FROM tabela1…
-
-1
votes1
answer105
viewsDELETE IN SQL WITH WHERE STATEMENT NO ID REQUIRED
I have ZIP table with a new OP field with DEL information to delete. When I perform the instruction: DELETE FROM cepdb.log_bairro where BAI_OPERACAO = 'del'; Returns: 2 Cannot delete or update a…