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
answers183
viewsDifferent results for Mysql 5.1 and 5.7 query
We developed a project for a client using Mysql 5.1.68 and at the time of publication we identified that the client’s hosting had version 5.7.4. After publishing the project, we started to check…
-
0
votes1
answer27
viewsupdate blank column with mysql php
I need to perform an update in a table but only in columns that are blank and not all, only a specific number. For example, having this table: col1 col2 col3 col4 col5 col6 col7 id1 val1 val2 id2…
-
0
votes1
answer174
viewsNo query Executer Factory Registered for 'sql' language
In my project there are some reports and graphics, using DynamicReports which function properly in the IDE Netbeans without any mistake. But through the command line running the jar java -jar…
-
0
votes0
answers416
viewsClass mPDF + file_get_contents
I have the following code to generate a PDF file and I want to use file_get_contents to include a chart and table that are generated dynamically on another page but the result is not as expected.…
-
0
votes1
answer102
viewsMysql with android
I looked in several forums on how to integrate mysql with android, simple thing, like list the data of a table saved on an external mysql server. Using normal java I managed to do using jdbc. I…
-
0
votes1
answer98
viewsReturn SQL data mysqli_fetch_assoc organized in a table
I have the following SQL <?php require_once("php/conexao.php"); $strSQL = "SELECT id, titulo FROM questoes ORDER by id DESC"; if($result = mysqli_query($conexao, $strSQL)) { while($row =…
-
0
votes1
answer294
viewsStore file with more than 1 Mb Mysql
I am trying to write a file to a mysql database using Delphi. For files with size smaller than 1Mb is working perfectly, however for file with bigger size I am having problems. The following error…
-
0
votes2
answers4855
viewsHow Select SUM(',''',''''')
Personal I’m just with a doubt, about how the mysql select works. Select SUM(IF('','','')) I’m using it but I don’t really know how it works
-
0
votes1
answer40
viewsDatabase Encoding - German Characters
I come across a strange situation, when I try to insert German characters(ě,ě) into the database they are inserted as follows: "üüü " The field is defined as utf8_general_ci If you enter the data…
-
0
votes0
answers55
viewsError in PHP PDO Class
Guys I’m trying to use the PDO class in one of my systems and this error is appearing, and the PDO class is already installed. Fatal error: Class 'PDO' not found in…
-
0
votes0
answers207
viewsHow to write text and image together in mysql with Asp.net mvc
I am creating a forum in my application and would like to know how to save image and text together in Mysql, as in the message field there will be a WYSIWYG editor so I will have to record both text…
-
0
votes1
answer93
viewsMYSQL access by an application
I am creating an application in C# this, connects to a remote Mysql server, enabled for any IP to have access to my BD with a read-only user. My doubt is the following: There is a way in Webservice…
-
0
votes1
answer152
viewsHibernate shows ddl but does not create tables in the database
When starting wildfly I expected the tables to be created in the database but in the console shows a log of create Tables but nothing happens in the database. Below I show it: 14:15:00,462 INFO…
-
0
votes2
answers6610
viewsSelect within select sorted by the second mysql query
I got a problem, I don’t know if I’m doing it right, but come on. I have a table that lists some employees ( tblTecnicos ). I have another table , which has the records of services that these…
-
0
votes1
answer165
viewsApplication to manage database in Raspberry pi
Hello. I need to develop an application for Android, to extract and delete a mysql database in a pi Raspberry, being in the same network. I thought about doing it per ssh, however, I never developed…
-
0
votes1
answer106
viewsUse variable in 2 php files
I have a small problem trying to use 1 variable that comes from another php file. Ex: I have a connection file where I have all the data on the database, but in the insert file I need to use one of…
-
0
votes1
answer1016
viewsInput type file with pre-selected image
I have the path of an image in the database ex: admin/conteudo_admin/imagem_noticia/athletes.jpg I have this input type="file" and intended that this image was selected <input type="file"…
-
0
votes0
answers65
viewsSQL error in your SQL syntax
I am importing an sql with the following code: CREATE TABLE blog ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(250) NOT NULL, body TEXT NOT NULL, url VARCHAR(250) NOT NULL); But is returning…
-
0
votes1
answer48
viewsCreate a Three Table Viewer
How to create a view in mysql with 3 tables being the following structure cliente |id_cliente |nome_cliente produto |id_produto |nome_produto |valor_produto pedido |id_pedido |id_produto |id_cliente…
-
0
votes0
answers26
viewsProblem turning collected data into a json file
I am trying to write in a file . json, information I collect from a database but for some reason nothing is written. Follow the code: require_once('../helpers/connect.php');…
-
0
votes1
answer28
viewsInsert multiples ids to a table
Hello, I have the following problem: I have the PERSON table and COURSE table, each person can choose more than one course, the id of the chosen courses need to be saved within the person table,…
mysqlasked 8 years, 5 months ago user3434888 129 -
0
votes1
answer39
viewsHow to save a list from an Option
I have the following code: echo "<select id='posto[]' name='posto[]' multiple='multiple'>"; foreach ($postos as $lista) { echo '<option value=' . $lista->getCodigoPosto() . '>' .…
-
0
votes1
answer61
viewsDoubt with PHP and textarea
all blz? I have a little problem. I have to send a text with paragraphs and line breaks, via php pro bd, and on another page call the text with the paragraphs and the correct line breaks, which I…
-
0
votes1
answer94
viewsPHP System to heal x user in x minutes
Good morning guys! I’m creating a little role-playing game and I’m not figuring out how to get it to heal the x user in x minutes. I managed to do via ajax, but it’s not safe right? Easily the user…
-
0
votes1
answer493
viewsHow to modify a daily statement for a monthly statement?
I have a table that is not in the normal forms of database, but it has old data that I need to get. I managed to get you to present me the daily statement, but now I need to modify to generate the…
mysqlasked 9 years, 2 months ago CristianeBaill 227 -
0
votes0
answers126
viewsHow to change image upload code to work in mysql?
I got this image upload code to work on Postgresql, but I would like to change it to work on phpMyAdmin, but I’m encountering a certain difficulty, and I would like to count on the help of friends.…
-
0
votes2
answers137
viewsNumber of entries in SQL PHP
Good, I have a question about showing the number of records in a given table. SELECT COUNT Nome FROM `tb_utilizador` I want to show the number of records in a php table. <?php…
-
0
votes1
answer218
viewsRegistration Quantity per Data Mysql
I have the following scenario. I have a sales chart, there is a field data_vendas (datetime) and a field cliente_id Another client table, with the fields id, nome, data_cadastro etc.. What I need to…
-
0
votes2
answers906
viewsCalculate difference between dates and change status
I need to create some routine to calculate the difference between two dates directly in the Mysql database and change the status of another field according to this difference. The database fields…
-
0
votes1
answer269
viewsJava mysql JDBC connection
I have a problem following this video lesson: I seem to follow what he tells me to do but the line goes red and wrong: con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/videoAulaJDBC",…
-
0
votes1
answer96
viewsDifference between texts with multiple paragraphs in Mysql
I have two fields in the table (text) that receive several lines (paragraphs) of information, for example: CAMPO1 linha1 linha2 linha4 linha5 CAMPO2 linha1 linha2 linha3 linha4 I need to check which…
-
0
votes1
answer596
viewsResult Search PDO PHP Does not return a field
I make an sql query using PHP PDO. When checking the query result, the value of a field returns empty, but the field has value. Using the SQL sentence directly in phpMyAdmin the result returns…
-
0
votes2
answers110
viewsWHM - Monitor Mysql by site
I need to monitor the use of Mysql by user in my Cpanel. How can I monitor Mysql usage separated by Cpanel client in my WHM? Is there any solution to this?
-
0
votes2
answers2229
viewsI can’t back up the mysql database using the dump
I have some questions. I need to make a copy of a database that is not on my machine, but on a server.. I am using the mysql dump command, but when I type the following command mysqldump -u user…
mysqlasked 8 years, 5 months ago Robson Araújo 105 -
0
votes1
answer93
viewsSlider jquery and variable php
I have the following page: <?php ini_set('display_errors', 0 ); error_reporting(0); include"conn_imprep.php"; if (!isset($_SESSION)) session_start(); if (!isset($_SESSION['s_usu_login'])) {…
-
0
votes1
answer288
viewsVersioning of Databases
Utilise Git + SourceTree for versioning and sharing the project with the other members of the team. But we have some problems related to the database. Is it possible to share it? Like commit in BD…
-
0
votes0
answers162
views -
0
votes1
answer497
viewsback up mysql by date folder
How do I backup mysql by data folder? I want to make a back up by the folder date, because banks are great if you do via dump will take a long time to download to climb again besides great chance of…
mysqlasked 8 years, 5 months ago hyperpixel 389 -
0
votes1
answer499
viewsHow do sum and Count in Mysql?
I have a query which brings the number of lines of a certain fault. select falhas, count(falhas) from tabela where semana = 'semana-5' group by falhas order by count(falhas) desc; The result brings…
mysqlasked 8 years, 5 months ago Humberto Costa 21 -
0
votes0
answers34
viewsHow to mount a select from DB
Good afternoon, personal my doubt and the following I have a database that lists me all the dates of delivery of works as follows 2016-07-13 2016-07-01 2016-03-09 2015-09-09 2013-03-06 how do I…
-
0
votes1
answer856
viewsFilter a query using an attribute in Laravel
I have, briefly, the following structure:: Suppliers: id | cnpj | razao_social | endereco_id People: id | nome | tipo_pessoa | fornecedor_id Addressee: id | logradouro | cep Model - Supplier: public…
-
0
votes1
answer152
viewsMerge two select, how do I do?
How to join these two SELECTS? SELECT * FROM doacao d LEFT JOIN foto f ON (d.iddoacao = f.iddoacao) WHERE (d.idbeneficiario IS NULL); SELECT email FROM doador dd INNER JOIN doacao d ON (dd.iddoador…
-
0
votes1
answer60
viewsData passed via Function
I created a function to register images that until yesterday at 18:00 functioned normally and this morning the data of form are not being passed. I can’t believe nobody messed with the code.…
-
0
votes1
answer344
viewsIs there any way to define a random order by an established order?
If the title of my question was confused, I explain: I want to sort a result of a certain query of MYSQL. Example: SELECT * FROM usuarios ORDER BY cidade = 'BH' DESC, cargo = 'Programador' DESC…
-
0
votes1
answer760
viewsSet Default Value HTML form with PHP
I have the following situation: I have a simple example of a form to display a bank’s information to change and then record it again. In this case the problem is in NOME_OPERADOR, where I wanted to…
-
0
votes1
answer448
viewsHow to Select a table row and display information in another table relative to the table?
I’m using this code, but I’m not connecting it properly... I would like to register Payments (payments) for these to appear only when selecting the partner in the table(socio)... String sql =…
-
0
votes1
answer289
viewsAdd get parameters with a select/option value in the url
I have on the page that lists the properties of my site a search form and a select that makes the result ordering. The problem: Doing a search in the form and passing the values via get…
-
0
votes2
answers58
viewsFind birthday girls of the month
I would like to make a condition where only show the birthday of the month. My controller looked like this: public function index() { $ultimoDia = date("t", mktime(0,0,0,date('m'),'01',date('Y')));…
-
0
votes2
answers323
views -
0
votes1
answer811
viewsShopping cart sql, php and ajax
I am making the shopping cart and would like to know if I should save the products that the user is buying in a table or not, which logic to always show the right product to the right user? I know I…