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
answer229
viewsMYSQL - The used SELECT statements have a Different number of Columns
I have a Mail Query that returns a result that does not contain some data I need, like LOC_NU, LOC_NUM_SUB and MUN_NU. Follow the original NO these fields and no errors: select…
-
0
votes0
answers627
viewsQuery Mysql: Error Code: 2013. Lost Connection to Mysql server During query
I have a Mysql Query that only returns me Error Code: 2013. Lost connection to MySQL server during query. Follows the same: select log_logradouro.ufe_sg, log_localidade.LOC_NU,…
-
0
votes0
answers53
viewsMysql & Node - Error: ER_NOT_SUPPORTED_AUTH_MODE
When I try to login to my site, I get the error: ER_NOT_SUPPORTED_AUTH_MODE From what I’ve seen I think it has to do with the database connection, which is not correct. var pool = mysql.createPool({…
-
0
votes1
answer89
viewsRun SQL Query multiple times between two dates (MYSQL)
I wonder how I do to run an SQL query between two dates where for example: the user will choose two dates: starting date = 20/04/2020 final date = 25/04/2020 so I wanted to know how do I do to do…
-
0
votes1
answer25
viewsMysql - Cross-table information (Selects)
I am trying to make a table that presents a set of elements, where if a given id is in another table, then that element cannot be in the first. Albums | id1 | id2 (Foreign Key)| Capas| id2 |…
-
0
votes1
answer88
viewsLink 3 tables in an SQL query
I’m in a quasi-deadly doubt I don’t know will it be possible to run with just one query. I have three tables in the bank where they relate to foreign keys so far everything well I am able to relate…
-
0
votes0
answers16
viewsMysql - Added Password Generated Separately
I’m trying to insert Customers but with a password that is generated by a code but I’m not quite sure how to implement the use of this. site.get("/processa_InsereCliente", function (req, res) { //…
-
0
votes0
answers107
viewsIntersection between columns of separate tables in Mysql
By the book: 1 - Summarize the problem: I’m Unable to Achieve an Intersection between columns of different tables 2 - Include details about your goal I am building a PHP BINGO and need to realize an…
-
0
votes1
answer65
viewsAccess denied there mariadb database on linux python3
good afternoon, I was doing some tests and I decided to try using python3 to manipulate databases but I can never connect with the database with python because the same error always happens:…
-
0
votes1
answer47
viewsMysql trigger to insert the desired id
I have two mysql and sqlserver databases, I share the same data with each other, but in order not to have id conflict numerei each mysql database = 2, sqlserver = 1, I would like the table id to be…
mysqlasked 4 years, 11 months ago Walbert Soares de Olivera 1 -
0
votes1
answer114
viewsProblem with Relationship Sequelize
I have two tables called type_agricultural_implement and agricultural_implement, in which the id of type_agricultural_implement is inside the table agricultural_implement as…
-
0
votes1
answer38
viewsHow to select in MYSQL, bringing together results
I need to make a query that returns the amount similar to the below: TIPO 1 unidade 1 unidade 2 unidade n TIPO 2 unidade 1 unidade 2 unidade n The tables are like this: tabela_tipo id|tipo 1 |TIPO 1…
-
0
votes1
answer50
viewsSQL - Command for general classification
Hello, I have a table similar to: user_id server_id record date_record 123 333 3 2020-05-10 343 343 4 2020-05-12 133 333 5 2020-05-15 123 333 10 2020-06-10 343 343 12 2020-05-12 123 333 5 2020-05-15…
-
0
votes1
answer51
viewsDelphhi Edit Record Problem
Good evening folks! I recently joined the Delphi world and created some client registration applications using the Mysql database. The records added to the database are shown in a Dbgrid and when…
-
0
votes0
answers52
viewsTrigger that calculates the resale value of the product has no expected effect in table
I created a Mysql Rigger that calculates the price of a garment with the calculation of 50% profit on the purchase value of the product. Only nothing appears in the place where I wanted the…
-
0
votes1
answer20
viewsDoes anyone know why I can’t create FK?
I cannot create the fk’s from the location table, appears Error Code: 1215. Cannot add Foreign key Constraint create table automovel( placa varchar(7) not null, cor varchar(20), num_portas int,…
mysqlasked 4 years, 11 months ago pedromilard 3 -
0
votes1
answer91
viewsLaravel 7, use of Foreign key
Good morning, I am doing a small project in Laravel 7 and it is the first time that I use Foreign Key and relate two Database tables. In both Models of the respective tables I have already put a…
-
0
votes1
answer154
viewsMYSQL - add column and calculate days late of a date and sort by the longest delay
Hello, Suppose I have a table tb_fatura with the following fields and values: id | transacao_id | valor | vencimento 1 | 1 | 1109.97 | 2020-02-19 2 | 1 | 10, | 2019-05-01 I want somar the column…
-
0
votes1
answer27
viewsAdd column in mysql with groupings
How to select the total of requested amount to the sku_product? I tried to use DISTINCT to group the sku_product, and failed to add the requested quantity_quantity. SELECT DISTINCT (P.url_img1) AS…
mysqlasked 4 years, 11 months ago Hugo Rutemberg 63 -
0
votes1
answer318
viewsPHP - Login System
I am creating a login system and would like to know what is causing the errors Notice: Undefined variable: e in C: xampp htdocs login CLASSES usuarios.php on line 14 Fatal error: Uncaught Error:…
-
0
votes1
answer15
viewsHow to pass arguments on a stored procedure in Mysql?
How do I pass these arguments inside CALL? When I put 9 random values inside LET sql("..."), it runs, but passing this way returns this error. I followed this tutorial ->…
-
0
votes1
answer111
viewsHow to create an "Event Scheduler" in Mysql whose range value comes from the database itself?
I am using the following code to generate a Task or Event Schedule in Mysql every 10 seconds: delimiter | CREATE EVENT gera_financeiro_contrato ON SCHEDULE EVERY 10 SECOND STARTS CURRENT_TIMESTAMP…
-
0
votes1
answer109
viewsmake SQL query return in an organized way
I have the following SQL table: |`id` | `user_id` | `key` | `value` | |------------------------------------ | 1 | 1 | nome | João da silva, 50 | 2 | 1 | docs | 552.282.820-58, 22.532.25,…
-
0
votes0
answers21
viewsProblem when trying to link bd to index
I created an html file just to learn a little bit. I also created a css. Only, when trying to link a database so that you can register with e-mail and password on the site, I could not do, because…
-
0
votes1
answer22
viewsProblem in queries N : N
I wonder why I can not search a query in tables that have the relationship N to N. I need to search the name of the product, the name of its manufacturer, the name and email of its suppliers, only…
-
0
votes1
answer108
viewsInput value does not print completely variable with space
good morning. I have a problem here, when I will update a page with data coming from the database the select option shows the data correctly but the captured values are not correct, an example, if…
-
0
votes1
answer19
viewsRescue radio input log - PHP
Hello, I’m making an editing page, and in it I have an input type="radio", and I’m not getting the radio flagged according to the value in the database... I’m trying to pull this way, but it doesn’t…
-
0
votes1
answer180
viewsHow do I dynamically return data from Mysql columns in each update form input?
Description First, the field Seleciona jogo returns all registered games (This field works as the selection of the game ID to update given game) and what I would like to know is how do so that the…
-
0
votes1
answer36
viewsPercentage of each value within a table field. The field stores two values, 1 for yes and 2 for No
I’m trying to develop a customer satisfaction survey application where the user answers some questions with numbers 1 to 10 and another yes or no. In one of the reports, I show the average of each…
-
0
votes0
answers106
viewsProblems updating page and scrolling user after idle period
I need to deploy the user after an idle time. I can update and destroy the session but it’s not working as I need it. That in the case is that php does not identify as an activity performed by the…
-
0
votes1
answer65
viewsProblem with dynamic delete procedure in mysql
I’ve been doing some research on the Internet but I haven’t had much success. I am mounting a precedent to delete values dynamically relative to the dependencies of a given table but I can pass only…
-
0
votes2
answers295
viewsPerform SQL query with two foreign keys from the same table?
I’m creating a recognition system for the company and it was almost over, it’s been some time that I’m trying to carry out this consultation but not getting. I have the following tables:…
-
0
votes1
answer84
viewsMysql key creation error
I’m making the following mistake: Error Code: 1005. Can’t create table bravo.tb_gerenciador (Rrno: 150 "Foreign key Constraint is incorrectly Formed") follows the script: -- MySQL Script generated…
-
0
votes0
answers35
viewsBackground routine for data compilation is a good idea?
The last company I worked for had some very peculiar rules, these not being as common (as far as I know) in other IT companies. Basically we compiled all the data that would be used in the system…
-
0
votes0
answers26
viewsSave time in format: HOUR:MINUTE using primefaces
I have a following problem, I want to save an entry time in which I type this time and I did this in xhtml: <p:datePicker maxlength="6" id="timeonly" showTime="true"…
-
0
votes1
answer250
viewsMysql extract from INPUT and OUTPUT tables
I’m a beginner in Mysql and PHP, I’m building a financial management application for a charity, (volunteer work), and I can’t solve this problem: Performing a Mysql query in the IN and OUT tables…
-
0
votes0
answers25
viewsCollision when generating random number that is different from an already entered number
I have the following problem: It is necessary to assign a coupon number to a certain person after a purchase and it has the following conditions: it must have 6 digits, the first digit being the…
-
0
votes1
answer37
viewsTotalize products through two tables - Mysql
I wish the result of SELECT to return: Product name | Credit | Debit | Balance Badge 076 |10 | 5 | 5 Badge 064 | 20 | 10 | 10 Table: products [product.id / product.name] Table: badges [badges.id /…
-
0
votes1
answer36
viewsbindValue error - php mysql connection
I’m making a login system using php and mysql. But I’m having an error that I can’t solve. Fatal error: Uncaught Error: Call to a Member Function bindValue() Could someone help me ? follows below my…
-
0
votes1
answer20
viewsImplementing view
Display statement of a particular account with the respective movements of a 15 days prior to the request date with the following data: Agency; Account number; Name of the account holder; Account…
-
0
votes2
answers37
viewsHow to unify 2 consultations?
how can I unify two Querys? I have two queries to show different data see: #This shows the course related data SELECT wu.ID, wu.display_name as Usuário, wu.user_email AS Email, wc.comment_post_ID AS…
-
0
votes0
answers178
viewsError including in database: Duplicate entry '-1' for key 'PRIMARY'
Friends have this table, when I save a user the following error occurs Error including in database: Duplicate entry 'first name.last name -1' for key 'PRIMARY' This is the code. detail in…
-
0
votes1
answer45
viewsDoubt Mysql - Query result
Help me with a situation please, I need to get all the records of the table "buyer" and its attributes and if I have in the records of a client in the order table linked to some buyer listed it…
-
0
votes1
answer258
viewsRun laradock (Docker and Laravel) with mysql local
I had my Laravel environment working at XAMPP. However, given some needs, I had to switch to Docker. For that, I started using Laradock. However, I only want to run php and apache on Docker and not…
-
0
votes0
answers22
viewsSolution for an error in MYSQL
Guys, could help me I’m trying to create a view "POSICAO_EQUIPES", with a Query that displays the overall classification by Teams, regardless of category. The query should display the Championship…
-
0
votes3
answers202
viewsWays to take only the month of the dates recorded in the database
I need to take only the months of the dates of a given field that is in my database, however, preferably without using SELECT MONTH. That way, we get the current month of today’s date: $mes_atual =…
-
0
votes1
answer1009
viewsWarning: mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost'
I’m making a website, while testing locally this connection code worked <?php $servername = "localhost"; $database = "bdcomentarios"; $username = "root"; $password = ""; // Create connection…
-
0
votes1
answer68
viewsTranscribing from Mysql to SQL
How does this Mysql code look in SQL (in Dbeaver with Azure connection)? I just need to change SELECT to work in SQL CREATION OF TABLES -- VACANCY TABLE create table vagas ( idSensor int primary…
-
0
votes0
answers42
viewsHow to generate a subcategory from the previous selection? Combobox
I am developing a People Management system. I have an html form for the insertion of some data. I need to separate the positions in their respective sectors, ie the sector will be the category and…
-
0
votes1
answer51
viewsInsert a default image if no
I want to know if the file is empty or not and if you do not insert a default image on the variable before inserting This is what I have so far, I have also a part of type checking the type of…