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
answer93
viewsConnection with 3g unstable locked in C#
I have a system, which uses a table in mysql to check if there is an update for it, It happens that at certain times, it is necessary that the modem is reconnected so that the system can do these…
-
0
votes1
answer131
viewsDoctrine’s findAll method returns the same id on all lines
I am doing a search that returns all the data of my Entity., it happens that it returns me all the data but with the same id, but I checked the database the ids are different..…
-
0
votes1
answer126
viewsHow to modify the text from the database?
So when I request the text in the database through this instruction in php <?=converte($linha['DESCRICAO_PARA_WEB'], 0)?> the text is displayed whole block without line breaks. This function…
-
0
votes1
answer314
viewsAvoiding dump for Mysql users
For a specific Mysql user, there is a way to block it from doing the Data Export (DUMP) of a specific table, or of the entire database? I couldn’t find a solution... How you handle it? Thank you!…
-
0
votes2
answers248
viewsTo do a complex search I would have to use OR to combine all the instructions?
I would like a help to make SQL as per the data in this figure. What I know is that if I send AND for all characteristics and one of them return false or erro all SQL will be compromised. I thought…
-
0
votes1
answer121
viewsRewrite the code to display expected result?
This code must return all records from the table immovable if the array is empty and returns selected records if there are items in the array. I can have the array mounted and the database consulted…
-
0
votes2
answers234
viewsHow to make this SQL request with this particularity?
In this search when the array returns the 4 as the SQL demonstrated below, I need the system to return all the results whose number of dorms and >= 4. You can help me get this result. I converted…
-
0
votes2
answers737
viewsHow to keep query filters sent via $_POST?
$page = ((isset($_GET['pagina']) && intval($_GET['pagina']) > 1)? intval($_GET['pagina']) : 1) - 1; $limite = 12; $atual = $page * $limite; $limit = " LIMIT {$atual}, {$limite}"; //…
-
0
votes1
answer1256
viewsError trying to connect to a local Mysql database
I am having problems trying to access a local Mysql database, I am following this tutorial. My file MysqlConnect.java: package br.com.alerts; import java.sql.Connection; import…
-
0
votes5
answers2474
viewsHow to select a checkbox and recover data in the database?
I have two types of checkbox and I need that when selecting one of the two is displayed a field of type input text with the information coming from the database. The field input will be disabled,…
-
0
votes2
answers5338
viewsAndroid connection to Mysql
Well, I got a free hosting from the site Hostinger Ai configurei o Mysql certinho la, but would like to know if it is possible for my android application to connect to this database? and if yes how…
-
0
votes2
answers162
viewsError trying to insert values in Mysql
Good person, I was trying to make an application that inserts products and allows you to view it on mobile through database, but when I try to create the product the application closes and it…
-
0
votes1
answer704
viewsApplication displaying this error: Error Parsing data org.json.Jsonexception
I was trying to make an application for android with connection to Mysql through webservice and has been giving some problems, so I could solve, but this appeared, when I try to see the products…
-
0
votes0
answers40
viewsProblem with conditional Insert
Good I’m with the following problem I’m making a conditional Insert not to duplicate entries in the table but is not inserting me anything Code <?php session_start();…
-
0
votes1
answer450
viewsHow could I trigger an action in a PHP script with a link?
How could you trigger an action in a PHP script from a link? <ul class="categorias"> <li><a href="">Lançamentos</a></li> <li><a href="">Vista…
-
0
votes0
answers46
viewsCreating a PHP, Mysql and Jquery Chat
I am creating a chat inside an administrative panel, as has several on the web. I’m having problems to "think" how I would control the chat so that, for example, only the users of that particular…
-
0
votes1
answer60
viewsAdd lines with the same year
Problem:-Add lines that have equal years via mysql command. Query I am using: SELECT produtividade, ano FROM area_e_producao_05_15 INNER JOIN dados_cidades ON edr_id={$edr['edr_id']} WHERE…
mysqlasked 9 years, 9 months ago Rodolfo Oliveira 917 -
0
votes1
answer162
viewsWhat is the meaning of the "indexing equal or removed" error in Mysql?
I am working with small relationships and I realized that in a state table in which I related the field id the table país[id] I get this error message or alert, I’m not sure. Already in a table…
-
0
votes0
answers42
viewsCalculate the page an ID is located on
Assuming I have 10 records and per page shows 3, then the ID 2 will be on the page 1, the ID 7 on the page 3, and so on. In practice I need to access www.dominio.com/lista.php?id=7 page 3, referring…
-
0
votes2
answers992
viewsHow to query the DB without refresh and write the returned data?
I need to query my database with something like AJAX/JSON I’m not sure and return the result within a div next to this map. There already exists a div next to receive the result of the consultation.…
-
0
votes0
answers38
viewsDelete problems in Mysql via MVC 4
I have a problem that I don’t have a clue as to why it’s happening and I can’t fix it either. I have developed a WEB application in MVC 4. I can add and edit new records. But I do not want to delete…
-
0
votes1
answer1722
viewsError Code: 1048, SQL State: 23000 Column 'colegiado_id' cannot be null
Hello, this mistake "[Error Code: 1048, SQL State: 23000] Column 'colegiado_id' cannot be null" happens when I try to run the SQL command below directly in Mysql: start transaction; INSERT INTO…
-
0
votes1
answer302
viewsSyntax sql error
I’m trying to make an insert in the database but I’m having a syntax problem, I still can’t identify the error. $sql='INSERT INTO tabela ( nome, nit, rg, cpf, ) VALUES'; foreach($dados as $linha_bd)…
-
0
votes1
answer2239
viewsHow to write MYSQL data to two tables at the same time
How to write MYSQL data to two tables at the same time, but the second name table "t_cadparcelas" should insert more than one record according to the number of installments so I implemented for but…
-
0
votes3
answers137
viewsProblems with WHERE IN (many records)
I need to assemble a query to search for records in table A, with table B record filter. Something like: SELECT * FROM tabelaA tblA WHERE tblA.coluna IN (1,2,3,...) The values contained in the "IN"…
-
0
votes1
answer162
viewsSyntax error in Procedure Mysql
I have the following Stored Procedure. When executing it in is returned the error of sinxtaxe 1064 as in the image below. What am I missing ?…
-
0
votes2
answers289
viewsView grouped data
I am making a query in the database and I am having difficulties with data duplications, so far, this is my query: SELECT * FROM tec_postagens tp INNER JOIN tec_historico_status th ON…
-
0
votes1
answer70
viewsHow to list checbox data?
My code is like this: <!-- caixa de seleção de técnicos --> </style> <body> <p>Técnico</p> <form method="post" action="salvar.php"> <b><select…
-
0
votes1
answer551
viewsSelect products in a certain range of discounted values?
I’m trying to make a value filter for a virtual store, I have a product table, a stock and another for promotions. products CREATE TABLE `produtos` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `codigo`…
-
0
votes1
answer308
viewsmysql Trigger if not update
I have a question when creating a Trigger, I need it to be executed only if the field has not been updated: integraProduct, if any other field is updated it should be executed. DELIMITER $$ CREATE…
-
0
votes0
answers77
viewsMysql Lost Tables?
I just had a strange experience with mysql, I have a database with 8 tables on my local server. Suddenly my system no longer wanted to log in, I went to check on phpmyadmin and showed the tables,…
-
0
votes1
answer365
viewsHow to make a query to return the value of another table?
Table PRODUTOS id nomedoproduct categoriadoproduct valordoproduct Table CATEGORIAS id nomedacategoria In my form I show the name of the category but register in the database in the table PRODUTOS…
-
0
votes0
answers328
viewsDuplicate BD data when requesting Ajax
Every time I try to register a new comment, it doubles in my database. It loads the comment by ajax, but after I refresh the page appears the duplicate comment. <?php…
-
0
votes1
answer620
viewsAdd Letter in a field with 20000 lines
I have a table produto filled with 20000 products and I need to add one o in the first character of the field codigo all-line. How can I do this with Mysql?…
-
0
votes0
answers103
viewsUsername always appearing as GUEST_NAME
I have the following code but in place of the user name appears GUEST_NAME, even after logged in. I have checked if I am using the correct table and used session_start(); MEMBERPAGE.PHP (where it…
-
0
votes2
answers290
viewsHow to solve search problem with accented words
I entered a table into my database using the command load and the fields with accentuation were correct, as for example Sofá Nápoli, but by changing any record that contains accent by my control…
-
0
votes1
answer178
viewsProcessing of returned values in the query
I need to "handle" the return of a SELECT as follows: - value saved to the bank: www.dominio.com.br or www.dominio.com - value treated on page: dominio; I mean, I need query "remove" what is before…
-
0
votes0
answers178
viewsPassing information between pages
How best to pass information (data) between pages? Example: I have 4(four) pages dadospessoais.php, endereco.php, habilitacoes.php and salvar.php. On the pages (dadospessoais.php, endereço.php and…
-
0
votes2
answers347
viewsCompare Mysql search results
I need to compare the result of a query not to repeat the result. For example: I have in the unit register your Cod and speed, but I can have 2 situations: 1) more than one occurrence for the same…
-
0
votes1
answer931
viewsGroup data related to a column
I have the following code SELECT t2.conta_nome as operacao, t1.provedor_nome as operadora, perfil, count(*) as total FROM asteriskcdrdb.cdr_tarifacao a INNER JOIN telefonia.provedor t1 ON…
-
0
votes0
answers524
viewsHow to access an Openshift Mysql database via Jdbc via Google Spreadsheet?
I want to access a Mysql database hosted in Openshift via Jdbc from Google Spreadsheet. It is possible? In Google Spreadsheet, in Ferramentas -> Editor de Scripts, I am having problems with the…
-
0
votes1
answer75
viewsQuery counting by date difference
I need to make a Mysql query that does the following: Count the number of times that the same record appears more than 15 days apart, i.e.: Record 1 - Date: 20/01/2015 Record 2 - Date: 22/01/2015…
-
0
votes1
answer66
viewsMysql query with undesirable items - PHP
I need to compare two arrays that come back from Mysql, but one of them is coming back with several strange items, making it impossible to compare. I already trained in the search to return only the…
-
0
votes3
answers1715
viewsCreate a Trigger that runs whenever a product is deleted
How to create a Trigger that is executed whenever a product is deleted, performing the delete action in all batches related to the deleted product. Here’s my SQL code: create database provafinal;…
-
0
votes1
answer648
viewsFilter the return of Stored Procedure
I created the following SP: -- -------------------------------------------------------------------------------- -- Routine DDL -- Note: comments before and after the routine body will not be stored…
-
0
votes1
answer1761
viewsSave variable value javascript in database
function showpos(position){ lat=position.coords.latitude lon=position.coords.longitude var enderDe = (+lat+',' +lon); How do I save the variable enderDe in my database?!…
-
0
votes1
answer72
viewsConcatenation Create Table
I’m trying to create a table from the user’s email, and I’m using the code below: $email = $_SESSION["email"]; echo $email; $create=mysql_query("CREATE TABLE userpics_'$email' (id_user VARCHAR(60),…
-
0
votes1
answer42
viewsProblem with data change class
I am trying to change data from my BD via Java application, but when I run the following code I get the error (You have an error in your SQL syntax; check the manual that Corresponds to your Mysql…
-
0
votes1
answer872
viewsInsert into mysql database
I’m making a website which has a field of login, which when logging leads to the administrator sector being able to enter, delete and change items from the database. Already the registration page is…
-
0
votes1
answer156
viewsmysqli receiving Boolean
My site is not searching! I couldn’t figure out how to make queries through the search box, I try to access the cars in the database and it brings me the following error: Warning:…