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
answer510
views -
0
votes2
answers230
viewsWhat is the best tool to perform a Javascript integration with Mysql?
I am programming a web electronic point system, I am at the beginning still and my knowledge with web programming is still at the beginning. I initially developed the front-end part by HTML and then…
-
0
votes1
answer63
viewsSelect and Inner Join
I have a problem, I can’t make the appointment mysql return the data from id=4 of the profile, using the query down below: select p.*, ec.nome as estado_civil_nome , t.nome as titulo_nome, uo.nome…
-
0
votes1
answer27
viewsHow to get around an sql situation where I don’t have all the information
I’m using the php programming language where: I have the following method of a class: public function executaquery($s, $con) { $query = ''; $total = 0; $s = str_replace(".", ";", $s); $s =…
-
0
votes1
answer520
viewsHow to use declare in a database in Mysql?
I am creating an Insert database in Mysql, but when trying to declare a variable an error appears saying: "statement incomplete Waiting : ;" This is my code CREATE PROCEDURE `inserirAgente` ( IN…
-
0
votes1
answer71
viewsInsert value received in javascript
I have the following code: <p>Your browser fingerprint: <strong id="fp"></strong></p> <p>Time took to calculate the fingerprint: <var id="time"></var>…
-
0
votes0
answers61
viewsCalculate the time difference between one record and another in the same column
I need to calculate the time difference between one record and another, see that on the same day I have several records and I have several people. I found nothing calculating between times in the…
mysqlasked 5 years, 9 months ago Celso Tavares 1 -
0
votes2
answers29
viewsMy delete is deleting the table data but not redirecting to the page I want
*IN CASE IT DISPLAYS "echo "error while deleting";" even the data has been deleted from the table. Please help me! Page of functions: require 'conexao.php'; function apagar($cod_pedido) { $link =…
-
0
votes1
answer279
viewsINSERT with clause SELECT WHERE NOT EXISTS
I found in the Sopt a response to the same case that mine, but something unexpected happens because this is new to me, the SQL statement below returns an error while running. $sql = " INSERT INTO…
-
0
votes1
answer111
views -
0
votes0
answers24
viewsProblem with server response when charting
I have a Dashboard with 8 screens that request the BD. The main file where they are (home page) makes the requests with the load() jQuery. In the individual screen files, each of them does a BD…
-
0
votes2
answers50
viewsProblem in including data through a form using PHP and Mysql
<?php define('HOST', 'localhost'); define('USUARIO', 'root'); define('SENHA', ''); define('DB', 'login'); $conexao = mysqli_connect(HOST, USUARIO, SENHA, DB) or die ('Nao foi possivel conectar');…
-
0
votes1
answer785
viewsHow to insert foreign keys in PHP, so I can have a control when pulling the VIEW
I am doing a project, where employees registered on the site (corporate), can register: Errors and Customers who had these errors (In case it is a support company). I need PHP to do the Foreign Key…
-
0
votes1
answer132
viewsTable Link - Mysql
I’m setting up a system for the user to register/delete/edit/view courses of the school where I work, I set up all the tables but when I will do a inner join in one of the tables does not give me…
-
0
votes1
answer65
viewsselect based on 2 tables
I have 2 tables with the following structure: CREATE TABLE `tb_campeonato` ( `id` int(11) NOT NULL, `time` varchar(60) NOT NULL, `img` text NOT NULL, `jogos` int(11) NOT NULL, `vitoria` int(11) NOT…
-
0
votes1
answer253
viewsMysql Workbench error setting foreign keys
I am wanting to create two foreign keys through Mysql Workbench and when I apply the information it executes the code below: ALTER TABLE `insect_db`.`usu_ins` ADD INDEX `fk_id_ins_idx` (`id_ins`…
-
0
votes2
answers115
viewsAssign database value to a variable c#
I want the value I got from the openCath to be assigned to the check variable. And then to scroll a check. abertoCath is an int of my tblCath, id Box is my Primary key of the table tblCath. private…
-
0
votes1
answer53
viewsProblems with Combobox
I am developing a software that catalogues manga. In it you have the option to select 2 genres for the manga. Generos are loaded into a Combobox from a Mysql table and when the user registers the…
-
0
votes0
answers74
viewsValue Summation Problems with C# and Mysql
I’m developing a software that catalogs manga, one of the problems I’m having is with input volumes. What should happen: the user set the numVolumes to 2, that is, he will add 2 more volumes of…
-
0
votes0
answers195
viewsUPDATE of information in the database with PHP using PDO
I’m trying to do an update after sending the data through the form but I can’t, it just doesn’t update anything. I check the data by $_GET['id'] and the $_POST is passing values and everything is…
-
0
votes1
answer330
viewsFatal error SQLSTATE[42000]
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for…
-
0
votes1
answer132
viewsDo not select in case of null value in the database field (Django)
Eae guys, I’m having a problem, I’m making a script that randomly selects database users: select = User.objects.filter(status=0,…
-
0
votes1
answer45
viewsHow can I compare a password of my DB with that of php
I’m logging in to my website but when I use one query to remove the DB password it comes in a hash and my doubt and how can I hash the passoword that the user put and bought with the DB? To register…
-
0
votes1
answer73
viewsProblem when using query
I’m having the following problem when using some query in my Laravel. I wondered this IP 192.168.1.1, in my file . env put 192.168.1.31 where is located my database. Does anyone know what might be…
-
0
votes0
answers144
viewsField 'photo' doesn’t have a default value
I’m trying to make a insert from a photo to my database but every time I finish filling the fields and enter the error: Field 'foto' doesn't have a default value I couldn’t find out if the lack of…
-
0
votes0
answers278
viewsHow to delete line in Mysql and php
Can someone help me? I’m a beginner in programming and I’m not being able to delete, through a button, no line in the database by ID. I have tried to solve several ways but it simply assumes that…
-
0
votes1
answer18
viewsHow to "rebuild" a file from the buffer stored in the database?
I’m in great doubt. I upload files and receive them on a Node server with the help of middleware multer, the data comes something like this: Then I take this file and save in the database the result…
-
0
votes0
answers132
viewsHow to update to change a table-specific row
How do I change this table? I’m a beginner in PHP/MYSQL and I’m not sure how to change it. Once the person clicks on the "change" icon, they should be routed to a page, which should pull the id of…
-
0
votes1
answer32
viewsIssue on redirect of Edit and Delete pages in PHP
All right, guys, I’ve got a weird problem, I’ve developed a simple scheduling system. git repository: https://github.com/guischpor/sistemacadastrophp I deployed the project on my hosting site at…
-
0
votes2
answers46
viewsmysql query that groups the distances travelled each day
Hello, I started a query from a mysql database where the distance of each commute of a driver is saved along with the time: DATE_FORMAT(l.dateGenerated,'%d/%m/%Y %H:%i') AS Day , d.name AS…
-
0
votes1
answer56
viewsSelect after select result
I am trying to select in a table to display a list of activities. And second select on each of the first select lines to count how many are in each status, but I’m having syntax error, which I’m…
-
0
votes1
answer108
viewsHow to make a Mysql SELECT by summing values of several Ids from a table?
Hello! I have two tables: one where I register entries and another where I have a register of payment methods. When I enter a value into the input table, I put the Pgto form ID and that ID…
mysqlasked 5 years, 9 months ago fredsonnunesjr 3 -
0
votes0
answers23
viewsUpdate only the Divi I added via jquery
Good night. I am adding dynamic Ivs via jquery, and they have a select that is already selected according to the patient’s registration, but every time I add a new div all the other ones are…
-
0
votes1
answer29
viewsHow to add parameters in the WHERE of a Procedure without using IF?
I have the following Query: CREATE DEFINER=`db`@`%` PROCEDURE `RelatorioComissoesByDate`( IN initialPeriod DATETIME, IN finalPeriod DATETIME, IN FK_Corretora INT, IN NomeCliente VARCHAR(256), IN…
mysqlasked 5 years, 9 months ago Leonardo Bonetti 5,313 -
0
votes2
answers1109
viewsInsert error: There are more Columns in the Insert statement than values specified in the values clause
When I give an input searching data from another table, this error is returned, which may be wrong with the query ? INSERT INTO dbo.CRMRAT (IDCRMRAT, CODCOLIGADA, STATUS, TIPO, IDCRMCLIENTE,…
-
0
votes1
answer45
viewsPHP Codeigniter + mysql query
I’m new to the forum and I’d like a little help with a little problem that’s taken up a few hours already. I believe it may be some detail I’m not seeing.. Problem: Basically I need some information…
-
0
votes1
answer335
viewsHow to insert multiple data at once into the database coming from multiple inputs with the same name?
I am generating lines through javascript for the user to register several information at once in the table. When I send the request, the database only records a record and needs it to take all the…
-
0
votes3
answers814
viewsSELECT WITH STRING FORMATTING
Using the Mysql Database, intending to perform the query in a given table whose one of its fields data has as type VARCHAR(8). Query SQL - Current SELECT `t_movimentacao`.`data` FROM t_movimentacao…
-
0
votes1
answer45
viewsQuery SQL returns data that was not to be returned
Well, I’m putting together a ticket sales system for football matches as a project of my course I’m working with the Laravel + Eloquent ORM, but I’m having an inconsistency. My code is: $matches =…
-
0
votes1
answer232
viewsSum of hours in PHP/Mysql
I am learning PHP/SQL and I am making a system of accounting hours worked of the employee. The amount of hours worked in the week is reproduced as a floating number in the $hours variable: 0.25…
-
0
votes2
answers34
viewsSelect does not return values correctly per month
I have a table with a field where the value is (current balance) and in this table has a column (period), where has the date I want to check, however, when I run the Query below only returns the…
mysqlasked 5 years, 9 months ago Andrews Gomes 458 -
0
votes1
answer184
viewsForeign key creation error Mariadb
Hello, I am creating the following tables in my Mariadb database: CREATE TABLE `compras` ( `id` int PRIMARY KEY, `aberto_por` int, `titulo` varchar(255) NOT NULL, `empresa` int NOT NULL, `orcamento`…
-
0
votes0
answers61
viewsCheck if the name is already registered in the Database
This is a Mangáka registration screen, so if I type a name it is added without problems, however I want to check if there is already any record with that name. Table: create table tblMangaka(…
-
0
votes1
answer28
viewsmysql foreign key
someone could help me assemble this query? let’s say I have the following tables: tabela1: aluno (id, nome, cidade) 1 Pedro 2 Joao 3 Joaquim tabela2: cidade (id, municipio) 1 Manaus 2 São Paulo 3…
-
0
votes0
answers27
viewsInsert into two tables obligatorily if not, rollback
I’m trying to make an error in trying to record, or for some serious reason in one and not serious in another, is performed the rollback in both tables, I found similar things, but I did not locate…
-
0
votes1
answer110
viewsDifficulty creating a mysql query
I have this table: Typotarefa: Id, Descricao 17, Depilação Buço 18, Depilação Pernas 19, Depilação Orelhas 20, Depilação Barba 21, Cortar Unhas Pés 22, Cortar Unhas Mãos 28, Esvaziar Saco Urina 29,…
-
0
votes1
answer28
viewsGet records that have equal values
I want to get the contact table records that have the same email. Only the email is a field of the email table because this way the contact can have several emails (One To Many). // Tabela contato…
-
0
votes1
answer159
viewsPHP: Add new element to an array created from an object
Hello, I have the following class in models/cliente.php: <?php class Cliente { public $id; public $nome; ... public function __construct($id, $nome, ...) { $this->id = $id; $this->nome =…
-
0
votes0
answers141
viewsPHP PDO call Procedure and then select from temporary table
I have a protocol that creates a temporary table and I need to select it right after. I’m using Pdo and always returns some error, in my last code gives error 500 and do not know where to go. $proc…
-
0
votes1
answer29
viewsDate filter using month
Dear(a)s The following is, I have a form where I do some filters/ searches that displays the results in a table, but I need to filter the dates by month that are part of the date itself, like month…