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
votes0
answers54
viewsProblem with Javascript loop
Hello I’m trying to create a list of products giving a loop, but I’m having trouble giving the loop in the Javascript file. I am posting the files and access addresses so that they can check the…
-
0
votes2
answers87
viewsDoubt how to loop Javascript
Hello, I have this code below: <div class="center_content" style="background:<?php echo $res['fundosite_cor']; ?>; width:588px; float:left;"> <?php include "conexao.php"; $codigo =…
-
0
votes1
answer29
viewsError while searching list in MYSQL
I have a problem in my system of sending emails newsletter, when loading the index, where the list of registered emails is loaded, the following error appears: Warning: mysql_fetch_array() expects…
-
0
votes2
answers124
viewsLogin system (error when banned)
I have a login system and I wanted it to appear ERROR if the user is banned. The SQL name in the table is "ban", if "ban" equals "0" the user will not be banned, and if "ban" equals "1" the user…
-
0
votes1
answer79
viewsData check
I have a screen that is sending to table emails through $_POST. After that goes to a voting screen. I want to make sure that the email that has already been sent cannot vote again, but I’m not sure…
-
0
votes4
answers1283
viewsAlert message error
I would like to know how I can rectify the following problem I am having with the answer from alert. I do the INSERT of items to MySQL, so far so good. However, if some file fails and others can be…
-
0
votes0
answers107
viewsSelect Advanced separated by hour
I rode a SELECT to return some information from my table separated by time and date. Until this part is all working correctly. Now I need him to select the same data only from another date, being…
-
0
votes0
answers50
viewsReference a group of ID’s resulting from group_concat
I have a select that returns me the equally repeated lines, along with the total. I need to reference this ID group to pass as argument. The result of my query is the array below. Basically it…
-
0
votes0
answers183
viewsPassword Bitnami Moodle
I’m trying to access the Phpmyadmin in the Moodle of Bitnami and I can’t get in, I just installed it and I don’t know the password to root, waiting for answers... I tried to leave no password and…
-
0
votes1
answer45
viewsList database file and put a new row after a certain number
I’ve been trying for days to find a small solution: Example: I have this code: //LISTAR AS PLAYLISTS $dados_playlist = mysql_fetch_array(mysql_query("SELECT * FROM playlists where codigo =…
-
0
votes1
answer194
viewsMake a table condition type in Mysql
Hello, I am setting up a hotel bank in Mysql and I would like to know how to add a condition for date and time of entry (checkin) and date and time of departure(checkout) specific for there to be no…
-
0
votes2
answers49
viewsComparing variables in a query
Good need to create an if to check whether the field coming from the POST is empty or not, if it is should set null, if not I Seto the value that came in the variable. $query2 = "INSERT INTO…
-
0
votes0
answers232
viewsMysql Query Same Column Different Parameters
Opa, simple thing, I have a test table, orgao and state tables teste = 'teste_estado_id_1' 'teste_estado_id_2' 'orgao_id' orgao = 'orgao_id' estado = 'estado_id' In a query you need to relate the…
-
0
votes0
answers46
viewsPhp + Mysql does not perform table deletion or change
Good Afternoon, I am trying to get a page to delete specific records in a particular table of a Mysql database. In another table, this exclusion and also the amendment work perfectly, but in this…
-
0
votes1
answer1068
viewsError save field type data null, not set field as notnull
I am trying to save a possible "client" however I am not defining for him an admission date field, only that when I do it the field is not set and still gives error. Follow my PHP code, the database…
-
0
votes1
answer74
viewsrecover data in a list for editing
On an edit page of the registration data, how to fill a select with the information originally saved. Ex. In the registration form, it was selected in a select, a city. After saving, there is option…
-
0
votes1
answer96
viewsData returning with space
I’m making a call ajax with jQuery in a controller on CodeIgniter. The problem is that when the jQuery returns me the data, it is coming with some spaces in front of the result, getting for example:…
-
0
votes1
answer118
viewsMysql event to delete lines with expired date
I’m trying to create an event to delete lines, that column date is expired, or is less than the current date. I was trying with the following command: create event e on schedule every 1 day do…
-
0
votes1
answer225
viewsHow to increment the varchar() code field automatically in Mysql?
I need to do a stock control, where the code of the products should be varchar, because the code will be formed by the abbreviated name of the product category followed by a sequential number, so I…
-
0
votes1
answer1351
viewsHow to display the previous navigation url with PHP?
I use the function below to go to the next question of a question system I have,I could not create this function to go back,someone would have some hint? Knob: echo"<button id='button'…
-
0
votes1
answer568
viewsAdd dot('.') after the 3rd character
I have a registration with the original code of the product, but I need to put a . (dot) after the 3rd character. Original code: 2022027 As it should be: 202.2027 Follows the structure of the table:…
-
0
votes2
answers284
viewsHow to keep a $_POST on the page
I have a question system,: <form class="form-horizontal" method="POST" action="perguntas.php"> <fieldset> <legend>SELECIONE O QUESTIONÁRIO</legend> <div…
-
0
votes2
answers59
viewsWhat version of the Mysql connector in Azure?
I’m starting with the Azure platform and went to test a web api in Asp.Net with EF6 and Mysql, however when I upload the application to the Azure server and try to call a service that queries my…
-
0
votes1
answer54
viewsError when registering in Mysql
I’m trying to make a record by form system, however I am receiving the following message : Error: Cannot add or update a child row: a foreign key constraint fails…
-
0
votes2
answers866
viewsConvert date format to Mysql
I’m developing a software in C# and in this software I asked to inform the customer’s date of birth in the format dd/mm/aaaa, but in the database the date type is only accepted in the format…
-
0
votes2
answers648
viewsRecord Multiple Numbers in a Field in the Database
Guys I have a column in a table in the database that is called "synchronizes" inside it I want to save several numbers separated by comma, and then do a check on a page as follows, that if there…
-
0
votes1
answer354
viewsHow to Dump in Mysql for the file to contain the date?
I would like to do a Dump in my Mysql database, but I need this Dump to create the.sql file with the date Dump was made, so that I have saved all previous backups by date.
-
0
votes1
answer20
viewsFulltext and Numbers
I have a search table with a Fulltext index. When I search for a word, e.g.: technology, it searches normal. But if you look for a number, example 8530. it returns nothing.
mysqlasked 8 years, 7 months ago Alexandre Lopes 1 -
0
votes1
answer70
viewsArray with Mysql
I’m trying to make a draw of songs but it always displays the last song registered in the database $sql = "SELECT nome FROM CadMusicas"; $result = mysql_query($sql, $conecta); while($consulta =…
-
0
votes0
answers151
viewsSuper Trump - PHP
I am making (or trying) a super trump card. I have no knowledge in programming, much less in . PHP! What I did so far was through research and videos! I ended up learning the basics and what I…
-
0
votes0
answers179
viewsMysql how to save a list of Ids in a column?
How do I save a list in a column in Mysql? I mean, what kind of Mysql variable should I use? I have a table in a Mysql database where I store some product information (size, Cód, etc.). One such…
-
0
votes3
answers87
viewsFix data from SQL database
I want to correct a table field, because I have values like this: 123456789 and I want to change to 1234567.89
-
0
votes2
answers89
viewsReplace number by string in results
I have the following query: SELECT sum(pedidos_lentes.quantidade) AS value, pedidos_lentes.solar AS label FROM pedidos JOIN pedidos_lentes ON pedidos_lentes.id_pedido = pedidos.id_pedido WHERE…
mysqlasked 8 years, 6 months ago marcelo2605 790 -
0
votes1
answer118
viewsQuery with two summations for the same column
It is possible to make a query in which in the same query two sums are executed on the same column? Here’s what I got: Total sum of sales select month(emitido_date) as mes, ifnull(sum((det.preco *…
-
0
votes1
answer324
viewsConnect Java system to database on server
I have a Desk system in which I am trying to connect to a database that is on the server. But every time I try to connect the following error: java.sql.Sqlexception: null, message from server: "Host…
-
0
votes1
answer383
viewsScript to restart MYSQL automatically when falling?
I wonder if there is a script that restarts mysql if it falls. I am having some problems with mysql on my site and eventually it falls, type 3 in 3 days falls, I have already adjusted the memory to…
-
0
votes1
answer34
viewsI am trying to list data from my database, more precisely from the Cpf column, but I can only bring a data
List < VarUnica > list = new ArrayList < VarUnica > (); String queri = "select cpf from funcionario"; VarUnica alt = new VarUnica(); Statement ttpa; try { ttpa =…
-
0
votes2
answers121
viewsAdd or Show amount of items
How best to add or show the amount of items in a mysql table using php. For when I run this code the following error appears: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean…
-
0
votes1
answer163
viewsResultset GROUP_CONCAT is not recognizing the manipulated values
I have a problem, I have no idea how to solve. I’m running a GROUP_CONCAT to a table pivot in Mysql and running by PREPARED STATEMENT. So far so good, now when I try to recover the result set I can…
-
0
votes3
answers239
viewsPick up a single record for equal columns
I have an example table: produto | supermercado ---------------------------- 1 | 1 4 | 2 6 | 1 5 | 1 8 | 2 7 | 3 I want to get all existing supermarkets in this table, without picking up repeat…
-
0
votes0
answers210
viewsshow similar product/property with php and mysql
I am developing a feature on my site to show similar properties by title and value 9r, but it did not work very well my idea: <?php //Armazeno o resultado do titulo da consulta anterior da tabela…
-
0
votes1
answer603
viewsUpdate table field without refresh?
I have a "div" that brings the data of a table "Mysql", how do I do so when clicking on that "div" the data becomes editable ? But without going to another page. <div…
-
0
votes1
answer612
viewsHow to update specific employee in table in Mysql?
I have a database in SQL(banco_sql), where there is the employees table with 4 fields (ID, FUNCIO, SALARIO, DEPARTAMENTO). ID FUNCIONARIO SALARIO DEPARTAMENTO 1 Pedro 1400 TI 2 Isabela 2500 Juridico…
mysqlasked 8 years, 6 months ago user28366 -
0
votes1
answer129
viewsGeneros Link($_GET)
I’m working on a project to learn about PHP, and at the moment I stopped to make a link access the bank and bring everything that has its same value or id... <?php $generos = explode(',',…
-
0
votes2
answers149
viewsHow to take more than one bank category from the same table
I’m developing a system for watching movies online and wanted to know how do I make films that are in 2 categories to be listed in both categories. I’m managing to list only on the first... someone…
-
0
votes2
answers1627
viewsGenerate random name in Mysql - Stored Procedure
Good evening, is there any way to generate random names with stored data in Mysql? I have the following table: STUDENT(id:int[PK], name(varchar(100)), age: int, Cr(float)) I need to popular this…
-
0
votes2
answers2890
viewsReturn database data to PHP page not returning data
Good morning, you guys. I have a page (index.php) that needs to return the database data to it. I have a . php (connection.php) that connects to the database, see: $_SG['servidor'] = 'localhost'; //…
-
0
votes0
answers68
viewsError inserting in Mysql
I created a form with registration system with images and strings and worked perfectly. Only I tried to add another product without leaving the page and now the form with the class I created doesn’t…
-
0
votes0
answers442
viewsPHP - Gathering data from 2 Tables
Person, I’m new to the Forum I’d like to ask for first aid. Summarizing: I’m developing a call system, where it gathers data from other systems. I would like to display all data from 2 sql tables in…
-
0
votes4
answers364
viewsError saving form data in php
I’m having trouble passing data from an html form to be processed into a. php file No error message.` <html> <head> <title>Cadastro</title> </head> <body>…