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
answer48
viewsRecover the highest value in a column according to the repetition of the second
Good night to you all! I have a system in my company that records an entire value in a table every moment of the day. It also records the date and time in Datetime format; The table in the bank is…
-
0
votes1
answer49
viewsI’m not sure my class is really correct
some time ago I decided to assemble this class to make my life easier, I will not put it complete not to be a post too big, this class to make an Insert you order like this…
-
0
votes1
answer127
views -
0
votes0
answers37
viewsSort words coming from Mysql BD according to their respective columns
I have the following table: tb_dispensa_medica Iddispensa | Idempresa | Idusuario | PS | SS | TS | QS PS, SS, TS and QS columns are CHAR(1) type that store S or N strings. I need to sort by name…
-
0
votes0
answers105
viewsquery update does not update the database because of 1 field
Hi, I have a very strange problem. When I run my UPDATE in the query by filling in all fields except the PRODUCT VALUE, it simply doesn’t update anything. If I fill in the PRODUCT VALUE field it…
-
0
votes1
answer505
viewsCheck if date is valid in Mysql database
Good afternoon programmers, I have a problem in the trial where I need to print all the dates of the month, I created a loop until the day 31, but there is month that is less days that gives error,…
-
0
votes1
answer69
viewsHow to pull data from a cell in the Data Grid?
My database data is showing up on a DataGrid and I wanted to make them go to the TextBoxs as soon as I gave two Clicks in the specific Cell for editing, how can I do it ? Detail, the database was…
-
0
votes1
answer278
viewsHow to change the function of my save button, to change
I have some data registered in the database, and I wanted to know how to change the function of inserting in the database to change the data, using a Button, I can pull the dice and throw them at us…
-
0
votes0
answers30
viewsDefine foreign key between tables
I need to make a Mysql database, Escola, with entities aluno, professor and disciplina, linked via foreign key. I made mine script, but it’s making a mistake. Could you help me? Follow what I did:…
-
0
votes1
answer54
viewsSQL grouping product balance by company
What I need to do is I need to put together a report that will return the stock of products by individual companies. select must return the following:…
-
0
votes1
answer59
viewsAdd data from two tables with same parameters
I have two tables, titlospagar and titlosavulsos and in both I have the field scoreMotorista and I would like to add up the values of each I would like to do a query, gathering their data in a…
-
0
votes1
answer224
viewsHow do bindValue in PHP when the value is an array?
I’m trying to pass more than an id to search in my program but the search only brings an object with the data of the first id, query code in sql: public static function listar_servidores_ids($id){…
-
0
votes1
answer224
viewsHow to fill php variable via jquery/ajax?
I am developing a system of messages in php + mysql and in the "inbox" I am displaying the messages in table formatted, using the plugin datatables. I happen to want to open the message in a modal…
-
0
votes1
answer350
viewsUpdate in a specific field in Django 2.0
I have the following Model: class Venda(models.Model): id = models.AutoField(u'AÇAIEX', primary_key=True) hora_saida = models.TimeField(max_length=6) responsavel_frete =…
-
0
votes2
answers108
viewsHow to make INNER JOIN between two tables?
I need to join the fields of the table "employees" and "clients". The problem is that the data repeats,: I believe it has something to do with a foreign key and a primary key. The first "name" field…
mysqlasked 6 years ago Luiz Antônio 29 -
0
votes0
answers130
viewsGROUP_CONCAT bringing incomplete response
I am trying to bring all the product names (even the repeated ones) I have registered in a spreadsheet, but the code is stopping in the middle of the process. Can anyone tell me why ? Is there a…
-
0
votes1
answer69
viewsPlacing information within the specific user
I need the registered user to have access only to his contract user 1 contrato1 user 2 contrato2 I already have the contracts in . doc I need that when the user logs into the.php panel he can see…
-
0
votes1
answer50
viewsHow to do web design with wildfly 16?
I can’t see a HTML File, Webcontent, from file testing through the link (localhost:8080/Loucademia/teste.html), gives error(404); which means that I am not able to access it through the browser. My…
-
0
votes3
answers69
viewsSQL syntax error in a Flask application
I am developing a game display system, with user login necessary to add games to this list, but when I try to run the query, I get a syntax error. It follows the code that prepares the database (has…
-
0
votes0
answers60
viewsIN() command in mysql with C#
Hello, I have a problem that I can not solve. I want to make a SELECT at the base using the command IN(@grupo). Where the @group is a string with the ids separated by comma Exp(1,2,4). However when…
-
0
votes1
answer100
viewsPlease help me filter by category in PHP?
have 2 tables , the articles table and the table categorie_article in the database, what I want is the following, that appear all the names of registered categories (ex CATEGORIA1, categoria2, etc)…
-
0
votes1
answer144
viewsHow do I connect a Heidisql database to Visual Studio using Report Viewer packages?
Follow the code of my comic book from Heidisql: CREATE DATABASE ProdPacote; USE ProdPacote; CREATE TABLE Produto( ID_Produto INT PRIMARY KEY AUTO_INCREMENT, Nome VARCHAR (200) NOT NULL, Descricao…
-
0
votes2
answers192
viewsHow to update the database from a form using PDO?
I have 2 files, the 1° is the form q will carry out the sending of the data and the 2° will process the data and update in the database, but the problem is q this is not happening, follow the code…
-
0
votes2
answers265
viewsORDER BY Mysql - Reporting organisation
I have a chat and would like to display the contacts according to the date of the last message, I thought of many ways to do this but it is not working in any way. How could I bring this data…
-
0
votes1
answer80
viewsI want to query several words independently in mysql
Good morning I have an input that generates a variable $phrase with his dice. $phrase = "%". $phrase."%"; In php Mysql I refer to sql: $comandoSql = select id from items where descricao like ?;…
-
0
votes1
answer131
viewsHow to place two Tables in a Datagridview?
I have a program in which I wanted to present two tables of my database in one datagridview, these two tables have relation of n to n but I don’t know how I can see the second table. Step to…
-
0
votes1
answer181
viewsInvalid Parameter number - PHP
I’m using the same code I use to make the UPDATE from another table in my bank, but when I use the code for my bank’s post table error, the only thing that’s changing is the image. I have no idea…
-
0
votes1
answer37
viewsProblem when trying to display data in a table - php
I’m having a problem trying to show nproposta, information on the application and dataregistada. Thanks in advance for any help. Thank you <?php…
-
0
votes1
answer55
viewsDjango - Charfield creates Int field in BD
I have a simple project here, with two models that contain an attribute called phone in both. class Medico (models.Model): nome = models.CharField(max_length=50) endereco =…
-
0
votes1
answer177
viewssub-query with main query parameter
I have this query: SELECT id_arquivo, nome_arquivo, etapa, em_uso, em_uso_por, processo_concluido, obs_temp_etapa_atual, cod_funcionario_dev, status_devolucao, devolvido_por,…
-
0
votes1
answer141
viewsQuestions about dynamic system update of Dashboard
I am creating a task management system and I have a Dashboard that displays the activity updates. The problem is that I can only update this Dashboard when I refresh the page because I am displaying…
-
0
votes1
answer42
viewsSELECT in 3 database tables with specifications
I have three tables in the bank, one for companies, another for employees and another for guides. I am trying to make a SELECT that brings all companies that have any employee linked to it (there is…
-
0
votes1
answer67
viewsCan anyone tell me why if Else is not returning Is it?
Come on, guys, I’ll try to be as enlightening as possible on the question. Next: I have an if Else that is done by a Pdo query, when I type an existing Cpf it does the job properly, until then ok!…
-
0
votes2
answers64
viewsHow to count weekly single accesses in Mysql
I have this query in Mysql to check the unique accesses to a system of mine: SELECT COUNT(DISTINCT id_usuario) AS total, dia FROM acesso WHERE (dia BETWEEN '2018-01-21' AND '2019-01-21') GROUP BY…
mysqlasked 6 years ago caiocafardo 1,897 -
0
votes1
answer32
viewsHow to know which link class to select with php
I’m creating a website that has information from multiple vendors accessed by an administrator. To display vendor data, I have their names in a table by selecting them from a Mysql database. Taking…
-
0
votes1
answer57
viewsError inserting data with Mysql and Laravel
I have a table called "item" in which I need to enter data, but for some reason does not process the Insert. I’m new to backend so I don’t know if there is any restriction on the table that prevents…
-
0
votes1
answer37
viewsSearch Using Combo box
I’m with a ComboBox that when I select Active or Inactive status it empties my DataGrid What I’d like him to do is select one of the two Options and bring all records with Active Status, for an…
-
0
votes1
answer36
viewsSQL for specific page
I’m making my own paging code from a table of records, and in my case I don’t want only the requested page to come by AJAX instead of all pages to be manipulated by Javascript. The information of…
-
0
votes1
answer41
viewsCalculation of two BD fields in a function
Good Afternoon, to calculate the budget of my works I use a query in my controller ode makes the sum of the fields , being few records there is no problem but if there are 500, 1000 records this…
-
0
votes1
answer40
viewsIs it possible to press a button on a form and it takes the $_POST from the other form?
I have a function that registers client If the user presses the sign-up button the client will perform the function If the user press the button to register phone, will perform the same function and…
-
0
votes1
answer245
viewsSeparate fields by TAB
I’m making an appointment SQL and returning the results in a file . txt, so far so good! It has now been requested that the contents of the file be separated by TAB (ASCII 9 ). I did a lot of…
-
0
votes1
answer56
viewsError bringing a Log Data to a label
Hi, I’m trying to bring in for a Label a database registration data, for example: when the person selects the product on ComboBox the price of the product on label However, I don’t think I’m getting…
-
0
votes0
answers955
viewsImport Excel data to Mysql
I am trying to make an import of an excel spreadsheet with 536 thousand records by mysql Workbench I saved the spreadsheet as csv but at the time of import it can import all lines but it pulls only…
-
0
votes1
answer504
viewsInsert array into database using PHP and SQL
I’m trying to insert values from a array inside the database using PHP, but I’m having difficulty in the applied method. It’s the first time I use arrays for that reason. My current code is:…
-
0
votes1
answer92
viewsError inserting CSV data into Mysql with Python
I am writing a Python code that inserts the data of a CSV into a Mysql table. if os.path.isfile('\\offline.csv'): try: csv = csv.reader(open('\\offline.csv', encoding='utf-8')) for row in csv: conn…
-
0
votes2
answers995
viewsis not a GROUP BY expression
Hello . I am trying to execute a certain Query on Oracle and I am getting the following error : "is not a GROUP BY expression". Below is the list of tables and query: BILL NRO_CONTA|COD_AGENCIA|NOME…
-
0
votes0
answers47
viewsSave populated form data to another table
The code below receives data from a table that I can edit and save again, but I was trying to use this data and insert them in another table but I’m not getting. Code receiving the data: <?php…
-
0
votes2
answers49
viewsError running mysql php query
I am getting the following error while executing the query 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'protetic_sistema.cad_trabalho.id_trabalho'…
-
0
votes1
answer33
viewsInner Join question with Prepared statement
Hello, I was using select that way and working perfectly $id = (int)$_GET["id"]; $banco = $mysqli->query("SELECT os.os_solicitado,os.os_status,cliente.cliente_emailfinanceiro FROM os left join…
-
0
votes1
answer77
viewsHow to store and display time only? C# Mysql
I need to take an input time and an output two textboxs, store in the bank and later display, my code is like this: //Cadastro //No evento do botão cadastrar entradaSaida.HrEntrada =…