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
answer60
viewsTake data from two tables at the same time, just when you log in
I’m trying to get data from two tables right at the beginning of the session when the user logs in, when I use the SELECT * FROM usuarios, orders WHERE email = '$login' and senha= '$senha' I can log…
-
0
votes1
answer42
viewsLogin: Mysql search returns only one object
In a login system, I take the e-mail and password given by the user by a form and see if there is any identical information in the database. $conn = new mysqli("localhost", "root", "", "prisma");…
-
0
votes1
answer117
viewsHow to know if the database connection is correct PHP
I’m 16 hours away trying to make a database connection work and I’m not getting it, I don’t know what I’m doing wrong, I’m currently using shaman, and I’m working for a client who needs to access…
-
0
votes1
answer180
viewsAutomatic generation of Controllers and Views with . NET Entity Framework and Mysql
EDIT: I solved the problem below and others that appeared later. See my answer. I created a Business project using the Entity Framework (EF) Code First approach. I have a database in Mysql with 8…
-
0
votes2
answers37
viewsProblem with using Else
Good evening, I’m having trouble that is the following, on the requested page if the user has 1 order or more it displays the request, if the user has no request appears the message "You have no…
-
0
votes2
answers246
viewsQuery Mysql to count contracts with INNER JOIN
Hello, relating the following tables: Contract table tb_contrato id credor_id num_contrato Invoice Table tb_fatura id contrato_id num_fatura dt_vencimento valor Parameters credor = 1 valor inicial =…
-
0
votes2
answers299
viewsCodeigniter - How to make a select in the database query?
I’m doing a list application of patients for surgery and using the CodeIgniter and Bootstrap. My doubt is how to make a select in the database query so that it shows me in the table only the results…
-
0
votes0
answers61
viewsROLLUP and HAVING in the same consultation
The query below returns the sum of 24 accounts, using the ROLLUP and without the clause HAVING, so far so good, but when I use the clause HAVING shortly after the ROLLUP should return me the sum of…
-
0
votes1
answer80
viewsHow to use two database columns as a sort criteria for a Query?
Hello, Could you help me with this question? I’m making a query in MYSQL you need to search the records database and sort them by two different columns using ORDER BY. I’m using the query following,…
-
0
votes1
answer86
views -
0
votes1
answer67
viewsQuery UPDATE entire table from COUNT (MYSQL)
Hello, I’m new to programming, and I have a slight background in databases. I’d like some help, since I haven’t found a case that looks like mine. Scenario: I’m setting up a workshop environment…
-
0
votes1
answer257
viewsPython/Mysql - Exporting CSV files
Hello, I am developing an application to extract files from my database, in csv. The file is normally generated with the data that is in the database, but if I insert more data into the database, it…
-
0
votes2
answers104
viewsCombobox redeem ID value
public void SalvarProfessor(Professor professores) { try { AbrirConexao(); comando = new MySqlCommand("INSERT INTO professores (nome, idade, genero, email, id_especialidade) VALUES (@nome, @idade,…
-
0
votes1
answer58
viewsMerge 2 MYSQL query into same table
I have this consultation where it results the date, the count, and the sum of products of the entry $result_entrada_mes = "SELECT DATE_FORMAT(data,'%m/%Y') as data, COUNT(quantidade) as qnt,…
mysqlasked 5 years, 3 months ago Caio Alexandre 1 -
0
votes2
answers182
viewsSELECT in N:N relationship without using INNER JOIN
I need an SQL equivalent to a SELECT using INNER JOIN as I am using Sphinxsearch and read that it does not support INNER JOIN. I know you can do it using Sub-Query but I can’t remember how you do…
-
0
votes1
answer147
viewsDISTINCT and GROUP BY do not work on Codeigniter
everything jewel? Recently I took a job to do, and the requester was needing to list some data on a table. I was going to ask all the questions here, but I decided to divide them into parts because…
-
0
votes1
answer58
viewsInsert data in multiple related tables
I started a project at the same time that I started studies in a database. I created a customer phone only table and another table for all customer data, including phone as Foreign key. in the phone…
-
0
votes3
answers112
viewsWHERE condition does not work
I’m trying to put a condition in a function and it’s not working... I tried to put this condition but it didn’t work $this->db->where('idUser =', $this->session->userdata('id')); Usually…
-
0
votes2
answers103
viewsError giving python Mysql Insert
I have the table in my bank: create table tweets( ID_Tweet int not null auto_increment, ID_Candidato int not null, Conteudo_Tweet varchar(470) not null, constraint PK_tweets_ID primary key…
-
0
votes1
answer60
viewsTwo WHERE with two independent conditionals
Fala Pessoal, I am mounting a query with the objective of bringing 2 columns that do the same query but with 2 different conditions. ex: SELECT COUNT(MAX(l.created_at))as last_login_x1,…
-
0
votes2
answers160
viewsStored Procedures in Mysql runs but cannot access to view or edit
When I had an account on a shared server at Hostgator(those very basic plans) I created some Stored Procedures in Mysql via my Navicat, months later I had to format my machine and migrated my plan…
-
0
votes1
answer564
views -
0
votes1
answer47
viewsSearch for terms out of order php MYSQL
Hello folks was doing a search around here and would like to know how do I search for out-of-order terms example I have a table with the following name: name_prod in it is an example of a name:…
-
0
votes1
answer689
viewsInsert values from a variable into the database with nodejs, mysql and sequelize
I’m trying to input into the database the contents of the variables: token and now. The respective fields in the table users of the bank are: passwordResetToken and passwordResetExpires. I can…
-
0
votes0
answers59
viewsRescue Data to Create Dynamic Tables and Charts
all right? I have a question here in a project I picked up, I am not an expert in database and much less in php, I am in the learning phase. I need a function to collect some database data in a way…
-
0
votes1
answer40
viewsGet 12 months of table date for group by and continue taking data from another table with variable date using LEFT JOIN
My table 'a', has a certain number of dates, from January to December. My table 'b', is a calendar table from 2014 to 2100. My goal is to give a group by from January to December, however in my…
mysqlasked 5 years, 2 months ago Andrews Gomes 458 -
0
votes0
answers43
viewsSchedule Deletion of Record
Hello, how are you? All right? I’ll explain my situation and already show you what I have, come on: So, I need to schedule the deletion of a data from SQL, I have a system that publishes polls, in…
-
0
votes1
answer276
viewsTurn python script into database executable
I created a very simple python program to organize my work and tests, but I would like to make it portable to use on any computer. I know pyinstaller and cx_Freeze to turn the apps into executables,…
-
0
votes1
answer39
viewschange webconfig mysql+ Connection. NET
I have this site using Entity framework running normally in mysql localhost database, now I want to put on a server, I have tried to change several times the conneciton string, but it gives two…
-
0
votes1
answer29
viewsSlow problem with CAST in consultation
I need a help in a data conversion that I imagine is the problem of slowness in a query of mine. I am using Mysql 5.6. In the second query below, in the return of the MRESULT variable, when I use…
-
0
votes0
answers237
viewsDatabase query with php and mysqli Does not return data as it should
I am listing some information from the mysql database, something very simple at first but I have the following problem: I run the code to search from a form and list the data according to the…
-
0
votes1
answer315
viewsNo suitable driver found for jdbc Sqlstate: 08001 Vendorerror: 0
public static void main(String[] args){ private String DRIVER = "com.mysql.jdbc.Driver"; Connection con= null; try { con =…
-
0
votes1
answer96
viewsProblem to pass a variable from one form to another
beauty? I have a problem with a login of a system that I am creating, in which according to the type of user of the client, it will open the next form with some visible components or not. When I…
-
0
votes1
answer49
viewsgroup_contact using left Join mysql and separator
Good afternoon, folks. I’m having a question how to mount a query using group_concat. I have 2 tables: Prova ID Name Respostas_ID Status 1 Teste 1 1,2 1 2 Teste 2 2,4,5 1 3 Teste 3 4,5 0 On the…
-
0
votes1
answer260
viewsMultiply two columns in a select With Groupby
How Can I Do This Multiplication? the table looks like this: What has to be done is to group disciplines 11 and 13, count how many 'sit' F and Null have and multiply by 'qntd_aula'... I managed to…
-
0
votes0
answers39
viewsWhat is the difference between MD5, SHA and SHA 2 in MYSQL and which is most recommended for storing information in the database?
I usually store users' passwords via MD5 in the database. Being that I participate in a group, and the staff there said that it is not recommended to use MD5 for storing data in the database, as it…
mysqlasked 5 years, 2 months ago Gato de Schrödinger 2,367 -
0
votes1
answer85
viewsHow to condition select in another table row in Mysql?
I’m a beginner when it comes to Mysql language and I’m trying to filter some information I need to get out of a table. Basically I have data of individuals in consecutive years (2003, 2004, 2005)…
-
0
votes1
answer47
viewsDelete from duplicate records
I have a basis where the records exist in the duplicate identifier number, in some scenarios the date of the newer record differs from the old one, but the number and the same (I have to delete the…
-
0
votes1
answer103
viewsExecsql does not allow the field not to be changed
Whoa, whoa, guys, whoa. Newbie here Every time I click on change and then click on save (without making changes of record) returns me error . Any idea how to fix? some kind of check on whether there…
-
0
votes1
answer82
viewsissue when connecting mysql to java using jdbc
LoginDAO.java: public class LoginDAO { private static String sql = "select * from login where login=? and senha=?"; private static String url = "jdbc:mysql://localhost:3306/escola"; private static…
-
0
votes2
answers142
viewsError with.mysql.jdbc.exceptions.jdbc4.Mysqlintegrityconstraintviolationexception: Cannot add or update a Child Row: a Foreign key Constraint fails
Good people, I have this mistake and I can’t see the solution. I’m working on my first post-college project and I’m in need of some guidance. I have tables: Client, Ordemdeservico, Budget, Service…
-
0
votes0
answers34
viewsField timestamp does not insert in Mariadb
I have a local server to program using shaman and his database is mariaDB. I made a system that inserts a record in the table but the data_separation field is a timestamp that by default is NULL. At…
-
0
votes1
answer41
viewsFulltext Mysql with Spring Boot
Good morning, I am trying to make a fulltext in mysql with spring boot, in mysql when I do the test with the sql command, the result brings back correctly, but when I pass the spring boot sql…
-
0
votes2
answers206
views1 select with two columns
Well, I’m performing a select between two dates that returns me two values. Quantity of purchases paid in CASH. Amount of purchases paid by credit card. I’m doing it this way, SELECT…
-
0
votes0
answers50
viewsProcedure is only running the first part, why?
Good afternoon, I have two tables, one table tb_addresses with attributes idaddress int(11), idperson int(11), desaddres varchar(128), descomplement varchar(128) And there is a primary key of the…
-
0
votes2
answers33
viewsProblem connecting tables using a foreign key
Good afternoon, I have a little problem making the link between the tables, I need to connect the athlete table and make the link with the document sending organ table. The following error appears…
-
0
votes1
answer528
viewsMysql - Cannot add or update a Child Row: a Foreign key Constraint fails (`areas_knowledge`. `sub_areas`,
Hello, I am doing a job that consists in developing a system to manage projects and etc. In this system I need to have a table with the knowledge areas of cnpq. I’m taking the Grande Areas, Areas,…
-
0
votes1
answer64
viewsPHP MYSQL - Login System - Accepts numeric values only
Hi. I have a problem... I’ve googled enough about it but I haven’t found anything successful. my login system is only accepting numeric passwords. example: User: so-and-so, password: 123 - that way…
-
0
votes1
answer24
viewsWhen filter no record appears in the table
When I filter in table no record appears. No error only no record appears. I wanted to show you when to filter. Could you help me? Code: <form method="POST"> Data Inicial <input…
-
0
votes0
answers187
viewsError executing add-Migration . Entity Framework Core
I am using version 2.2.4 of Ef core and version 3.0.5 preview of . net core sdk The mistake is : Unable to create an object of type 'AppDbContext'. For the different patterns supported at design…