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
votes0
answers70
viewsInsert/get multiple tables without Id
Good afternoon guys, I’m having a problem affecting me a few days already. The situation is as follows, I have a simple relationship: There are tables person, street, neighborhood, city, state,…
-
0
votes1
answer131
viewsHow to create a Mysql Trigger with more than one cursor
I’m trying to update two tables using the same Rigger, but it only updates the sales table, but no errors occur. Follows code: DELIMITER $$ CREATE TRIGGER depoisInsertNotas AFTER INSERT ON notas FOR…
-
0
votes2
answers842
viewsSharp word problem from Mysql database
I’m using this query to show data coming from a Moodle database, but the words that have accents are shown with a query, I’ve used two types of charset utf-8 and ISO-8859-1 but the error continues,…
-
0
votes1
answer88
viewsPass-through id to another Ionic 3 page (Restful API with php)
Good afternoon, I’m making an application in Ionic 3 using the Restful API with php for connection to the MYSQL database and my app lists rooms of a house with its respective consumption, follows…
-
0
votes1
answer339
viewsTrigger Problem After Update with Mysql Internal Update
I am creating a Trigger in mysql, Trigger is created but when I update the flag to test mysql returns me this error ERROR 1442 (HY000): Can't update table 'aux_Batelada' in stored function/trigger…
-
0
votes0
answers40
viewsMysql Read HTTP URL
I would like mysql to read a url through a SELECT I searched and saw that you have an answer here. I did the whole procedure as it is in this link, but to no avail select would call the url as in…
-
0
votes0
answers81
viewshow I save variable values in a mysql database
I’m trying to create a facial recognition system using Opencv to record users' access to the school’s lab but the problem is that I’m not being able to save the access time information of each user…
-
0
votes2
answers115
viewsReplace with variable - mysql
How can I do Replace using a variable? A certain variável receives values from a query, so I need to make a Replace in a given column, with the obtained values ,how can I do this? follows example in…
-
0
votes1
answer309
viewsFilter with select in php
I have this code with the 3 selects to filter a query: <form class="shadowbox6" action="" method="post"> <strong><label for="Estado Encomenda">Estado…
-
0
votes0
answers20
viewsassign last field of a table to an input text
I have a chart that stores a vehicle’s supplies and would like to make the following code work. I need to take the last record with the odometer mileage and already bring the specific input text,…
-
0
votes1
answer79
viewsSum of Mysql column values
I have the following Mysql tables: CREATE TABLE IF NOT EXISTS `tcc2`.`catalogo` ( `idPHL` BIGINT(20) UNSIGNED NOT NULL, `isbn` VARCHAR(15) NULL DEFAULT NULL, `titulo` LONGTEXT , `autor` LONGTEXT…
mysqlasked 6 years, 8 months ago Costa.Gustavo 249 -
0
votes1
answer377
viewsError 1054 in Database
A Database Error Occurred Error Number: 1054 Unknown column 'reference.idReference' in 'on clause' SELECT os., clientes., facas., usuarios.email, usuarios.nome, referencia. FROM os JOIN clientes ON…
-
0
votes2
answers215
viewsProblem inserting data into a table containing foreign keys
Hello, everybody! Well... here’s my problem: I have a Mysql database that has 3 tables (Client, Event, Equipment). The event table has two foreign keys, the first of them referencing the id of the…
-
0
votes0
answers35
viewsDifference in performance of an application with similar scenarios
This weekend we deployed an application based on the Magento framework, which has been thoroughly tested in various scenarios, with high load of users making various requests to the database, such…
-
0
votes2
answers54
viewsProblem in the JSP Controller class
Hello, I need help, I have the problem in my system when I send an edit command. When I click on the edit button of the table row that I want, the screen turns white and does not show the options to…
-
0
votes1
answer244
viewsSelect with Inner Join
Good afternoon, I am making an app where I need to list all rooms of a user and the last recorded consumption of each room, only that my code search wrong, if a room has more than one consumption it…
-
0
votes1
answer522
viewsProblem using parameter in Preparedstatement
I wonder if there is any problem in using the variable "parameter" after "AND", because when I tested putting the column name directly in SQL it worked and when I try to pass the column name with…
-
0
votes0
answers250
viewsUpdate Ocomon Connection to PHP7
After upgrading the php version from 5 to 7 the system does not open, the mysql_connect function was discontinued I tried using mysqli and could not make it work. Error: Fatal error: Uncaught Error:…
-
0
votes2
answers59
viewsError in data received in PHP
This error appeared after hosting migration. Warning: number_format() expects parameter 1 to be float, string given in…
-
0
votes1
answer72
viewsHow to print several textarea (used with Tinymce), which are written in BLOB, in a single PDF?
I have several textarea (more than 20), on different pages of PHP and use Tinymce as editor of all these textarea. All are written to Mysql as BLOB, since all textarea allows text and image, and…
-
0
votes1
answer1101
viewsConnection being refused
Following this tutorial of Vedovelli about Ode with restify and mysql, I implemented on the server with pm2. Only after a few days the connection began to be refused Is showing that message: errno:…
-
0
votes2
answers901
viewsHow to use Multiple select in PHP form to query in MYSQL
I have a search with a select that can select more than one option, but I don’t know how to make them search all the selected options. Currently it does the search, inserts the values in the url (I…
-
0
votes2
answers9463
viewsMysql query error - Warning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, Object Given in
Hello, I am making a query with PHP and am connecting to the normal database, however when returning the query and mounting in the table is returning the error: Warning: mysqli_fetch_array() expects…
-
0
votes1
answer68
viewsHelp with Join in Mysql
I found several questions/answers about John on the site, but I still can’t create the command I need. What I need is the following: I have the following tables: item (I have two entries) id…
-
0
votes0
answers350
viewsHow to Paginate using PHP and MYSQL
I have a simple query that brings the results and assembles a table and I wanted after the table to come a pagination: (), but I don’t know how to do. The consultation is like this:…
-
0
votes1
answer271
viewsCan you create a rule in MYSQL to divide the value of one column by another?
I want to know the average of the values (value m2) in a table using AVG() (or otherwise). I have a table in MYSQL with the columns id, total value (Total value), value m2 (Value per m²) and area.…
-
0
votes1
answer74
viewsSeparate return from a table to a Timeline
I am creating a Timeline where there may be more than one user update per day. I need my return sql to already compare the dates and I can separate $sql = "SELECT * FROM tb_timeline JOIN…
-
0
votes1
answer83
viewsHow to save an array to separate lines in DB
How can I send a textarea containing multiple names, one per line, so that each line is a record in the database? in addition also to each line receive the amount sent per school and class, I am…
-
0
votes1
answer23
viewsInformation is off the table in while
Only the first information from tbody is shown the others appear however in lines outside the table. What may be making this happen? follows below the code snippet: <?php } }else { $sqle =…
-
0
votes0
answers49
viewsMysql and PHP SQL_CAL_FOUND_ROWS and FOUND_ROWS()
I am trying to create a data display list that returns the TOTAL of records for me to run after paging. To avoid making 2 queries in a database with more than 5 thousand records for the criteria I…
-
0
votes1
answer119
viewsRecover data in database by checkbox
Good afternoon I am having difficulties in recovering the data in the database via checkbox. <div class="container"> <div class="row"> <form action="resultado.php" multiple…
-
0
votes0
answers96
viewsGet the balance of the previous month every month dynamically
How do I get the previous month dynamically; I have the Inputs and Outputs. In my report I show the Balance of the month (Inputs - Outputs), then I show the balance of the previous month, This works…
-
0
votes1
answer91
viewscPanel xmlapi.php does not create Mysql BD
I have a dedicated server on Hostgator with access to WHM. Yesterday it was suggested to update the WHM itself and cPanel to the new version 74.0.4 From this it was no longer possible to create…
-
0
votes1
answer99
viewsuser checking problem already exists in mysql nodejs
I’m having trouble getting it working or checking if the user already exists dynamically. Basically I want that when typing the user name says whether or not I am using the nodejs with express and…
-
0
votes0
answers125
viewsMysql connection via Ipv6
How can I connect to mysql using Ipv6? I am using a Debian Linux Virtual Machine (VM) and am trying to connect via prompt When I try like this: mysql --host=9999:9999:9999:1:xxx9:x999:2b23:ccab…
-
0
votes0
answers184
viewsProblems running Mysql function using Delphi Firedac 10.1
In a Mysql database I have a function (not Procedure) fully functional, I can access normally within heidisql. At Delphi, I’ll tell you what function ExecutarFuncaoSQL(sFuncao: string; aParams:…
-
0
votes1
answer265
viewsExport DB table in csv format with columns separated by semicolons
I can already export in CSV, but the columns are coming apart by vírgula, how to make them come apart by ponto e vírgula? My code: <?php //export.php if(isset($_POST["export"])) { $connect =…
-
0
votes1
answer68
viewsRegistration is not being sent to the database
When I use 'Insert into noticias set ? ', to register in the bank, it is simply not registered Model: module.exports = function() { ... this.salvarNoticia = function(noticia, connection, callback) {…
-
0
votes1
answer82
viewsPass Mysql result to Highcharts
I have the following array, and I need to convert it for Highcharts to interpret and generate the chart, as I can iterate my array, since it returns the duplicate region but with different sale…
-
0
votes2
answers83
viewsshow input when selecting an optin inside while in php
Good morning! Here’s the thing, I got a combobox which displays all the records of a table, until that part I managed to unroll. However, I need to show an input when one of these records is…
-
0
votes1
answer33
viewsPick up bank record and if duplicated, show only one
I have a table in the bank called orders, where the control number can be duplicated, because the customer in the same order can buy 2 items, IE, each row will insert a product purchased but with…
mysqlasked 6 years, 8 months ago Eduardo Honorato 1 -
0
votes1
answer31
viewsCount mysql records in X Y format to display in Wizard style form
Hello, I have a problem to count the records of a table in the database and show it as in this example: 1(X) of 10(Y) when clicking on "next" of the form would be 2(X) of 10(Y) and so on, as the…
-
0
votes1
answer31
viewsHow to search for data in MYSQL using Regular Expressions?
It is necessary to compare data from the MYSQL database, but the data to be compared is not extremely equal. MYSQL LIKE does not work in this case because there are some variables in this query. To…
-
0
votes1
answer174
viewsCompare two tables in mysql by grouping the main table and listing the result of the second table
Hello! I will explain from the beginning.. I am comparing the following tables accounts with clientes select uses the user_id to find all customers with same users_id2 on the table clientes as…
-
0
votes4
answers1283
viewsHow to save form image directory in the database
In the system I am developing has a form with a field where the user can attach an image. After saving the form, the user wants to view the record including the image, so I thought about saving the…
-
0
votes3
answers153
viewsGet the sum of authors' books with Mysql
I’m starting with sql and I’m trying to get the sum of all books of each user in the cart table, but I’m not getting. drop table if exists carrinho_de_compras; drop table if exists usuario; drop…
-
0
votes2
answers1251
viewsForeign key for different tables (Mysql)
When executing the error query stating that it is not possible to create the Foreign Keys, I looked in the documentation and did not understand right if this code is possible or not. create table…
-
0
votes2
answers54
viewsOnly one line as true, MYSQL - Codeigniter
Hello! Since I have the following table: DROP TABLE IF EXISTS `tb_conta`; CREATE TABLE IF NOT EXISTS `tb_conta` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `nome` VARCHAR(255) NOT NULL, `tipo`…
-
0
votes0
answers24
viewsmysql relations in Laravel 5.5
I’m trying to model with Laravel a database for purchases, in my mysql relations are like this, so I modeled on Laravel, for the associative table "vendor_detail_item" I used "belongstoMany"…
-
0
votes1
answer97
viewsReport Viewer - app.config unknowingly
I am unable to make a Report Viewer connection with Mysql, it does not appear in the "Choose Data Source" list. I believe that the problem is in the "app.config" that is disfigured someone could…