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
-
-2
votes1
answer1151
viewsColumn id with Primary key and auto increment is returning null MYSQL PHP
Good evening guys, it is the following, I have an application that was working until these days, then today when I went to add a post in the database, my id_post that is Primary Key and…
-
-2
votes2
answers52
viewsInner Join does not work - Error 1054
Could someone explain to me why this query does not work? select mensagem.mnsg, aluno.nome as nomea, aluno.curso as cursoa from mensagem inner join aluno on aluno.rm=mensagem.RM order by id asc; --…
mysqlasked 6 years, 1 month ago CarlosAugusto11 3 -
-2
votes1
answer495
viewsList Mysql data with PHP and Bootstrap
Hello, I’m having difficulties in listing values of a table, I believe it is syntax error, because not even the html data appear, follow the code: $query = sprintf("SELECT * FROM entrega_cliente");…
-
-2
votes2
answers254
viewsMysql doubt compare multiple columns
Goodnight, I’m with a project where I need to compare which employee meets certain requirements, the structure of the bank is like this: I have a table with the score requested for each position and…
-
-2
votes1
answer173
viewsHow to extract information from an Array in Mysql?
Well, I’d like to know how to pull the information from array from my database, follow as it is in my database: In short, I’d like to know how I extract this information: {'en' => 'Holiday…
-
-2
votes1
answer60
viewsHow to read items from one array within another?
This is my multidimensional array: <?php $beneficiarios = array ( array( "codigo_membro" =>$cod, "nome" => $_POST['nome1'], "n_identificacao" => $_POST['n_identificacao1'], "parentesco"…
-
-2
votes3
answers404
viewsCategory and Subcategory Sum with PHP and MYSQL
I already broke my head and I’m lost in finding the solution to my problem, I’m developing a financial report that has categories and subcategory (7 levels) Below is the structure of part of my…
-
-2
votes2
answers105
viewsSum values of the same code
Hello, I have a table that lists purchase quantity of each product, for example, if the buyer makes 3 purchase orders he repeats the orders and quantities. An example of this is the image below: for…
-
-2
votes2
answers91
views -
-2
votes1
answer103
viewsInsert Problem: String sql is correct, but does not insert by Java, only manually by Mysql! Procedures attributes date time
Good evening guys! I’m using java and Mysql. At the moment I’m using Procedure for insertion everything happens perfectly the String goes to the bank with all the correct parameters, but something…
-
-2
votes2
answers680
viewsRoot user without permission, even with password set
My problem is after installing mysql, configuring the password ( I was sure to be root) and installing Workbench. When I try to access the bank, it says: Your conncetion Attempt failed for user…
mysqlasked 5 years, 10 months ago João Arthur 11 -
-2
votes1
answer77
viewsTrigger insert and change data
Good afternoon, I am trying to create a Trigger that after entering data(after Insert) in the table prodvdmat, it goes to the "input" table and checks if there is data in it, if there is no creates…
-
-2
votes1
answer16
viewsUpdate records by blocks
Hi, I need to make a update in a field (called block) for each given amount of records. I have 100 records, for every 10, I must enter a (automatic) number in the field. The idea is to divide the…
-
-2
votes1
answer156
viewsValidate PHP URL for sending to Database
Guys I have this code that does the processing, however I wanted to add a url validator, I tried to insert if ( ( ! isset( $site ) || ! filter_var( $site, FILTER_VALIDATE_URL ) ) && !$erro )…
-
-2
votes1
answer72
viewserro_persistence_mysql8.0_hibernate_eclipse
Guys, I’m in my first persistence class, but the code is not working, **mysql persistence file:* <?xml version="1.0" encoding="UTF-8"?> <persistence…
-
-2
votes1
answer70
viewsHow to Change a Data in the BD
I’m trying to change the data registered in the database, for example, when I click on DataGrid He pulls the dice for me textBoxs, but I wish I could save the changes made, but it does not change,…
-
-2
votes1
answer148
viewsWhat is the best accommodation to maintain a system?
Hello. We are developing a Task Management system (in the company where I do internship) and now we will need to host the system on the web. The system is made with a lot of Javascript/jQuery, PHP…
-
-2
votes1
answer20
viewshelps how to store image in mysql database and display it in index
I tested this code I found, is the index, in it I display products from my bank, only the image that is the same (repeats in each div) because I do not get it from the bank, I think if I took the…
mysqlasked 5 years, 6 months ago user456711 11 -
-2
votes1
answer220
viewsHow to delete a row from the database?
The name of my table in the database is arquivo. Then there is a list of images and I want to solve, all in PHP Here I exhibited <?php include ("cabecalho-tcc.php"); include("rodape-tcc.php");…
-
-2
votes1
answer62
viewsList alphabetically ordered Mysql records in PHP
I created a table to store records of names of people where the field a_tipo store the alphabet letter related to the name, the table structure is like this: With PHP I made the connection to the…
-
-2
votes1
answer29
viewsmysql syntax error
I am running the following script for database creation: create database jogos; use jogos; create table jogo( codigojogo int auto_increment primary key, nomejogo varchar(40) not null ); create table…
-
-2
votes1
answer521
viewsError: mysqli_connect(): (HY000/2002):
When I try to connect to my database by php gives this error: Warning: mysqli_connect(): (HY000/2002): An attempt to turn it on failed because the connected component n answered correctly ap s a…
-
-2
votes1
answer147
viewsTrigger in mysql copying data in the same table
Good Afternoon, I have a table that contains the id_document (int) AI fields, username and nosso_numero(int). I would like to use a Trigger if it is possible that after I insert a new document the…
-
-2
votes3
answers124
viewsMysql Inner Join... Column error 'Id_occurrence' in field list is ambiguous
I want to access data from two different tables: ocorrencia and fotos. On the table fotos I have a field that is the id_ocorrencia (which creates the relation - foreign key). On the table ocorrencia…
mysqlasked 5 years, 2 months ago Menino Hori 1 -
-2
votes2
answers712
viewsSubquery (SQL error (1242): Subquery Returns more than 1 Row)
I created the following query: SELECT a.`CPF/CNPJ`, a.Cliente, a.Cep, a.Cidade, a.Estado, COUNT(a.`CPF/CNPJ`) AS Novas_Instancias, ( SELECT COUNT(c.`CPF/CNPJ`) FROM relat_instancias c GROUP BY…
-
-2
votes1
answer69
viewsHow to create a server to place a website online?
Talk guys, all right? Well I know that my question about the title is a little strange, but apparent should have a very simple answer kkkk But first I will explain a little of my situation! My…
-
-2
votes2
answers178
viewsTake option value and save to a variable to register in the bank
<p>Escolha a categoria: <select name="categoria"> <option></option> <option value="v1">Conhecimentos gerais</option> <option…
-
-2
votes1
answer60
viewsI have this code, how to update in sql?
have tried $sql = " UPDATE biblioteca SET nome_usuario WHERE nome_usuario IN ( SELECT nome_usuario FROM ( SELECT nome_usuario, COUNT(id_usuario) FROM orders WHERE nome_usuario )" $sql = "UPDATE…
-
-2
votes2
answers458
viewsFinish buying Html + PHP
I’m making a website for a school work where I need to create List of products available in the Database, and have the option to enter in the shopping cart. Until then it is working correctly, but…
-
-2
votes1
answer138
viewsUpgrading MYSQL to MYSQLI
What can I do to fix this? I did some research, but I couldn’t understand what I’m doing wrong, my knowledge is basic in the subject. I bought an application that came old MSQL that no longer worked…
-
-2
votes2
answers121
viewsSelect higher value between Mysql Joins
Hello. I need to make a query in Mysql where there are JOINS of 4 tables, all tables have the column data_cadaster, I need the selection to return only the record where the data_cadaster is the…
-
-2
votes1
answer68
viewsProfile page - PHP/Mysql
Hello ! I’m trying to create a page for each user who registers on the site, but I’m not getting it, basically the profile works as follows: each profile is linked by userid, which can be accessed…
-
-2
votes1
answer2475
viewsWhere is the data stored in Mysql 8?
Two days ago I started studying about the Mysql and so far I only know his basics, not to mention that he’s the first SBGD what study. One very interesting thing about Mysql that I found, is that…
-
-2
votes1
answer143
viewsMysql procedure does not recognize WHERE and displays error
Running procudure below Mysql Workbench shows error: "Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode,…
mysqlasked 4 years, 10 months ago Kennedy Teixeira 7 -
-2
votes1
answer175
viewsDifficulties with PHP and Mysql Dynamic Insert
I am developing a system where the user inserts lines as needed (this part is already ready). I’m having trouble generating PHP and the database to save the records, this is the first time I had to…
-
-2
votes2
answers111
viewsHow to send data to PHP in real time?
Talk personal, all right? I’m trying to make a system that calculates budgets depending on the product and its characteristics. I am using the following code to rescue the data from the database…
-
-2
votes1
answer58
viewshow to pass multiple database queries to a route?
Problem: I am developing an application in Nodejs + Express and I have reached a stage where I need to pass several queries to the database by a single route. NOTE: I use the Sequelize ORM to…
-
-2
votes1
answer32
viewsExchange export version of Excel with PHP/Mysql
Guys, I have a code that exports my table from the database perfectly, but it exports it in excel 97 (2003), does anyone know any way to export this table in another version of excel and the file in…
-
-2
votes1
answer38
viewspandas and sqlalchemy
Hello, I’m trying to create a mysql database connection in a python program, follow the code import pandas as pd import sqlalchemy engine =…
-
-2
votes1
answer133
viewsDoubt in listing items with PDO and PHP 7
Hello, I’m trying to make a listing using PHP 7 and PDO and I’m not getting it. Until then I made this code <?php $con = new PDO("mysql: dbname = banco; host = localhost", "root", "senha"); $sql…
-
-2
votes1
answer28
viewsError in data editing page
good night! I have a page for editing the user data that is logged in at that time in the account, however, I am receiving an error message from the page: Here is the php code of the page: <?php…
-
-2
votes1
answer28
viewsHow to identify weekly clients that appear in one table and not another in sql?
Hey, all right, guys? Well, I need to identify weekly clients who have an active plan but didn’t use the plan that week. I have two tables, one that contains the type of client’s plan and another…
-
-2
votes1
answer34
viewsSum all records of an INT field in PHP and display it
Well, basically I need to add up all my records from my field valor of my table contas that’s like INT in the bank, the problem is that the result is giving "0,01", where I’m going wrong? Divided by…
-
-2
votes1
answer62
viewsDatabase - Mysql - Relationship between tables / INNER, LEFT, RIGHT JOIN
I am making a database using the Mysql Workbench and I am in need of a brief assistance. I have six entities in total. tb_people who are related to two other tb_clients and tb_adm entities (because…
-
-2
votes1
answer43
viewsINNER JOIN repeating data between tablets
Good afternoon, I have a table of clients and plans that have keys between them, and I need to list all clients and show the name of the plans if the client has any linked plan. Clients q have no…
-
-2
votes1
answer67
viewsShow advertiser only for advertisers
I am creating a classifieds page, I have the login and registration ready And when the user logs in takes the page to publish ad! When the person publishes the ad I am displaying that ad next to it…
-
-2
votes1
answer888
viewsPage with Reactjs consuming from an API
Yesterday I was having a problem in being able to create a page with nodejs for my API and with help from the community got me a north and I managed to solve that situation. What’s the idea? There…
-
-2
votes1
answer265
views"foreach" inside query using PHP PDO " $sql = $Pdo->prepare( )"
Good morning everyone, I’m trying to create a runtime view. For this I need to list all the fields of the table and play within the statement the problem is that I can’t transfer the $obj1[0] array…
-
-2
votes1
answer180
viewsPull output from mysqli_query using php
I’m trying to organize a ranking with some data from my DB in Mysql. I need to collect the data displayed in Query but does not come at all. See the image of the query with the data. Where I’m…
-
-2
votes1
answer176
viewsReal-time website with Node.JS
Come on, guys, can someone help me with this... I developed a fully dynamic website with Mysql database, that is, all the main elements of the main page are coming from the database, I do this using…