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
answer329
viewsWhat are the differences between sql commands?
What’s the difference, when I should use the following sql commands and which expressions can follow these commands? order by ,group by, join e union What is it for and when to use the commands…
-
0
votes2
answers142
viewsWhy this SQL syntax error?
$termos = (explode('/', implode('/', $_GET['tipo']))); print_r($termos); Array ( [0] => CASA [1] => CASA EM CONDOMINIO [2] => COBERTURA ) I have a syntax error in this SQL that makes loops…
-
0
votes1
answer13698
viewsError Code: 1064 - Mysql
Hello, everybody! When building a simple inclusion process gave this following message! Error Code: 1064. You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server…
-
0
votes0
answers110
viewsProblems adding action to Zend Framework 1
I’m having trouble adding a song that contains on the album, I want to make sure that when I add a song, it’s already related to the album id. My problem is in the add method() below:…
-
0
votes1
answer155
viewsQuery that selects last line of each device?
I have 3 tables in my DB: CREATE TABLE IF NOT EXISTS `local` ( `codigo` int(11) NOT NULL AUTO_INCREMENT, `IMEI` varchar(15) NOT NULL, `latitude` decimal(10,6) NOT NULL, `longitude` decimal(10,6) NOT…
-
0
votes1
answer41
viewsStoring a request in a saved server resource variable?
Using Wordpress I will need to use the article link more than once, I wonder if storing the 'permalink' in a server resource saving variable, since I will only make a request to the database or…
-
0
votes1
answer1021
viewsHow can I paginate these results?
I made an SQL to filter results according to the desired parameters which resulted in the following statement: $query = $pdo->query("SELECT * FROM imovel ".trim($where, ' AND ')); Whereas I used…
-
0
votes2
answers1761
viewsDatabase image displayed in primefaces does not appear
I am implementing a page where I need to display a datagrid with the values of a table in the database. Each table row has a blob image. But when trying to display the image with the primefaces by…
-
0
votes1
answer720
viewsInsert selected records into another table
I need to export data from a table I have in our intranet to a table on the internet, I created a table where I show the events and in this the user can choose the ones that want to export through…
-
0
votes1
answer178
viewsHow to send and receive data to BD Mysql using PHP in Objective-C?
Scenario: Send and receive forms to a Mysql database using PHP. I wonder if anyone knows or has any link to a didactic and clear tutorial about these procedures, sending and receiving using JSON.…
-
0
votes2
answers71
viewsRequesting to download the file in the middle of the run
I have a small problem, I have an execution in PHP that generates an average of 34 thousand Insert’s in Mysql, this is done via stored Procedure. But when I run the same execution is around 5…
-
0
votes4
answers1559
viewsJquery does not work in PHP
I don’t know why. The page doesn’t work. Does anyone know how to help me figure out the problem? I want the date mask to work in the fields data and in the field Venc_Garantia someone can help me?…
-
0
votes1
answer1593
viewsRecords are duplicating when entering in the database
I’m doing an API and I’m going through a problem. When executing the script that calls the page via Curl, it does the insertion of a register in the database, but when it comes to registering only…
-
0
votes1
answer35
viewsMysql Query - Transfer
I have the following appointment: SELECT despesa.codRequisicao, despesa.histDespesa, despesa.despesaPassagem, despesa.despesaTaxi, despesa.despesaHotel, despesa.despesaRefeicao,…
-
0
votes0
answers60
viewsNo suitable driver found (Mas o driver esta la !)
Guys, I made a first application through the Caelum site in Java EE, a calendar, and all right, all right, fine, I added contacts to MYSQL quietly in the Java part of the workbook, the JDBC driver…
-
0
votes2
answers4154
viewsDROP DATABASE in phpMyAdmin
How do I enable DROP DATABASE in phpmyadmin? Every time I try to drop a bank gives error saying that the command is not enabled. I’m using phpMyAdmin on my local machine’s WAMP.…
-
0
votes3
answers1119
viewsPHP is not displaying array output
I have the code: <?php $d = json_decode($output); ?> The variable $output sends json data to PHP. To better understand this variable, I will post the return of it object(stdClass)#1 (6) {…
-
0
votes1
answer193
viewsValues that are calculated, if you store the value with the calculations in the database?
I am developing a system where a product undergoes 3 changes before reaching its final value: Individual Discount, Selling Bonus and General Discount I want to know if, I should store only the…
-
0
votes2
answers463
viewsHow to compare an inserted sentence with existing ones in the comic returning the probability of being similar?
I would like to know how to compare a phrase inserted by the user with those in the BD in order to return the probability of being similar. I have a similar code that compares two strings in JAVA…
-
0
votes0
answers33
views -
0
votes2
answers1263
viewsRun SQL files inside subdirectories on Linux
I have an SQL file repository where each one represents a stored Procedure. These files are inside a directory organized in other subdirectories. Example of my directory structure: stored-procedures…
-
0
votes1
answer632
viewsNumerical sequence
I have a database (Mysql) with about 100 registered clients and am creating a table (ranking) of purchases of these customers, I know that the bank creates an ID autoincrement, would like to put in…
-
0
votes1
answer111
viewsMysql Stored Procedure Error
I have a table of links that I need to delete every month to include new data. I made a stored process to automate this process. This table has about 3 million rows in a monthly period. This can…
-
0
votes1
answer502
viewsError in Function connection class code
I’m in trouble, look at the code I made: <?php class banco { public function __construct() { $banco_hostremoto = "127.0.0.1"; $banco_hostname = "localhost"; $banco_usuario="root";…
-
0
votes1
answer58
viewsHow do I use Mysql in a common form?
I’m having trouble using a Mysql database I have on a host (Bluehost) in a C#application, I would like to view the tables in an application but I can’t connect to DB , I already installed the Nector…
-
0
votes1
answer1069
viewsWhen repairing causes error - 'Lost Connection to Mysql server During query' - An idea?
Follows the code: ZQuery1.Close; ZQuery1.SQL.Clear; ZQuery1.SQL.Add('SHOW TABLES FROM '+zConnRepara.Database); ZQuery1.Open; ZQuery1.First; Progressbar1.Max := ZQuery1.RecordCount; lTemp := '';…
-
0
votes1
answer489
viewsDelete a record after making a query?
Exists as after a query delete the returned result from a bank? I have a message table (from,to,message) each time I refer I should delete the read message(s).
-
0
votes1
answer397
viewsThe mysql start command path is not set?
I’m trying to connect web-service in netbeans on Ubuntu with mysql server, but when I click start this image error:…
-
0
votes2
answers2674
viewsHow to work with Base64 encryption in Mysql?
I need to work with encryption in Mysql and need to use base64 because hearing that MD5 has a small flaw that allows it to have two distinct passwords with the same MD5. I need to encrypt and…
-
0
votes1
answer704
viewsQuery Mysql in Visual Studio does not return all data
I have a problem in Visual Studio, where in my database access class, I have a query that makes a query in my Mysql database, and returns only the last result. Therefore, when I test this same query…
-
0
votes1
answer1336
viewsHow to get the next ID to be inserted?
I’d like to get the next ID inserted, something like: $ultimoid = (DB::lastInsertId()); $futuroid = ( $ultimoid + 1 ); The goal is to previously know the ID that will be used in my INSERT because…
-
0
votes2
answers153
viewsProblem when logging into the Gento backend
I made a mirror copy of a website in Malta. The site runs cute on front-end, loads fast and all, but when I try to access the admin, besides taking a long time to the login (2.3 minutes), when I do…
-
0
votes0
answers441
viewsMysql For Excel and options to import Excel table in Mysql
I am trying to import a database that is in Excel format to Mysql. I was trying with Mysql For Excel, launched same company. As you can see in the image below it is already installed: In my Excel…
-
0
votes2
answers1386
viewsHow to renumber table Ids in Mysql?
I deleted from my sales chart the test sales records made by me, and the sales canceled. Then the sales numbering became disorderly, like: it starts with 9, 10, 11, 14.... How do I order sales from…
-
0
votes4
answers964
viewsHow to do advanced data filtering across multiple fields?
I have a table from which I need to get results varying by certain user data: I need to return the rows where each column or hit with the respective user parameter or is empty (null). Consider as…
-
0
votes2
answers769
viewsError "Unknown column" in Mysql query
Code: (SELECT TB_INGREDIENTES.ID_INGREDIENTE, TB_INGREDIENTES.INGREDIENTE, TB_INGREDIENTES.QUANTIDADE_INGREDIENTE_TOTAL, TB_INGREDIENTES.FLAG, TB_INGREDIENTES.ACRESCIMO,…
-
0
votes2
answers856
viewsRemove duplicate lines in a Mysql query
I need to do an SQL query where returns the last messages exchanged between users (my account for example) and who I talked to... regardless of whether the last conversation was sent or received.…
-
0
votes2
answers4944
viewsPut value on everything null in mysql
I have the following problem,I created a table in mysql added all the records and after that I created a foreign key in it, this table contains information of only one "thing", however in the future…
mysqlasked 9 years, 10 months ago Rodolfo Oliveira 917 -
0
votes1
answer1815
viewsInnerjoin no Codeigniter
I’m working on a code and I need to make an association, where I have to count the amount of voting in a video. The problem is that there are 2 tables a videos and voting . In videos is the…
-
0
votes2
answers4604
viewsHow to insert by selecting from two different tables?
TABELA 1 - ID - IMOVEL - CODIGO - IMAGEM_G <----- nessa tabela este dado é vazio. - IMAGEM_P TABELA 2 - ID - IMOVEL <----- nessa tabela este dado é vazio. - CODIGO <----- nessa tabela este…
-
0
votes2
answers436
viewsPHP instruction executed directly by Mysql
Currently, as the sending of the email was giving a lag in the application, because it has to connect with Gmail etc, I transferred to the server the mission to send these messages, as follows::…
-
0
votes2
answers1317
viewsHow to get info from one column of the database via the GET method I receive from another page.
I’m new to php and database. I would like to know how to search in the database the "name", "password" "email" through the id I receive via _GET from the previous page and display on the page I am…
-
0
votes2
answers257
viewsPick up messages sent and received from Mysql
I am developing a personal messaging system and I need to list the messages I received and the messages I sent, only that I am having difficulties, because the code I did can only get all that I…
-
0
votes1
answer101
viewsHow to sum up the days according to a period?
How to sum up days according to a period? Example: +--------------+--------------+--------+----------+ | data_ini | data_fim | codfun | qtd_dias | +--------------+--------------+--------+----------+…
-
0
votes1
answer1489
viewsupdate mysql using array
I’m having trouble inserting an array into the database... I tried this script but it only inserts the last id of the array; <?php $_conexao = mysqli_connect("localhost", "root", "",…
-
0
votes1
answer169
viewsChange user data without it needing to login / Login
Good people, I think a lot of people who work with PHP has already come across this my question which is: When I edit something on user it does not edit soon, IE, have to log out and log in to…
-
0
votes1
answer170
viewsFollow users php mysql system
Good people, I need to make a follow system for users of my site as notifications but I never did and I don’t know where to start, I needed an idea of how I can make this system.
-
0
votes0
answers55
viewsCreate function for formatting from (X-1, X-2, X-3) to ('X-1', 'X-2', 'X-3')
I have a query that returns some char type keys like this X-1, X-2, X-3. The problem is that now I need to use with where chaves in( ... ) and would have to format the values to 'X-1', 'X-2', 'X-3'.…
-
0
votes3
answers2134
viewsCompare Mysql Select Values
I have a table with four columns, the first with one type, the second with the minimum value , the third with the max value, and the fourth with the data I want. I need to select the value of the…
-
0
votes2
answers905
viewsGoogle Maps with file_get_contents error. What can it be?
I am implementing Google Maps on a real estate site and I have a problem to solve: the request gives error of file_get_contents($url) ... Right in the middle of the code has the result of the…