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
-
-1
votes1
answer123
viewsQuery mysql on Node-JS Not Working
I am developing a Node application in which I need to do some query’s in mysql, however a simple query of select is not working. follows the code of the passage function processTag(tagNumber,…
-
-1
votes1
answer1088
viewsTruncated data in Mysql
A database table has 5 columns. 1ª id autoincremento [INT[11] NOT NULL] 2ª código do produto [varchar(15) NULL] 3ª nome do produto [varchar[80] NULL] 4ª custo do produto [double[10,2] NULL] 5ª…
-
-1
votes1
answer87
viewsDoubt which variable to pass from my Select
I have two selects, both consult the database. I have Equipment, and Operations... When selecting equipment x in select, I will consult the database for the select Operations to pull only Operations…
-
-1
votes1
answer79
viewsReturn of several CASE in a single line
How do I convert that return: In a single line: 548721 125 2 20836 20836 77821 77821 9999******9999 0 0 MASTERCARD 200 Cartao de Credito a Vista My query: SELECT CASE data_id WHEN 17 THEN data_value…
-
-1
votes1
answer54
viewsAccess data from two databases of two different tables in a query
Guys, I’m having a problem. Currently I have two databases and two tables (1 table in each database) that need to be connected in one query only. It would be a JOIN in other words, but I’m not…
-
-1
votes1
answer70
viewsProblem using PDO::bindParam with table names
I am a beginner in programming and wrote a code in php to practice PDO. However, I had a problem: when I use the Mysql command without bindParam it works normally. When I reference the table name…
-
-1
votes1
answer42
viewsINSTER MYSQL PHP PDO ERROR
I’m trying to make an Insert using PHP PDO, but it is always returning an error, which I am not able to solve $insert = "INSERT INTO usuarios ('usuario', 'senha', 'telefone', 'email', 'tipo',…
-
-1
votes1
answer171
viewsPrestashop error "Cannot select any Valid SQL engine. at line 302 in file classes/db/Db.php"
Good morning, I had a problem with the files of the server in which they were all deleted, however I had backup of the whole site, since this was done a data restore, which happened in normal, but…
-
-1
votes1
answer16
viewsHow to take a date through a form and insert it into the database
I have the following problem: I am not able to take the current time and insert it in the bank. <div class="container"> <h2>Registrando ponto</h2> <form class="form"…
-
-1
votes1
answer38
viewsAutomate Collapse with BD
I’m making a system to automate Collapse with my mysql. I have a table listed below: This Collapse system, works inside a modal window, where I tried to make each question appear in a Collapse. For…
-
-1
votes1
answer65
viewsUpdate between two tables with conditions
I have a question in my work regarding locating and replacing a certain field, updating it with a value of a search. I’ll give you an example: I have this table that has LOC_NUM_SUB and note in the…
-
-1
votes1
answer48
viewsProblem in php code to list the recorded data in the database (beginner)
I put the bb image and the php codes below so that someone can help me because I can’t find a solution. Error: Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in…
-
-1
votes1
answer252
viewsList data files using PHP-mysql
Hello. I am a beginner in programming and I am developing a project. I have already performed the code to upload the file, now I would like to list these files in a table and it shows a column with…
-
-1
votes1
answer323
viewsReturn mysql query in python list
Good Afternoon! How do I take the data that comes back from the sql query and play it in a list knowing that I need to return the query = to return the file folder + the files larger than the…
-
-1
votes1
answer142
viewsError saving Decimal value with . Net Core and Mysql
In my project I have a field Valor of decimal type, as I set up the culture for en in my project I need to send the value with the tab ",". If I define the input as text does not accept sending with…
-
-1
votes1
answer46
viewsUnique key during time period
My table is constituted as follows: CREATE TABLE `AgendaVisitas` ( `id` int NOT NULL AUTO_INCREMENT, `title` int DEFAULT NULL, `respons` varchar(255) DEFAULT NULL, `contact` varchar(20) DEFAULT…
-
-1
votes1
answer76
viewsFind out Docker-Compose error
I own the following Docker-Compose: services: mysql: image: mysql:5.6 ports: - "3316:3306" volumes: - ./database/setup:/docker-entrypoint-initdb.d - ./database/data:/var/lib/mysql -…
-
-1
votes1
answer423
viewsRecover neighborhood and city only in the Google Maps API by pure PHP coordinates
I have an application where I need to store only neighborhood and city data in the mysql database, from the results coming in json of the Google Maps api. I’m using the following code: $url…
-
-1
votes1
answer68
viewsLaravel 7, how to call iterate an input that has no right name
I am making a small form in Laravel 7 and in Javascript I have a button that adds the fields that the user needs to create the necessary questions. Javascript $(btnQuestions).click(function () {…
-
-1
votes1
answer61
viewsNode, Express and Graphql environment user system
Hello, world! I’m studying Graphql and I’m having a problem with this Mutation... var schema = buildSchema(' type userAccount { firstName: String! lastName: String! mobileNumber: String email:…
-
-1
votes1
answer39
viewsHow to use the required and check if the data has already been entered?
How can I make it mandatory for the user to fill in all the form fields? I tried to put required in the code but for some reason there is no message that usually appears when I put the same code in…
-
-1
votes1
answer180
viewsI’m having doubts about how to insert several elements into the database by mysql.
import mysql.connector mysql.connection = mysql.connector.connect(host='localhost', user='root', password='rgs050601', database='testegr') sql = "INSERT INTO pet (id,numero,idade) VALUES %s" pd =…
-
-1
votes1
answer31
viewsHow to put more than one Get method along with the sql code to send the information in the bd ? Example: Put email and password
Php user. #Conexao/categoria.php include_once 'conexao.php'; class UsuarioDAO{ public function Inserir(Usuario $usu){ try{ if (!empty($usu->getNome())){ $sql = "INSERT INTO usuario (nome) VALUES…
-
-1
votes1
answer123
viewsI can’t start Xampp
While trying to start Mysql in xampp as usual, this error occurred: Error: MySQL shutdown unexpectedly. 14:04:23 [mysql] This may be due to a blocked port, missing dependencies, 14:04:23 [mysql]…
-
-1
votes1
answer143
viewsPHP Notice Code Error: Undefined variable: Connection in C: xampp htdocs admin Register.php on line 283
The following errors appear when opening the table page: Notice: Undefined variable: Connection in C: xampp htdocs admin Register.php on line 283 Warning: mysqli_query() expects Parameter 1 to be…
-
-1
votes1
answer122
viewsKeyword filter with other fields
Hello, I am developing a system where I need to perform a user filtering, and in this filtering will be used several simultaneous fields (name, Cpf, gender, age and etc.), the problem begins when I…
-
-1
votes1
answer56
viewsDisplay BD text in a div considering the HTML tags contained in this text
Speak guys, I have a text written in BD Mysql where, this text already contains all the formatting tags. On my font-end page, I receive this text through a foreach and pass it in a div of the page,…
-
-1
votes1
answer35
viewsHow to authenticate user correctly?
Well I’m doing a login system in php and mysql, it works well, but works well even too. When I try to log in with the correct login and password the authentication.php file authenticates them…
-
-1
votes1
answer166
viewsAdd days to a date in mysql and compare it to the current date?
I have some conditions on a page of my system, I need to put something in my SELECT so that on his own SELECT has already entered a certain condition. The condition is as follows, I need these two…
-
-1
votes1
answer42
viewsConfirm registration by email - PDO
I am trying to make a confirmation of registration by email, but I am not succeeding. I can get the user, email and password. but when I echo the $id and $md5 variable to check the data nothing…
-
-1
votes1
answer94
viewsBe displaying the data on the front end with Node.js
I’m having a problem where basically when inserting the data of two mysql tables in front-end I’m not getting, I think I’m reporting in the wrong way. // Exibir post app.get('/cad', function(req,…
-
-1
votes1
answer55
viewsWhere to delete records that were entered a certain time ago
Help to create a delete with where if the record has been inserted for more than 5 minutes. I have the point marking table with the columns: cd_register - integer cd_enterprise - whole cd_matricula…
-
-1
votes1
answer50
viewsSum of two different tables msql php
need help. I would like to display the sum of the amount of Id of the storeId column referring to the names of the storeName column. Example:
php mysql
asked 4 years, 2 months ago Renato 9