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
answer330
viewsI cannot restore database in mysql
I am trying to restore a DBS I have on my machine, but unfortunately I am having problems... ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL…
-
0
votes0
answers46
viewsSSL error in Delphi
I’m getting the bug ssl3_get_record wrong version number when I own the property Connected of ADOConnection for true. Does anyone know how to solve?…
-
0
votes1
answer2565
viewsHow to know the date of each record that was entered in the database?
Good afternoon! I have a small database that stores the records of several people. Unfortunately no behavior was created to record the date and time of the record saved in the database. You can find…
-
0
votes0
answers13
viewsShowing symbols when importing sql database
There was a database on an A server. I deleted that server and am creating a new B server. When importing the.sql file to the B server, the names are all wrong. Imagery: How do I make in the…
-
0
votes3
answers85
viewsQUERY LEFT JOIN - MYSQL
Hello, Check out this query: SELECT `permission`.`visible`, `menu`.* FROM `tb_permission` `permission` LEFT JOIN `tb_menu` as `menu` ON `menu`.`id` = `permission`.`menu_id` WHERE…
mysqlasked 5 years, 3 months ago Wagner Fillio 1,328 -
0
votes1
answer49
viewsDifficulty adding PHP MYSQL data
Well, the title itself is self-explanatory. Perhaps the only relevant detail I can add, is the fact that when performing the operation I get no error, nor Warning. Thank you in advance for your…
-
0
votes1
answer33
viewsMYSQL - Where with relationship does not resume result
I need to use this Where in a query, but without success With 'AND' does not work. where ((`atributos_detalhes`.`keyValue` = 'dormitorios' and `relation_imovel_detalhes`.`value` in (2)) **AND**…
-
0
votes1
answer78
viewsHow to configure Mysql for multiple connections?
Hello, I have a client with 3 points of sale, 1 office and 1 server. Such a server is Mysql. When a certain export routine is performed in the office, a query is executed that takes a while to…
-
0
votes1
answer72
viewsSQL - Decimal out of range
I have a table that represents products in stock, it has a quantity field DECIMAL(5,3), i understood that are 5 digits before the comma and 3 after the comma, up to 2 decimal places before the comma…
-
0
votes1
answer280
viewsError trying to install Mysql Client
I’m trying to install mysqlclient on Windows using Pip, so I can use it on Flask, but when I try to use Pip install on CMD (with the files downloaded on the site…
-
0
votes1
answer649
viewsRelationship 1:1
I’m having problems in the relationship of my tables products and stock. The stock table is responsible for storing the quantity of each item in the products table and the date when the product went…
-
0
votes1
answer306
viewsAjax update only on selected line
I have a Datatable here and I’m using a plugin so that the user can edit the table data, got in parts(haha), the problem is that my call is not identifying what the user enters, and when I manually…
-
0
votes1
answer89
viewsSubquery with mysql with two tables
Guys I’m trying to do a subquery in Where as a condition to list the average hours worked greater than 20 and the title of the codProj with 2 tables Following the code: SELECT…
-
0
votes1
answer364
viewsAdd value to a variable in the mysql table
I have a Rigger, whenever a value is added to the table in mysql I take the old value(OLD) and add to another table, but I would like to improve this by adding the values to the same table but…
-
0
votes1
answer42
viewsPHP does not publish data in Mysql table
Hello! I’m a beginner in PHP, I’m trying to build an HTML form that should use a PHP code to send the data to a Mysql table. It turns out that PHP code just doesn’t do anything... doesn’t publish…
-
0
votes2
answers82
viewsJoin a lot of selects into one
I have 4 selects to do that I later put in the separate combobox only I want to put everything in one has like? $sqlq = $pdo->prepare("SELECT * FROM tbl_tipo ORDER BY tipo ASC"); $sqlq…
-
0
votes2
answers103
viewsProblems showing duration in hours and minutes in PHP
I’m trying to calculate a duration between column values in my database. The value until it is being calculated correctly, but it turns out that the hour:minute format is not going out as expected.…
-
0
votes3
answers669
viewsField with Cedilla in Mysql
I have a field in my database table Mysql with the name 'description', with the special accents. My problem is this: When I make a INSERT INTO using directly the phpMyAdmin, it normally inserts the…
-
0
votes1
answer25
viewsUpdate a model’s attribute by another cakephp’s controller
[SOLVED] I have a business logic as follows, when the user changes an attribute to paid (change from 0 to 1) I need him to update the balance value of another model. when the user changes the status…
-
0
votes2
answers78
viewsMake teams combination in SQL without repetition
Good morning, I have a database here with the tables below, and I wanted to generate a table with the combination of the registered teams Time ------ Time A Time B Time C Time D The final table…
-
0
votes1
answer78
viewsError while creating php mysql line chart
I’m trying to make a line Chart with php and mysql like this : jsfiddle based on this tutorial. Only my chart only returns empty with undefined columns: The idea is to make a graph where it contains…
-
0
votes0
answers16
viewsWhere to store videos
Opaz good friends. Well I have developed a series site, where I will post movies, series etc. And what I doubt is about where best to store the videos without interfering in the performance of the…
-
0
votes3
answers196
viewsHow to select to find a record between two values?
I have a table with the following values # valor_min vlr_max juros 1 0 1999 0 2 2000 2999 1.2 3 3000 3999 1.3 4 4000 999999 1.4 I need to consult this table with the value ex.: 2500,00 find the…
-
0
votes1
answer1119
viewsHow to make a registration confirmation modal?
Good evening, folks, I have a question about modal. I have an address confirmation form, but I sent my data via bank, so far so good, the problem is: I wonder when I click the button confirm how I…
-
0
votes0
answers32
viewsCount only on unrepeated data
Consider the following fictitious tables: Venda = id_venda, data, id_carrinho Carinho = id_carrinho ItemCarrinho = id_item, id_carrinho, id_produto Suppose there is 1 registration for sale, 1…
mysqlasked 5 years, 3 months ago Rafael Silva 944 -
0
votes1
answer24
viewsConnection of navcat seat
I’d like to solve a data connection problem in the navcat. I can’t send the data to the bank and I don’t know what I’m doing wrong, if anyone can give me some suggestions, the connection is mysql.…
-
0
votes2
answers974
viewsList 3 tables in a row - MYSQL
I want to make a table together information from 3 tables. This table will be ordered by date (day/month/year Hours:Minutes) and visually speaking would look like this Table image For better…
-
0
votes1
answer142
viewsDiscussion about software architecture
I am rewriting an application for better structuring of it and I have arisen some doubts. The application is a football betting management system and has a web app for management and a mobile app…
php mysql codeigniter apache-cordova software-architectureasked 7 years, 6 months ago Guilherme Ramalho 485 -
0
votes1
answer44
viewsProblems deleting mysql database
Good morning people, I am creating a function to delete in the bank, but when I click the button it does not work, I would like some suggestion. php requests. <?php $sqlCat = "SELECT…
-
0
votes1
answer94
viewsTaking data from a table from grades average of another table?
Tabela - lista id | nota 1 | 10 2 | 8 3 | 7 1 | 8 3 | 9 I want to average the notes of those who have the same ID, and for that I created the following query: SELECT AVG(nota) FROM lista GROUP BY id…
-
0
votes1
answer77
viewshow to stop the for loop in a given action?
good people have a problem I have a form that uploads photos and saves the name in the database and moves the file to specified folder the problem this loop always repeats 5 times if I insert 5…
-
0
votes1
answer272
viewsError 1452 Mysql
I’m starting in mysql, so don’t notice the badly made tables. Finally I have the following tables: create table Alunos ( MAT int, nome varchar (45), endereco varchar (45), cidade varchar (45),…
-
0
votes0
answers64
viewsDoubt with mysql query bring results even if you have nothing
I have the following query inside a javascript that generates a graphic: <script> $(".sparkline_one").sparkline([<?php $sql="select count(id) as total, DAY(dia_criacao) AS DAY,…
-
0
votes1
answer71
viewsDisplay Mysql search results according to the sequence shown in the in clause
How do I sort the results of a query as a sequence displayed in the In clause? That is, the order of the lines must respect the same order of values indicated in this clause. Example: sql = select…
-
0
votes1
answer995
viewsDelete or change sql data using php
I am creating a page where some information will be uploaded, and this information will be transferred to a database and displayed on the same page, as below: As highlighted in blue, I created a…
-
0
votes0
answers1850
viewsFatal error: Call to a Member Function rowCount() on Boolean
Hello, I’m a beginner in PDO connections in PHP and my first select I am facing the following error: Fatal error: Call to a member function rowCount() on boolean in…
-
0
votes1
answer46
viewsReturn average cost between partially equal products
As exemplified in SQL Fiddle, given the tables, the data will be returned as follows: nome | descricao| tipo | custo| ult_lancamento | entradas | saidas…
-
0
votes2
answers75
viewsFormat only last characters of a column’s values in Mysql
I wonder if it has how to format only the last characters of values in a column of my database for example image.jpeg to image.jpg
mysqlasked 5 years, 3 months ago cairoofelipe 79 -
0
votes1
answer40
viewsHow to check if the duplicate in query SQL and use another column to choose which will for final query
I have a price list and an item table, at more than a price for each item and need to pick only the one with lower value. SELECT `nameItem`,`descItem`,`valuePrice`,`datePrice` FROM item, price WHERE…
mysqlasked 5 years, 3 months ago Doctorspeppers 23 -
0
votes2
answers118
viewsLast Registration by date
How do I return the latest update to a record example the record may have several status in one day but need to return the latest…
-
0
votes0
answers56
viewsfail, log data into Database
Hello, I’m having some problems trying to register the form data in the bd, Form code: <form class="form-horizontal" method="post" action="processa/proc_cad_star.php"> <div…
-
0
votes1
answer36
viewsI would like a user to register a single limit of markers on the map
Good morning guys, I would like to know, if I have how to determine a maximum limit of markers registrations there is a user depending on their level of access in the database. Example: CREATE TABLE…
-
0
votes3
answers63
viewsSort table by date
I have a question about how I can get recent purchases by date and time. I tried to: $stmt = $this->pdo->prepare("SELECT * FROM `website_transactions` ORDER BY `transaction_DATE` AND…
-
0
votes0
answers313
viewsRead TXT/DAT file and Parsing before saving to database (mysql)
I have an application in Ruby on Rails whose one of the features is to read a text file with the following extensions "TXT/DAT", for this, I need a simple page (only an input field(file) and a…
-
0
votes2
answers56
viewsDelay in loading some records
Hello! We work with Sugarcrm. Anyone not familiar with Sugarcrm is a CRM made in mysql and php that uses the Zend framework. We used the opensource version and made some customizations. I’m having…
-
0
votes1
answer1049
viewsHow to make a "scan" using SQL?
I have the following structure in my database: Table tgffin with the columns: CODNAT, AD_CODNAT_OLD Table tgfnat with the columns: CODNAT, AD_NAT_OLD I want to reclaim the value of tgfnat.CODNAT…
-
0
votes1
answer61
viewsSearch json tags with REGEXP ignoring accents
How can I ignore the accents with regexp? with LIKE was working, however I was having trouble with posts whose number of tags was large. SELECT id, JSON_EXTRACT(quiz_json, '$.tags') from…
-
0
votes1
answer61
viewsPage does not load for cause and transaction
I am trying to implement a transaction on my Sqls, but because of them, my page does not load. Follow the code: <?php //CONEXÃO COM O BANCO DE DADOS include_once("conexao.php"); //VARIÁVEIS COM…
-
0
votes1
answer39
viewsDoubt Mysql + PHP
Hello, I am developing a management system of camepeonatos online (Fifa, pes) and I have a problem, now I am doing the part where the user will post the result of the game, informing the score and…
-
0
votes1
answer24
viewsPrepare Shows no error
Does anyone know why you’re not showing error if you fail the execute of prepare? $rs = $mysqli->prepare("INSERT INTO tabela (campo1, campo2, campo3) VALUES (?, ?, ?) ");…