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
answer300
views -
1
votes1
answer1000
viewsConversion from . FRM to . SQL
I have a 300MB database and all I have are the FRM, MYI and MYD files. I need to convert the FRM files first to create the structure of the tables, I have already used the following tools and…
-
1
votes1
answer298
viewsSearch and display of results 2 tables mysqli/php
I wanted to do a search in 2 tables (news and photos) and then display the results of this query below. But the fields I have in each table are different and I’m not able to elaborate a way to…
-
1
votes0
answers17
viewsMysql grouping problem inside a Trigger
I have the following Rigger code, where it makes a select on the main tables (DADF311, DADF313.. ) to insert the result ready in the secondary table (DADF514): DELIMITER $$ CREATE TRIGGER ta_dadf311…
-
1
votes1
answer32
viewsPick up a user’s first and last entry
I have the following query: Sqlfiddle The question is as follows. In this table there are several interactions of several users in the same transaction. What I need is to take the last user’s…
mysqlasked 6 years, 2 months ago Layla Comparin 553 -
1
votes2
answers41
viewsFormat result of time
I have the following fields: I would like to format the result of my following Query: SELECT TIMEDIFF(primeiraSaida, primeiraEntrada) + TIMEDIFF(segundaSaida, segundaEntrada) FROM pontoentradasaida…
mysqlasked 6 years, 2 months ago Marcos Correia 123 -
1
votes1
answer84
viewsError - string C# for Crystal Report
When trying to pass the string from c# Windows Forms to Crystal Report following the procedure of the second image and the code below Crystal report shows the following error! Visual Studio…
-
1
votes3
answers1210
viewsSelect to bring the amount of certain records in related tables
Speak guys, is the following, in the MYSQL database I have these 3 tables: CONTROLS: Here I do the training entries performed. Note that it is possible to insert several employees in the same line…
-
1
votes1
answer80
viewsSearch the Database (Mysql) and create Sitemap in parts (PHP)
I have the following code to generate sitemap: <?php header("Content-type: text/xml"); echo'<?xml version=\'1.0\' encoding=\'UTF-8\'?>'; echo' <urlset…
-
1
votes1
answer145
viewsError in Count()
I need to put a website on the air (I didn’t make the site), and I need to adjust some things on it. I am facing a problem in a dynamic menu: when I am on the home page it gets ok, but if I browse…
-
1
votes0
answers27
viewserror in Session Codeigniter
I have a dynamic menu that does a search in the bank and fills this menu, when I’m at home it works normally but when I change the page the value returns null and generates error in count(), I…
-
1
votes0
answers219
viewssend Arduin integer number with esp8266 to mysql
I have an error when I send via ESP8266, the integer value with the name number, my code is as follows: #include <ESP8266WiFi.h> // Use this for WiFi instead of Ethernet.h #include…
-
1
votes1
answer50
viewsQuery with field as IN value
I’m trying to do a survey using INNER JOIN in table service, the scheduler field.serv_id is a string "vector" and its value in the database is: '1, 2' I did 3 Indsert’s in the service, the only…
-
1
votes1
answer36
viewsERROR MYSQLI BD MIGRATION
FRIENDS , I migrated of vps and after that I started to have problems with the connection of the comic mysql, I made some adjustments now I can not find the error , could help me please , I have a…
-
1
votes1
answer401
viewsLeft Outer Join Pulling Only Contained Data
I’m trying to do this research to know how many children and pregnant women each Victor meets but only this pulling the families that have pregnant women even putting the blessed LEFT OUTER JOIN, is…
-
1
votes2
answers70
viewsHelp with an associative table of friends
I have a table of friends, which has the following composition: id_friends (id of the relation) id_usuario_de (id of the user who sent the friend request) id_usuario_para (id of the user who…
-
1
votes0
answers19
viewsError with Data angular.js mysql PDO
Good afternoon, I’m having trouble doing UPDATE with date but the date always stays 0000-00-00. I’m using angular.js and mysql PDO. I have researched here on the forum some similar problems but so…
-
1
votes0
answers57
viewsProblem with PHP/Mysql Registration
good morning/afternoon/evening. I have a problem on my TCC site, specifically in the user registration. In the register, has 3 parts, one of personal data, one of phone and another of address, with…
-
1
votes2
answers324
viewsSQL Select return only one of several
have two tables. Table "user" which has 5 lines and 5 users. is the "location" table that has 20 records, using 5 Foreign key of user table ID When I use this select I made select u.nome from…
-
1
votes1
answer38
viewsHow to separate errors from a query in an expressjs api
What is the correct method to separate errors from a query? The current code compares the error manually with the message generated by mysql, in case the query may go wrong for several reasons,…
-
1
votes1
answer94
viewsHow to emulate ROW_NUMBER() in Mysql V5.7?
I know this is a common and well-documented issue in English, but there is little of it in Portuguese. So I’m going to take this opportunity and take this doubt in a simple and comprehensive way.…
mysqlasked 6 years, 1 month ago Jose Henrique 337 -
1
votes1
answer44
viewsError while listing database data
You’re making the following mistake : Notice: Undefined variable: denuncia in C: xampp htdocs Nise geral.php on line 262 Warning: Invalid argument supplied for foreach() in C: xampp htdocs Nise…
-
1
votes1
answer62
viewsDoes not insert information into the database
Good afternoon, I am trying to enter data in a database and I have as return the error message: "It was not possible to register the user". I’m using Xamp software, with Apache and Mysql installed.…
-
1
votes1
answer361
viewsHow do I leave NULL if $_POST is empty in the Mysql database?
Is there any way I can leave it as null fields that have not been filled in? When creating the table, fields have already been defined as DEFAULT NULL, but while doing the Insert - in the database…
-
1
votes1
answer21
views -
1
votes0
answers72
views -
1
votes1
answer279
viewsError handling exceptions - "Undefined object reference for an instance of an object"
public String IdentificarAcessoDAL(FuncionarioDTO acesso) { try { conexao.cmd.Connection = conexao.conexao; string recuperar = "SELECT CARGO.NOME_CARGO FROM LOGIN INNER JOIN FUNCIONARIO ON…
-
1
votes1
answer67
viewsList<> getResults returns list with equal elements
Hello. I have the following table in mysql: create table resultado( data varchar(10), premio varchar(3), loteria varchar(5), milhar varchar(10), primary key(data, premio, loteria) ); The class that…
-
1
votes0
answers99
viewsUpdate after Insert field
I’m trying to create a Trigger to update a value after inserting, or earlier if it worked. I have the following table: test Remembering that the field type date is timestamp and the default value is…
-
1
votes2
answers379
viewsSelect2 in multiple fields with the same name
I am making an order registration page, where you can register several products. To register the products users have the options to Produto, quantidade, valor, subtotal, if you want to add one more…
-
1
votes1
answer75
viewsHow to set only one row of the column in which all values in this column are equal?
I’m trying to set the column ocupado just one line at a time, something like: update suite set ocupado = 'S' where tipo = 'i'; But this instruction changes all rows in the column ocupado where tipo…
-
1
votes1
answer359
viewsHow do I not repeat RAND() results in php?
I need to create a simulation that will make a 5 question SELECT randomly. I’m using the ORDER BY RAND(), but the results are repeated, and I don’t know how I can fix it. I even created an array…
-
1
votes1
answer523
viewsImport CSV file to Mysql
I have a database with these two tables: TABELA CONTRATO id contrato pessoa_id TABELA TITULO id titulo valor vencimento contrato_id I need to import the column contrato, retrieve the ID of the…
-
1
votes0
answers38
viewsQuery call in php hangs other queries
Because when doing a first query to a call and then trying to do another php hangs? For example, run this stored simple file in php DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE…
-
1
votes0
answers32
viewsThe products in my table have an ID, how do I see which of these ID has not yet been used in another table?
I need to show the products that have not yet been sold (were not involved in any sale), grouped by Type and then by Manufacturer, and in ascending alphabetical order by name. I did some research…
mysqlasked 6 years, 1 month ago Matheus Rocha 31 -
1
votes1
answer80
viewsProhibit user to register 2 users with equal emails and matriculations
I wanted that when the users went to register, if they informed an existing email or enrollment in the bank give a message and it was forbidden to register in the system, in the code below it…
-
1
votes0
answers302
viewsYou have a syntax error in your SQL next to’T FOREGN_KEY_CHECKS=0' in line 1
I don’t know much about databases, so my knowledge of sql is minimal. A friend passed me a db so that I could edit and update the data of this (something that seems simple to me), but when trying to…
-
1
votes0
answers35
viewsMysql DUMP COMMAND in VB.NET
Folks good night I need to give this command in VB.NET SHELL but I’m not able to do it I already tried 3 hours I read a lot of things and I can’t think outside the box . Shell("CMD.exe /c cd \ &…
-
1
votes1
answer90
viewsInner Join with Where and multiple tables
I am mounting a query, where I need to Join between two tables (because the data will be in the main B but not in the complementary BC) and a third table that necessarily need data, which will…
-
1
votes3
answers770
viewsSend data to Database according to <select> tag via PHP
I’m making a form to send some data to the bank, to expedite a process, my question is the following, I have 5 systems that I need to update, so I made a select html. I need to send each option of…
-
1
votes1
answer90
views -
1
votes2
answers53
viewsI need to select which employees are allocated to which projects
I need to select which employees are allocated to which projects but when I run my code: select projeto.nome, funcionario.nome from projeto, funcionario it selects all names in all projects and not…
-
1
votes2
answers49
viewsUPDATE only in the last inserted rows
I’m importing some Excel spreadsheets via ETL into a relational database. The problem is that in order for me to achieve the relationship of the tables, I am using queries for the insertion of…
-
1
votes1
answer72
viewsTake larger ID and insert Bank
My doubt is the following need to take the ID with higher value and enter the information in it. The PHP file is working but I need it to identify the ID with higher VALUE and insert it instead of…
-
1
votes1
answer74
viewsHow to determine the type of data to use in this flexible case?
The project consists of a database for RPG sheets (D&D and the like). It was like this: Database record sheet Tables character system raccoon class attribute personagem_attribute Relationships…
-
1
votes1
answer211
viewsHow to work with Foreign Keys in C# ASP . NET Core?
Good night, you guys. I am a beginner in C# ASP . NET Core and I am facing problems with Foreign Key. I need to popular a combobox with data from a database table. Next is my Seller model using…
-
1
votes1
answer53
viewsDo not re-enter an existing login user
I have a JPA problem with Java. I built a login system, using a self-generated ID, but every time I run the program it creates another user in the database, with a different id but same credentials.…
-
1
votes1
answer202
viewsError saving monetary values in Mysql database
I have a table column from my bank called salario_base where it is of the type Decimal(7,2). I enter the value in a textbox, I convert the same and pass this and other variables to an insert class…
-
1
votes1
answer38
viewsReturning error in insert function
Good morning. My function is returning an error, but I don’t know what you mean, I used the Singleton standard to do, so I will post 2 codes: <?php class IndicadoDAO{ private $idIndicado; private…
-
1
votes1
answer82
viewsSymfony 4 - How to save images with Formbuilder (Filetype) in Base64 in the Database(Mysql)?
Hello, I’m trying to make a form where the user just inserts an image. In theory, the image should be stored as a Blob file (Base64) in the database, but Symfony is storing "tmp/php/random value" in…