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
votes2
answers25
viewsError 404 when saving a form - Wordpress
Ladies and gentlemen, good night! I am using the wordpress tool a little while ago and I came up with a problem that I could not solve. When I try to save a form in mysql database error 404 appears.…
-
0
votes1
answer23
viewsHeroku - Error run seeder for popular BD
Hello. I recently deployed an application to Heroku (Node + Adonis + Mysql + React) and I am facing some problems. It has an admin user who is responsible for registering other users, so I have some…
-
0
votes0
answers57
viewsSQL Select INNER JOIN table contacts join all phones in single related record
I am facing the following dilemma: I have 3 tables (Supplier, Representative and Contacts). And the following query: select * from Fornecedor F inner join Representante R as on R.id_provider = F.id…
-
0
votes1
answer97
viewsSQL: Sort List by Vote Numbers from Another Table
I want the results of my poll to be sorted by the amount of votes you have in the other exclusive table to compute votes. Currently my results come out like this: I have two tables, this one below…
-
0
votes1
answer27
viewsSend ajax requests one by one
I’m sending an email to a list of say 100 people, process this sending via Ajax, the normal is the ajax send to a page and in Success or error of it, it gives me the return what occurred, until then…
-
0
votes2
answers121
viewsQuery to PHP database with WHERE does not return value
The query variable that I use to query the position in the database is the $fornecedor who receives $_POST['fornecedor'] from another page, but the query does not return values only goes blank, when…
-
0
votes2
answers53
viewsHow to transform a numeric value into CURRENCY FORMAT (Brazilian Real) in SELECT MYSQL
Hello, Success and peace to all! CREATE TABLE IF NOT EXISTS `lancamentos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `data` date DEFAULT NULL, `mes_referencia` varchar(50) DEFAULT NULL, `cliente`…
-
0
votes0
answers40
viewsMy answer returns Undefined
I’m using Node to develop an application. I am making a query in the bank to pull some values. These values are: 'imagem1', 'imagem2, 'imagem3'. I want to use a for to apply a function in the 3…
-
0
votes0
answers14
viewsMistake my PROCEDURE
Health and Peace for all. Please have a table tb_feriados_datas_tipo_procedure, which I am studying. The columns tb_feriados_datas_tipo_procedure has: feriados_id int(11) AUTO_INCREMENTO…
mysqlasked 4 years, 3 months ago Carlos Teixeira 5 -
0
votes1
answer47
viewsUse of multiple conditionals in an SQL query
I’m wondering how to perform a query with different conditionals. The query is a login validation, I need to check if the data contained in the user input is equal to the username or email or Cpf…
-
0
votes1
answer70
viewsError Code: 1136. Column Count doesn’t match value Count at Row 2
Good night, I’m making a table in Mysql Workbench where it shows data from an accounts receivable department, however I’m having a problem when I will enter the values it gives the error 1136 and…
-
0
votes1
answer29
viewsError using a bot in python
Whenever I run the following code (using python) from chatterbot import ChatBot from chatterbot.trainers import ListTrainer bot = ChatBot('bot1') bot = ChatBot( 'bot1',…
-
0
votes1
answer44
viewsAm I Connecting to Database Correctly?
hello I have this table named Payment: fname email adr city cnameccnumexpmonth expyear cvv id and I have this payment form if the person wants to help my project! <form id="my-form"…
-
0
votes1
answer34
viewsList only contracts due by ID and do not consider if ID has contract in force
Fala galera... I need to list only the EXPIRED contracts, because when the company renews the contract, the data of the expired (old) contract remain in the BD with status "0". So we have: 1…
mysqlasked 4 years, 2 months ago Myller Meireles 19 -
0
votes0
answers113
viewsSuggestion for Login with Access Levels php mysql
I need a hint as to how you would implement a login system via php and mysql with access levels, example: I have a database Mysql with is registered users, this in turn has several different access…
-
0
votes0
answers18
viewsPHP Select at random
I have this script, I needed to include a select randomly. <?php $sql_veiculos = mysqli_query($config, "SELECT ma.categoria, m.modelo, m.versao, m.ano, m.motor, t.transmissao, m.portas,…
-
0
votes2
answers51
views"Argued tofrangeexception" error when performing database query to return quantity of records
I have a query in ADO . NET with the aim of return the amount of records I have in the bank based on last month and year. For example, I pass the date "27/01/2021" and receive the amount of records…
-
0
votes1
answer98
viewsHow to resolve Fatal error: Call to Undefined Function mysqli_connect() in
Good morning, my site is not working and gives the error Fatal error: Call to Undefined Function mysqli_connect() in /home2/amttli84/public_html/conexion.php on line 7 The strange thing is that on…
-
0
votes0
answers8
viewsMysql 5.6.12 - How to create date field with current default value
I am creating a table that has a separate date and time field (yes, the two separate fields), and in these I want the default value to be the current date/time. I tried to create the field with…
-
0
votes0
answers17
viewsQuery that returns the difference in hours between two dates considering working days - MYSQL
I have a demand where I need to generate a query that returns the amount of existing records in a table, given the difference, in hours, between two dates. The difference between the dates I can…
-
0
votes0
answers49
viewsGenerate a Google Charts chart with Mysql database records
Hello Friends Programmers I am in need of a help. I’m trying to generate a chart with Google Chats of schedules per month, but in the database the saved dates are in the xx/xx/xxxx format. I wonder…
-
0
votes0
answers22
viewsGenerate file with select + variable result
I have basic knowledge in PHP and good in Mysql but I’m having a hard time I need to generate a select with a result, generate it on the screen where there will be a box to add quantity and after…
-
0
votes0
answers16
views -
0
votes1
answer50
viewslastInsertId returns 0 (zero)
I need to get the ID of my last INSERT in the database, however the function lastInsertId() only returns me 0. This is my class that connects to the bank: <?php namespace App\model; class…
-
0
votes1
answer39
viewsPHP - Getsqlvaluestring - What is the purpose of this function, generated by Dreamweaver?
What good is GetSQLValueString? And if there is a difference to PHP7, what difference does that function make? What happens if I don’t use it? Can anyone help me understand it better? if…
-
0
votes1
answer29
views#1005 - Cannot create table`db_to_do_list`. `tb_completed` (error no. 150 "Foreign key Constraint is incorrectly Formed")
I’m posting this question here, because as much as I’ve researched, I can’t solve it I’m starting to study Mysql and the problem that occurred was this: #1005 - Não pode criar a tabela…
-
0
votes0
answers14
viewsSqlserver to Mysql conversion - sys table id
I have the following query in SQL Server: Declare @val Varchar(max) Select @val = COALESCE(@val + ', ' + col.name, col.name) FROM sys.objects AS obj INNER JOIN sys.columns AS col ON col.object_id =…
-
0
votes1
answer31
viewsCase & When in Select
SELECT c2.quantidade AS qtde_solicitada, IF ( ( SUM(c1.quantidade) - c2.quantidade ) < 0, '0', c2.quantidade ) AS estoque, ( SELECT SUM(quantidade_autorizada) FROM ferramental_requisicao WHERE…
mysqlasked 4 years, 2 months ago Sr. André Baill 6,946 -
0
votes1
answer17
viewsHow to add the WHERE condition in the SELECT table with server-side Processing?
I wanted to add a small SELECT condition to my table, but I am using the Datatables server-side Processing to list the records on the server side. I tried to adapt the standard Datatables code to…
-
0
votes0
answers26
viewsInserting column in mysql database table and after doing the update in the same column created
I’m developing a system: 1- The "USER" of the system registers a service for a particular client who contracted that service. 2- This registration is done via a form.php... 3- Send this data…
-
0
votes0
answers85
viewsIdentify input ID
Guys, a help, I think I’m no longer able to confirm where I’m going wrong. It has a form with 4 fields (item, description, unit and quantity) and a button to add more lines if you want, I use the…
-
0
votes1
answer99
viewsMYSQL - TRANSACTIONS
Good evening, I’m a beginner in mysql and I came up with the following question. When I make a transaction like this START TRANSACTION ; INSERT INTO PESSOA2(IDPESSOA,NOME) VALUES(NULL,'PEDRO2');…
-
0
votes0
answers223
views#1452 - Cannot add or update a Child Row: a Foreign key Constraint fails
Personal talk I am having problems to create a foreign key in another table... You are giving this error: #1452 - Cannot add or update a child row: a foreign key constraint fails.... Follow the…
-
0
votes0
answers27
viewsError installing SQL server - Linux Mint
I already have flask installed on my NOTEBOOK with Linux Mint, but still no module called flask is showing up along with dpkg error. I tried various solutions on various websites such as: sudo dpkg…
-
0
votes0
answers17
viewsInsert with JXL reading is registering only 36 values
Hello. I am creating a program whose purpose is to read files. xls and save to the bank, but when I use the read method with Insert, it inserts only 36 lines, without presenting errors. Could you…
-
0
votes0
answers25
viewscron does not update database
I created a php file to check if there are any expired users or update their status with database update 1 time a day. I’m scheduling the cron for the hostgator’s CPANEL. If I run the file in the…
-
0
votes1
answer26
viewsWays to implement day "opening" to release data entry
I am with a page that collects information from the sales team, with customer data, competition data, etc. Follow code: CREATE TABLE dados_relatorio( id int(4) unsigned NOT NULL AUTO_INCREMENT,…
-
0
votes0
answers17
viewserror when url has more parameters
I’m doing a user-friendly url forwarding with page access verification per database, but I have a problem when the URL has more parameters on it, like if the URL looks like this www.site.com/a/b/c…
-
0
votes1
answer28
viewsProblems with INSERT INTO in Crawler in PHP - Error passing variable as parameter
<?php require_once "./vendor/autoload.php"; use Goutte\Client; $servername = "localhost"; $database = "*******"; $username = "root"; $password = "********"; $conn = new mysqli($servername,…
-
0
votes1
answer18
viewsForm does not insert data into the BD
I have an HTML FORM and it does not send data to the BD <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <meta name="author" content="João Bastos"> <meta…
-
0
votes1
answer52
viewsFunction to simplify records in Mysql with PDO - You are saving all identical values
I am trying to create a function to simplify insertion of records in Mysql using PDO. The function is working but recording identical values. Follow the PHP script: <?php function…
-
0
votes1
answer33
viewsSend the result of two Mysql tables to a view (ejs)
I am working with Ejs and Node.JS with Mysql. I need to move to a two table info calculation view, but I am facing this error: app.get("/calc", (req, res)=>{ Palpite.findAll().then(calc =>{…
-
0
votes0
answers23
viewsAssign Values according to array dates
I have the following objects returning in values: duasSemanas: 2021-02-18: {TOTAL: 20, OUTROS: 8, VALIDOS: 12, MEDIA: 841.8600000000001} 2021-02-19: {TOTAL: 20, OUTROS: 6, VALIDOS: 11, MEDIA:…
-
0
votes1
answer96
viewsWhat is the best way to store Civil Status data in the database?
Hello, I have a question: I need to create a <select></select> in HTML for the user to select their marital status. So, I’m using PHP to save the data to an SQL database. My question is…
-
0
votes1
answer35
viewsSum a column by Mysql ranges
Personal I have a table in my Mysql database like this: Table name is tb_cargaHora I’m trying something like this: SELECT nome, matricula, SUM(carga_hora) FROM tb_cargaHora Order BY nome; but only…
-
0
votes1
answer38
viewsReturn maximum table value in JOIN - MYSQL
I need to return the last record of a table that is on JOIN of my consultation. But my knowledge is limited and I can’t go on: Table Services: Table situation: Result of my query: My consultation…
-
0
votes0
answers45
viewsHow to Calculate Nodejs Points with mysql and sequelize of several Users
Calculo Onde puxo informções do banco || calculo acontece de forma correta pore o envio para o banco atravez do update funciona não corretamente. Basically it would pull through a loop pass through…
-
0
votes1
answer31
viewsMultisite Wordpress: Problem to access secondary site panel
I did an installation of a site using Wordpress using the multsite feature. The installation was ok following all instructions, but every day the URL of a website changes directly in the database,…
-
0
votes1
answer30
viewsReturn field different from the one inserted in the GROUP BY clause
I have the following table: | id | payment_id | user_id | device | ------------------------------------ 1 | 2 | 1 | active | ------------------------------------ 2 | 4 | 5 | not_active…
-
0
votes1
answer39
viewsGroup Data from a SELECT using the DATE parameter
I have the following scenario: I am getting a SELECT, where each record contains the coordinate and creation date of this Record. I would like to display by DATE the amount of coordinates obtained…