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
votes2
answers949
viewsInsert the json format into mysql and recover in Java
I have the following string in format json: { "ADT":"0", "CHD":"0", "INF":"0" } I need to do the Insert in a table on mysql database and retrieve it in Java. I’m using VARCHAR(50) and it looks like…
-
2
votes1
answer3086
viewsFullcalendar fetch data from php database
I’m generating a calendar for a website, and I’m obligated to use the tool fullCalendar. The point is to fetch the events by php from my database. In js, the data is listed in the following…
-
2
votes1
answer1846
viewsStoring images in Mysql and treating by file size
I was able to store images in my bank, the problem now is just to treat so that the images only enter the bank to a certain size, assuming: 800kb. How to proceed? Follows the code: Botão Gravar:…
-
2
votes1
answer90
viewsDoubt, query does not work exactly as I want... PHP
I have a table in the database called emails, with the following fields: id subject body e status (0, para não enviado, ou 1, para enviado). I was making a query to recover only the lines that have…
-
2
votes1
answer569
views -
2
votes1
answer2175
viewsIs there any way to recover data from a Mysql database?
I gave a delete on some files from table, it has some way to recover? I heard about the "flashback", but the little I researched is only for oracle.
-
2
votes1
answer1487
viewsHow to search a term in more than one table field
How do I search for a term in more than one table field in Mysql? For example, I have a website of a furniture store and the customer can search for the term "chair" and this term is in the fields…
-
2
votes1
answer56
viewsHow to download a BD from the console?
I need to download a database on my machine, but it can’t handle Mysql Workbench. Is there any other program lighter than Workbench or which commands for me to download the BD I want?
-
2
votes1
answer950
viewsReturn total of each order with Mysql?
Imagine I have a table pedidos with the following fields: And that I have two other tables (pedido_a, pedido_b) of two different types of applications as the examples below: Each item in the table…
-
2
votes2
answers674
viewsCodeigniter - Query in DB
Good night! I need to return the value of a table in codeigniter but it is acknowledging the error below: PHP Error was encountered Severity: Notice Message: Undefined variable: name Filename:…
-
2
votes1
answer1825
viewsAllow a user to view stored procedures created by other users
I have a Mysql database populated with some stored procedures. The problem is that two different users have created several procedures, so that only the user who created the stored Procedure can see…
-
2
votes2
answers407
viewsHow to use Mysql view’s with Spring Data and eclipselink
In the development of my project I came across a select that will require a lot of application performance, as it consists of using two Join’s. Soon came to mind the creation of a view in Mysql, but…
-
2
votes2
answers3503
viewsSelect to subtract current value from previous and return column with result
I have two tables: Samples and Values, which have columns as follows: TABLE Samples Amostra_id Data Operador_Id Carta_Id TABLE Values Amostra_Id Valor As you can see, the Values table relates to the…
-
2
votes2
answers497
viewsQuery mysql does not work with variable - PHP
The mysql query works with normal variable, but not with jquery post variable, example: DOESN’T WORK $agenda=$_POST['agenda']; $query = mysql_query("SELECT * FROM `compromiso` WHERE login LIKE…
-
2
votes1
answer5224
viewsDefault Timestamp Mysql
How do I put the field value by default timestamp current? Precise alterar my table to add a field timestamp not null that has by default the current, with this I need all previous registrations to…
-
2
votes1
answer46
viewsTotal sum of values of all dates
How do I sum X values of a specific date and compare if the summed value is greater than 100? /* Data das consultas, e para cada data o somatório total dos valores, desde que este total seja maior…
-
2
votes3
answers255
viewsSelect with joins return last result per date
I have the tables drives, Documents, and Defenders: Defenders id | nome | cpf 1 | Nome 1 | 000000 2 | Nome 2 | 000000 3 | Nome 3 | Drives id | document_id | defender_id | data 1 | 123 | 1 |…
mysqlasked 10 years, 3 months ago morphinduction 473 -
2
votes1
answer2588
viewsMysql server cannot start in Centos
I cannot perform any operation in Mysql as it gives error of: Starting Mysqlcouldn’t find Mysql server root@server2 [~]# /etc/init.d/mysql status MySQL is not running, but lock file…
-
2
votes2
answers1914
viewsHow to make Insert in tables with many relationship for many?
I’m having second thoughts about how I’m gonna do the Insert relationship n:n my tables are: Recibo Analise Analise_Recibo (recibo_id, analise_id)…
-
2
votes1
answer97
viewsGet data according to Mysql date
I need to provide the option to view the data according to an X time determined by the user, for example I want the data from 01/03/2011 until 25/12/2014 How can I do this with Mysql? How do I need…
-
2
votes4
answers2214
viewsSQL query return total of days in a month on two dates
I have the following tables: staff: id_funcionario other information... historical: id_funcionario data_input dating I tried some querys but I couldn’t get what I wanted. What I need is, after the…
-
2
votes1
answer1370
viewsProblem with accentuation Curl
I have a code that sends data via cURL to another page inside the server, only I have a problem... When sending this data to the other page, it inserts it into Mysql only when seeing the record…
-
2
votes1
answer393
viewsSeparate Rows by group and their percentage of total
I need to get the top 10 results that appear in my table and their respective percentages by groups. For example the table: +-----+-----+ |id |fruit| +-----+-----+ | 1 | or | | 2 | ban | | 3 | or |…
-
2
votes2
answers953
viewsHow to install PHP server with separate components
A dumb question but I searched here and found nothing. I already have Mysql running on my computer, how do I install PHP without installing Easyphp, Xampp? Because usually these programs already…
-
2
votes1
answer392
viewsVagrant with PHP + Mysql + Linux + Puphpet + ZF2 very slow
I have a Windows-mounted environment with ZF2, Doctrine and Mysql that runs very fast. But now I’m experimenting with Vagrant with the machine configured through Puphpet. I managed to make the…
-
2
votes2
answers519
viewsHow to replace from one server to another?
I have the table below in 2 servers and I need server 1 to send all this information to server 2 ie fields id, username, iddns, dns, ipdnstipo e ipdns as it is. Table CREATE TABLE IF NOT EXISTS…
-
2
votes2
answers543
viewsOn-demand content problems (Infinite scroll)
I am trying to make the content increase check the user descends the scroll bar, but my code stopped here.. <script> $(document).ready(function() { var limit = 5; var offset = 0; var altura =…
-
2
votes1
answer247
viewsHow to insert data into mysql via ajax + php + Foundation 5
I was wondering how can I insert data into Mysql via Ajax + PHP using the Zurb Foundation 5 Framework? The "data-Reveal-ajax" property of the framework already replaces an Ajax insertion function?…
-
2
votes1
answer71
viewsSelect in encrypted value
Well, I created a table and entered a value into a field using SHA1(Encrypt), and I don’t know how to select the value by this encrypted field. TABLE: CREATE DATABASE IF NOT EXISTS `quest`; USE…
mysqlasked 10 years, 2 months ago Gabriel Sales 1,257 -
2
votes2
answers14672
viewsRefresh the contents of a page without reloading it
I am working on a project for college where I would like to update the content of a page without reloading it. The page in question has its content received from a script PHP, which in turn picks up…
-
2
votes1
answer204
viewsIs it possible to work with spatial object attribute tables in Delphi and dbExpress?
I have a spatial database in Mysql where the geometry and attributes of space objects are stored. I tried to create a basic form, as basic as possible using Sqlconnection, Provider, Dataset,…
-
2
votes1
answer129
viewsProblems connecting Mysql with Asp.net c#
A small problem appeared, which in my old application worked normally. My DAL Class, is not connecting in Mysql. Since all the connection parameters, I believe it is correct. My DAL who makes the…
-
2
votes4
answers3027
viewsLoading the values of a select in my Gridview
My DAL who does the Select and saved in the list type<> using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Web; using MySql.Data; using…
-
2
votes1
answer532
viewsStock control
Guys I’m developing a shopping cart... I arrived at a part that ended up gone wrong... the next cart consists of product recipe is additional and removal of ingredients tabela produtos id nome…
-
2
votes2
answers231
viewsRead phpMyAdmin column with multiple records
I have a table in phpMyAdmin with a field that stores several values, the column is named id_subfilter, I need to read each value of this, because the same are id s that are related to another table…
-
2
votes1
answer605
viewsFilter dbgrid with lookup fields
I made a generic search form for my application, but now I realized that I can’t filter the dataset using lookup fields, is there an alternative to not using a query? A component that can do this…
-
2
votes1
answer1166
viewsConvert Integer to Decimal in SQL
I have numbers in the database that are in the whole format. Ex:12345 I want to convert it to price format, in real ones. Ex: 12.345,00
-
2
votes1
answer1439
viewsCodeigniter to know if Insert worked?
Using codeigniter how can I know if the Insert into worked really? $novo_usuario=$this->db->query("INSERT INTO usuario (nome, email) VALUES ('pessoa','[email protected]')"); Via the variable…
-
2
votes1
answer325
viewschange page 10 query in 10 seconds
I have a page that lists all my events from the event table (tbl_eventos). I want to list all the events of the first week of the year, last 10 seconds, list all the events in the second week of the…
-
2
votes1
answer981
viewsSQL query does not work when it has accents
I have in my database a category defined as LAND/AREAS that when making the following SQL query does not return any result of the existing 18. SELECT * FROM immovable WHERE 1=1 AND CATEGORY IN…
-
2
votes2
answers426
viewsstr_replace using arrays
I want to blacken the terms searched in the results, but when I use the explode, and I try to use in str_replace, I get a array back. <?php $search_term = filter_var( $_GET['s'],…
-
2
votes1
answer126
viewsList ID with name in the same table
I need some help. I have a table of categories that has the fields: id; name; description; id_categoria_pai; id_user; I want to get the category name when the parent id is equal to the category id.…
-
2
votes1
answer3043
viewsMysql query by loading table with search button
I need some help. I need to make a Search button, get the parameters of some selects(combobox) and update a table below the filters. But I don’t quite know how to do this, to press every click on…
-
2
votes3
answers780
viewsSelect data and display
I’m having trouble looking up Mysql in a simple way. I already have a file on includes connection to the bank that works normally. But I’m not showing them. The code I found on Google. 1 - I don’t…
-
2
votes2
answers1700
viewsQuery to return only higher values
I have the following table: Contract | Code | Year 13 7800 2015 12 7800 2014 12 7800 2013 12 7801 2016 12 7801 2013 12 5102 2017 I am trying to make a query to return the result below, that is, the…
-
2
votes1
answer41
viewsProblem with special char insertion via prompt
Dear, I have a table where I do some Inserts with data containing special char. Currently I use Toad for Mysql, and when I do the insertion by this editor, everything happens correctly, the special…
-
2
votes2
answers79
viewsAdd a login field to an existing user table
What would be the best way to add a field of login in an existing database table with about 10,000 users. I am currently using Mysql and would like to remodel the user table, at the moment the table…
-
2
votes1
answer35
viewsQuery not identifying value
SQL command: SELECT message, count(message) as amount FROM `messages` WHERE LENGTH(message) >= 4 AND amount < 30 AND message != '#ddd' AND message != 'ddd' GROUP BY message ORDER BY amount…
-
2
votes1
answer4486
viewsEntity Framework Connection with Mysql
I did the procedures outlined in these questions: Entity Framework - Bank Compatibility Error Mysql Connection Asp.net MVC I installed Mysql.Data.Entities. My web.config looked like this:…
-
2
votes2
answers229
viewsView how many people accessed pdf
I have a pdf on my server and I put it available through a link, there is way to control how many people access the pdf?