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
-
0
votes1
answer22
viewsError of procedure call
I’m having a problem calling one procedure within a function in the SQL. When I call the function CHECK_LOGIN for SGBD, does the operation without any problem, but I need to do this operation by a…
-
0
votes2
answers145
viewsProblem with table data insertion via Aravel
I have a project in Laravel at the same time I learn to use the framework, I need to insert a certain value in a table field, for this there is a condition I put in the controller: public function…
-
0
votes2
answers118
viewsCreate data loop received by post and insert into mysql
good morning. I’m trying to make a shopping ordering system. I would like to know how to receive $_POST values and send them to a bank. The problem is that this $_POST information is dynamic. I…
-
0
votes0
answers119
viewsHow do I automatically create a new page for every new post I do?
I’m creating a news portal in PHP. How can I automatically create a new page (with header and footer) for every post I do? I’m trying to do this with fopen / fclose, but I don’t know how to make it…
-
0
votes1
answer254
viewsTake data from a dynamic table and save to mysql
good night. I haven’t programmed in a long time! I’m rusty, rsrs I need help. I’m making a system to control budgets. my problem is that I need to take this product information and play in a mysql…
-
0
votes1
answer55
viewsMy subquery is overwriting a column of the searched table
I’m putting together a list of posts, where besides the post information I need the information of the house that made the post. I did the following table query posts and casas: SELECT * FROM posts,…
-
0
votes1
answer53
viewsProblem feeding database via php form
Good guys, I’m doing some tests with a database, but I’m having a problem where for some reason, the information is not being sent. The codes are in different files; I have a file called…
-
0
votes0
answers88
viewsPHP error while trying to pull data from Mysql database
Good morning guys, okay? I got a problem on the next one. I hosted my PHP site on a Server where there is the DNS and the main suffix of the network, so that the site can only be accessed internally…
-
0
votes2
answers99
viewsI cannot run a query with jdbc java
public List<Sistema> buscarUsuarioSistemaPor(Long cpf) throws SQLException { List<Sistema> listSistemas = new ArrayList<>(); String sql = "select s.* from sistema as s\r\n" +…
-
0
votes0
answers270
viewsError connecting Mysql to Vscode with c++
I’m trying to connect the Mysql for some time in the Vscode with the linux OS Mint +19, and I’m not making it after taking the following steps: I downloaded Connector on the Mysql website:…
-
0
votes0
answers88
viewsIs it possible to force a value when select has no search result?
Good guys, I have a situation where I need to show the balance of billing per client, as I could in no way use a select that combines the result of two other select, I decided to use the separate…
-
0
votes1
answer20
viewsHow to avoid automatic datetime field formation in Mysql with Asp Net?
I’m trying to read datetime fields with Mysql.Data.Mysqlclient, but the value that returns is always different from what is in the database, for example in this bank "2002-05-01 00:00:00.000" but…
-
0
votes0
answers1421
views#2054 Unable to login to Mysql server - Phpmyadmin - APACHE ( PASSWORD ERROR)
I was doing the settings, at the time of installing mysql I ended up putting a password but ended up missing believe. Now when logging into Myphpadmin - it gives this error. I’m Using Apache>…
-
0
votes0
answers43
viewsCreation of Search with Filters
Hello, in my project I need to filter the results with the following parameters: Minimum Wage and Maximum Salary, Contract Type. But it only works if the user chooses the options, if he chooses to…
-
0
votes1
answer131
viewsError accessing PHP application via Docker
I’m having trouble accessing the application via Docker. I’m getting a "Unable to connect" firefox error when trying to access the localhost:8899 address (ja tentei127.0.0.1:8899 and it also doesn’t…
-
0
votes1
answer146
viewsJPQL Illegalargumentexception - Unexpected token: SUM
java.lang.Illegalargumentexception: org.hibernate.hql.internal.Ast.Querysyntaxexception: Unexpected token: SUM near line 1, column 1 [SUM(e.quantidade) FROM br.com.pmro.coad.modelo.Stock and Join…
-
0
votes0
answers46
viewsHow to adjust this query?
I need to adjust this query to do the search (like) in another column and another table. Behold: $query2 = "select distinct(lances.codigo), datacompra, horacompra, cupom from lances, ".$tabelaCad."…
-
0
votes1
answer56
viewsHow to make a "Case When" when the condition is called a Package with the function and Passed the Parameters?
I am trying to make a modification in the Query without destroying a logic already made. Original Query: IF Pcoluman = 'aceito' THEN if (v_respon_alg = 'Y') OR (v_respon_las = 'Y') OR (v_respon_nye…
-
0
votes1
answer1001
viewsKeep updating select in the page div without refresh mysql php
Good afternoon, I have a div that I do a simple select bringing only the amount of database records, and I play the result on an H3 inside that div, all I need is for that div to be automatically…
-
0
votes1
answer331
viewsSelect mysql with COUNT and GROUP BY MONTH
Hello, I am trying to put together the information of two tables to generate a graph, I need to count the total of record consults1 and consults2 and group by month: Currently I have this return:…
-
0
votes1
answer65
viewsPHP and Database does not update, use of UPDATE - SET - WHERE
I’m having problems with the code I’m developing, I ask you to make the change in the database, however, no changes are made to my BD. Follows the code: <?php $id = $_POST['id']; //Variável de…
-
0
votes0
answers71
viewsCode::Blocks - Std::bad_alloc
After I run this simple code. #include <iostream> #include <jdbc/cppconn/connection.h> #include <jdbc/cppconn/driver.h> int main() { sql::Connection *con; sql::Driver *driver;…
-
0
votes1
answer330
viewsProblem with accentuation in the return of PHP to Data Tables
Hello. I am performing a query to the database, with php and mysql, and return the result of this query to Datatables (in the form of JSON) which lists this result in a table in my HTML. The problem…
-
0
votes1
answer129
viewsFunction validate users registration
I’m starting in OO in php, and with the function below I’m trying to check if the name coming from the form is equal to some value coming from my user table before making Insert in the table. I wish…
-
0
votes1
answer104
viewsDocker Compose Wordpress Plugin Does Not Install: Connection Refused
I’m trying to create an application in wordpress, through Docker, however plug-ins are not getting installed: Docker-Compose.yml: version: '3' services: mysql: image: mariadb ports: - "3260:3260"…
-
0
votes0
answers30
viewsHow to return time in Mysql even without registration at that time
I need to group data in a 15-minute interval, giving me the total number of vehicles in a given date range. What I got so far was this query: SELECT Date_format(data_hora, "%y-%m-%d") AS dataFormat,…
-
0
votes2
answers37
viewsError summing using Join and sub-query - MYSQL
Good afternoon, I have two tables that I need to perform the sum but it is grouping. *Correction: The rule of business is that there are notes , in which the user can make several deposits upon the…
-
0
votes2
answers177
viewsproblem with PHP file path
Good evening, I’m having problems doing include of a file I use to register data in my database, I’m getting the error: Warning: require(./cadastro/usuario/usuario.php): failed to open stream: No…
-
0
votes1
answer103
viewsmysqldump generating the same file with different size
Good morning, you guys. I’m having a bizarre problem using the mysqldump, I’ll try to explain as best I can. I have 4 Databases, and daily a dump is made from each base, generating different files,…
-
0
votes1
answer217
viewsMYSQL - SUM within IF
Good morning guys! All right? I took a look and found nothing about it... If it’s repeated topic, I’m sorry.. Situation: I need to filter the "conditionals" by status, but these status I define from…
-
0
votes1
answer29
viewsProblems to make a SELECT
I’m having a hard time getting a SELECT. I need to list all the information(dcodigo, dnome) of the department (DEPT) that have a manager(position). My code is like this: create database bd_emp; use…
-
0
votes1
answer73
views -
0
votes1
answer32
viewsSelect Sql Query Manipulation (Multiple Combo option in Zend)
Good morning, I have a "Select" that lists as an option everything in the table "areas", followed by the word "ALL", Below each "area" option are listed those sub-areas that link to the area. When…
-
0
votes2
answers61
views"You have an error in your SQL syntax" with array
personal I’m having a problem this error keeps appearing You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near…
-
0
votes1
answer1201
views#1064 - You have a syntax error in your SQL next to 'DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' on line 1
So guys, I exported a database from the school where I study only that I exported the database from an old mysql so it Gero another xml code for me and need to import it to a latest mysql it from…
-
0
votes1
answer37
viewsDoubt - Let the user choose which line to delete
I am developing a small CRUD in the C++ language, using Mysql c++ Connector 8.0.17, and I came across this question: void Management::excluir(){ std::cout << std::endl << "…
-
0
votes1
answer54
viewsSend button id by ajax to update database
Good night, you guys, I’m a beginner in the area, and I ask you to help me, I have a table with php database results, in one of the fields has a button that stores the id (primary key) and clicking…
-
0
votes0
answers55
viewsIs there any way to catch up?
I’m developing a little game in which the user will win 200 of money per minute. I have a simple time comparison script ready, which saves the current time(+ 1 minute) in the database and compares…
-
0
votes1
answer318
viewsProblem doing password update in DB. - PHP, PDO, MYSQL-
I am calling a function from a class. This function is used to change the user password in db. The class file contains: <?php class Usuario { private $pdo; /*criando variavel para usar nas…
-
0
votes2
answers473
viewsHow to automatically populate a table field with a foreign key?
Good afternoon! Guys, I made a form where I take the data from this form and send it to two related tables. One of them is the registration table (only with personal information) and another address…
-
0
votes1
answer112
viewsLaravel - wrong return of last element of the bank within a loop
When records are entered within a loop and is made a select to get the last record based on a conditional, after the fifth interaction he no longer takes the last record and keeps picking up the…
-
0
votes0
answers26
viewsAdd elements to an array via a foreach
I cannot add elements to an array through a foreach My array $agendas: array(7) { [0]=> array(7) { ["id"]=> string(1) "1" ["cliente_id"]=> string(1) "3" ["usuario_id"]=> string(1) "1"…
-
0
votes1
answer128
viewsRelease External Mysql Connection
I recently set up a mirrored Mysql server. Following this procedure: https://hostpresto.com/community/tutorials/how-to-setup-mysql-master-master-replication-on-ubuntu-16-04/ The command to release…
mysqlasked 5 years, 7 months ago Guilherme Lima 360 -
0
votes1
answer155
viewsGrab Mysql database time
-Good night, you guys! I have an application that takes data from the database and displays it on the screen. It’s a television schedule, I mean, it shows what’s going on live and what’s going on…
-
0
votes2
answers47
viewsDoubt about SELECT command using IN
I am mounting a select in Mysql as follows: select lista, (select if (count(login.LogID) > 0, 'S', 'N') from login where login.LogID = 407 and login.LogID in (11,157,66,158,407)) as Seguindo from…
-
0
votes1
answer33
viewsProblem entering form data in Mysql
Good morning, I created a form for registration and this form should send via POST without leaving the page and perform the Insert in my database table, but it enters every time in my "Else{echo…
-
0
votes1
answer56
viewsLogin check does not start Session
I have a login system that checks according to the level of access of the user that worked until recently but I did something that stopped. Form <form class="text-center" style="padding-left:…
-
0
votes1
answer180
viewsPaging without refresh receive no value
I have three files: 1) listarusuarios.php Search the database to list 2) paginação. who pages the archive 3) dash.js where do I list the files without updating the page 1) listarusuario.php send the…
-
0
votes1
answer152
viewsSQL query to add Rows and display in two Columns in MYSQL
I would like to display the sum of several rows, only in two columns. All information is in the same table. Only the criteria change. Ex: I want the SUM of a column with WHERE and I want the SUM of…
-
0
votes1
answer64
viewsUPDATE does not work with data from a POST
I am getting the data from a POST and trying to update a mysql table, but UPDATE does not work at all. If I use as described below, just replace the values with empty. <?php…