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
-
2
votes1
answer753
viewsUnderstanding Httpurlconnection, Outputstream, Inputstream and Buffered Writers requests for Mysql database use
I am developing an android application that will have access to a database MySQL using webservice. I saw some tutorials on the net and in a tutorial in English able to make the connection and…
-
2
votes1
answer32
views -
2
votes2
answers381
viewsTrying to make the login work, but shows no error but also does not enter
Like I did the right php as my teacher passed, I changed all the names and it’s all right, I already checked, but when I log in, he doesn’t log in, he just updates the page and doesn’t redirect to…
-
2
votes2
answers328
viewsMultiple registration of image
Here I come to ask for your help again! I created a function to register images in the database being one of them the cover and the rest of album images. The script up to register the cover image…
-
2
votes1
answer1079
viewsSave File with Extension
I would like to recover a file of the type blob, and to add the extension, without the user having to type this extension when recovering. The way it is, I’m saving and also recovering, but…
-
2
votes2
answers410
viewsHow to make an SQL query that returns an object instead of an array?
Not much to talk about. What I need is to know how to make a query that returns me an object instead of an array in the format: $eventos = [ new Evento(1, new \DateTime('2015-01-26'), 'Titulo #1'),…
-
2
votes1
answer558
viewsHow to recover MYSQL password with mysqld error
today was wanting to change the root password of my mysql that is on a windows server 2008. However I ended up forgetting the password, searching checked several techniques stopping mysql and…
mysqlasked 8 years, 4 months ago Rafael Assmann 381 -
2
votes0
answers226
viewsCursor stored Mysql precedent
I am inside a cursor that has 10 Rows of result. 2 Rows percentem is a number. example: 1,2 = 1, 3,4 = 2, 5,6 = 6, 7,8 = 9 , 9,10 = 3. How do I add only the values that correspond to the same number…
-
2
votes2
answers2632
viewsWhat’s wrong with this query? Not Unique table/alias
I came across a problem: 1066 - Not Unique table/alias: 'catalog_product_entity_decimal' SELECT DISTINCT catalog_product_entity.entity_id, sku, price as preco, qty as quantidade, stock_status as…
-
2
votes4
answers94
viewsTable A data not contained in Table B
Following tables: Table: Users Id , Name Table: Card Id, Idusuario, Descricao I make the query to know which user has no card: SELECT * FROM usuarios as u LEFT JOIN cartao as c ON c.IdUsuario !=…
-
2
votes1
answer673
viewsRange of dates VARCHAR/DATE
I have a date field (type VARCHAR) in my table, and recently I needed to search the database with date range. And for that I used the operator Between, getting something like: BETWEEN 15/08/2015 AND…
-
2
votes1
answer101
viewsDoubt how to query several tables with a word
I am setting up a search system, where the user type in a search box any word, Example "Programmer", mysql will have to search that word in various fields in various table, if by chance he finds…
-
2
votes1
answer46
viewsSearch does not work correctly when using JOIN
I have the SQL below and the parameter where the part JOIN contratos co ON c.email != co.email is not working. My goal is that the c.email is not in the contracts table. No SQL error is shown. If I…
mysqlasked 9 years, 1 month ago Diego Marquez 320 -
2
votes1
answer66
viewsSelect dates based on the total sum of a given column
Good night. Based on the example registration attached, I would have to select all dates that are equal and are in the same restaurant and the sum of the amount is > 10, because I need to disable…
-
2
votes2
answers253
viewsDisplay different objects with equal groups
I tried it in various ways, got different results some good, others not so much. I would like to do something like store group/objects in Mysql and display on screen using PHP I have this table I…
-
2
votes2
answers2838
viewsWrite data to two tables from a PHP form
Connection with the comic $host = "localhost"; $user = "root"; $pass = ""; $conexao = mysqli_connect($host, $user, $pass) or die (mysql_error()); mysqli_select_db($conexao, "teste2"); HTML…
-
2
votes2
answers834
viewsOptimization of Mysql connections
I have a pertinent question regarding the connections in my database. I was told that every new connection to Mysql a portion of the RAM is reserved for that connection. I have several applications…
-
2
votes0
answers230
viewsEfficient search with phrase and keywords
I am using the following syntax in SQL for searches: SELECT * FROM exemplo WHERE MATCH(title,content,tag) AGAINST(?) Regarding the LIKE I had a better result, but it is not yet 100%. for testing…
-
2
votes1
answer93
viewsSort Birthdays by Day
Guys, I needed a help to display on the screen the Birthday of the Month ordered by the day, in the bank he pulls the information from Senior so the date comes ex: 1970-10-30, in my controller is…
-
2
votes2
answers5400
viewsMysql not connecting connects by socket error
Good afternoon friends, after having correctly installed Mysql 5.7 on my Ubuntu 16.04, while trying to connect to the bank, I get an error message saying that I could not connect through the socket.…
-
2
votes1
answer88
viewsMysql, acess denied for user, using password: no
When creating a new project in Rails using mysql rails new exemplo -d mysql and then rake db:create I have the following error Acess denied for user 'root@localhost' (using password: NO) Please…
-
2
votes1
answer75
viewsSort Mysql results by preference
I own a table of produtos where there is the primary column id, wish to select products with the probable name of "%TV%" however i want it to be ordered so DESC normally, however I want some IDS…
-
2
votes1
answer2343
viewsCreate Trigger update Mysql
I have two tables one apartment to another contract. When the status of the contract is changed to off. The status of the apartment is free. I have a foreign key in the contract table to relate to…
mysqlasked 8 years, 3 months ago Ramon Chaves 57 -
2
votes3
answers833
viewsSelect works on the localhost but does not work on the server
The select was working normally on wamp, but when uploading the site to the server the information of some of the sites simply stopped coming. The only part where the selectis working is the login…
-
2
votes2
answers64
views1054 - Unknow colunm in on clause
what’s wrong with this consultation? SELECT clientes.idClientes, clientes.nome, clientes.bloqueado, planosclientes.idPlanos, planos.nome, enderecos.bairro, enderecos.cidade FROM planosclientes INNER…
-
2
votes1
answer7488
viewsHow to count down with jQuery?
I’m writing a script for study purposes at that link and would like to implement in this script a clock with countdown as is done on collective purchase websites and would like the help of you to…
-
2
votes1
answer346
viewsNumber of lines increases after use of JOIN
Hello, I’m new to SQL and I’m having a doubt. As in the example below, I wanted to take from a table 'b' the description of the code present in table 'a'. But the number of rows in table 'a' when I…
-
2
votes2
answers6584
viewsMultiple checkbox and save to bank
I have a form on which I will be able to mark several checkbox at the same time and wanted to know how I identify those marked and save them in the database. On the bench I’ll have a table and a…
-
2
votes1
answer3358
viewsQuery in relationship table N:N
How to display all projects that have a specific advisor? The relationship between Supervisor and Project is N:N, therefore contains the table Projeto_has_Orientador as relationship table. Tables:…
-
2
votes1
answer203
viewsIndexes in primary key columns
I know that each case is a case, and that there are no ready-made rules on the creation of indexes. In my case, considering that the primary key of each table of my bank is used in wheres of my bank…
-
2
votes3
answers8116
viewsHow to join 2 tables in a select?
Guys I have the following tables in my BD Mysql: produtos_pedido with the following fields id,id_request,id_product,Qtd produtos_troca with the following fields id,id_request,id_product,Qtd Well I…
mysqlasked 8 years, 3 months ago Hugo Borges 5,294 -
2
votes2
answers146
viewsWhy don’t you update?
If you search only one like this and run the foreach it does the update but if you have more it no longer does... But if there’s more of one like in the other image it doesn’t change and it doesn’t…
-
2
votes0
answers58
viewsThe loaded screen is correct but the data is saved in another BD table
on the company website, we are doing some tests with scheduling. Problem is that although you are loading the correct screen on the website (the scheduling form), the data that the client types, are…
-
2
votes1
answer417
viewsShow Image inside another
Galera So and I have this picture of wallet and I need to display another image on top of the case the photo of the person, I was able to enter the data searched from the bank but the photo of the…
-
2
votes1
answer290
viewsHelp to fill jTable
I’m filling out a jtable with the birthday kids who are registered in a database. public void jTablePop() { javax.swing.table.DefaultTableModel dtm2 =…
-
2
votes1
answer42
viewsHow to get the penultimate item of a string?
I need to get the penultimate name from inside a string. For example; Antonio Alves Ferreira Castro need the Ferreira I know to catch the Castro I can use the SUBSTRING_INDEX(NOME, ' ', -1) tried…
mysqlasked 8 years, 2 months ago Guilherme Freire 767 -
2
votes3
answers7106
viewsHow to query a date range in mysql?
I want to make a comparison if the date is within 30 days. For example, I have the date 10/01/2016 and I want to return all results with dates 30 days next to this for example, 09/02/2016.…
mysqlasked 8 years, 2 months ago Guilherme Freire 767 -
2
votes1
answer446
viewsMysql UPDATE function is editing right, but creates a new empty row at the end of the table
I’m racking my brain here, because function UPDATE works well when used neatly by the terminal or Workbench, but when I do the PHP code via HTML form parameters, it edits neatly too, but creates a…
-
2
votes1
answer213
viewsPhonegap Serve, Build Phonegap and Mysql
I’m developing an app using jquery mobile and phonegap. Question: why when I test the application on 'phonegap serve' of node.js works and when I download apk created by Buil Phonegap nay? Example:…
-
2
votes1
answer104
viewsMysql table with lots of data
Case in point: I have a system with approximately 5 million records, it is recommended to use a single Mysql table to save, for example tabela_empresas_brasil? since every time the user performs a…
-
2
votes2
answers1052
viewsSelect PHP in tables with special characters
For some reason DBA put "ç" in the name of tables in the Mysql database and now I can’t select these tables from php: $conn = new mysqli($servername, $username, $password, $dbname); $sql="select *…
-
2
votes1
answer90
viewsSearch in mysql database
I have to do a search in a table, I have to pass up to 3 parameters to filter my search, this is my method: public List<Motores> pesquisaMotores(String serie, String marca, String modelo) {…
-
2
votes1
answer254
viewsConvert Mysql to Mysqli
3 Errors are presented: Notice: Undefined variable: save in C: xampp htdocs index.php on line 6 Warning: mysql_num_rows() expects Parameter 1 to be Resource, Boolean Given in C: xampp htdocs…
-
2
votes1
answer220
viewsWhy does the index() method not recognize the [IC] redirect?
I’m following a course and stopped at a problem that I can’t solve. In this link it is possible to register a user and when finishing the registration he should go to this page but the only thing…
-
2
votes1
answer305
viewsGoogle Chats: Show total above column and grid show 1 to 1
I have the following Chart: I need to display row 1 to 1 and display the number also of the total at the top of the column. I know that the two will give the same result, and that I have 2 different…
-
2
votes2
answers2146
viewsIs it possible to connect a C-based application to a database?
We usually use files to save data using language C (at least). It is possible to connect a relational database to any application made in C? If yes, do you need a library for this and how is this…
-
2
votes1
answer2550
viewsCapitalize string with accented characters
I have a problem saving words with accents in MYSQL. My bank is all set in ut8_unicode_ci and on my php pages <meta charset="utf-8">. This solved my initial problem with accents, but I wanted…
-
2
votes0
answers647
viewsMysql Workbench connection in Phpmyadmin?
Good morning. I’m trying to make a Mysql Workbench remote connection to my AWS cloud, where Phpmyadmin is installed, but I’m not getting it. The error presented is: I’ve Googled this mistake but…
-
2
votes2
answers3059
viewsTo group and remove lines with "null" values from this query in Mysql
CREATE TABLE tblCliente ( idCliente int(11), estado int(1) ); CREATE TABLE tblPergunta ( idPergunta int, idCategoria int, pergunta varchar(255), tipoResposta tinyint(1) ); CREATE TABLE…
-
2
votes3
answers221
viewsError: the right syntax to use near 'add
I don’t know what’s going on but my code doesn’t work it is simply not entering data into the table <?php include "../../lib/inc_con.php"; session_start(); $mesa = $_POST['mesa']; $tamanho =…