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
answer54
viewsProblems with Laravel Charts, always class error not found!
Gentlemen, I’m using the Laravel 5.7 and the following problem Class 'ConsoleTVs\Charts\Facades\Charts' not found I did his installation correctly: composer require consoletvs/charts added in the…
-
0
votes1
answer149
viewsDoubt in the use of the lavacharts library in Laravel consulted Mysql
Gentlemen, I am using the Google library to Lavacharts, but I have the following result: On my controller I’m doing so: $graf = new Lavacharts; $valor = $graf->DataTable(); $valores =…
-
0
votes2
answers231
viewsDifference between Mysql queries - Delphi
Good afternoon, I’m doing routine to close the inventory both in SPED and Sintegra, but is giving difference in the sum of the two. I’m using date as reference 31/12/2018. I’m using the same query…
-
0
votes1
answer167
viewsEF Core error when applying update-database
I’m creating the table AspNetUSers while applying update-database The following error occurs You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for…
-
0
votes2
answers147
viewsTake duplicity by ignoring a column with distinct information
I searched here and found nothing like it. When I make the following Select : SELECT a.idEmpregadoReserva as Controle ,(select EmpresaAplicativo from tbEmpresaAplicativo where…
-
0
votes1
answer66
viewsReturn record of each query as I click the button
I have 3 query record in a table of the database of the same user. When I query returns and shows the most recent query of the database table. I intend to return the 3 queries, always show the most…
-
0
votes2
answers467
viewsHow to make a query using variables with PHP
I am trying to make the following query in the database through PHP: SELECT * FROM nwpedidos WHERE `nomeUsuario` = 'Nome' However, the 'Name' varies according to who makes the query, for this I pass…
-
0
votes1
answer265
viewsProblem with punctuation and space when running CMD via C#
I have a program in C# that uses a button to execute a command on the CMD. This command is used to take a database on a server and put it on the machine in a path you choose(Mysqldump). private void…
-
0
votes1
answer54
viewsLaravel Query Builder - problem with two Join
Currently I have a query that takes the posts and searches through Join some user data $posts = \App\Post::join('users', 'users.id', '=', 'posts.author_id') ->select('posts.id', 'posts.title',…
-
0
votes2
answers2009
viewsPYTHON - FOR inside FOR
I’m performing a select on DB with the Python and treating this return. My doubt is in the use of a for within other’s for, use the script below: import mysql.connector mydb =…
-
0
votes0
answers69
viewsnumber of characters in Mysql
Someone said that the TEXT type allows 65535 bytes, but I can’t post more than 10,000 characters, which I’m doing wrong? This is my Table DROP TABLE IF EXISTS `cad_materia`; CREATE TABLE IF NOT…
-
0
votes2
answers766
views2 Foreign keys in the same key
good afternoon! I am doing a Database exercise and came across a problem. I am registering a BD of an airline company. In one of the tables called flight need to register the code of an airport of…
-
0
votes1
answer26
viewsXML to DB with PHP and MYSQL
I created a code that reads the XML and then inserts it into the MYSQL database, but only tries because an error is returned. It’s simple because I’m doing it for blocks. Filing cabinet conn.php…
-
0
votes1
answer64
viewsWhat to do to save registry in my mysql database
Hello I have the following code and the information does not save in my database. Can someone help me? <?php $servername = 'localhost'; $username='root'; $password=null; $dbname='task3'; $connect…
-
0
votes1
answer25
viewsPHP ERROR - On the Database Connection
Connection to phpmyadmin HOST (n code wanted to go): connection code to send to the databank: <?php include_once("conexao.php"); $usuario = $_POST['usuario']; $senha = $_POST['senha']; $email =…
-
0
votes2
answers150
viewsHow to pull all rows of the database in php but only showing the value of a specific query column once?
I’m having a problem, I have a PHP screen that shows everything from a database query. So far everything ok, but I need to show all information without replicating the requested column. Follow the…
-
0
votes1
answer45
viewsObject Orientation Is my idea of connection correct?
I want to register something in the database using object-oriented PHP (I’m actually learning) and came across a code duplication problem (every function I would have to create a new mysqli, and see…
-
0
votes1
answer30
viewssearch database specific row to fill table
I am working on a system for technical installation of internet and line, and I need to fill a table with an X number of installation by type. So far so good, I’m making a count type and grouping to…
-
0
votes3
answers69
viewsMysql - Query using Between to know if item is reserved on date/time
I would like to know if the item is booked on an X date in my BD. For example: I have the following bank: I want to book the item with Resid = 5 on the date of 02/26/2019 from 14h30 to 16h30. But…
mysqlasked 6 years, 1 month ago Maykel Esser 598 -
0
votes1
answer76
viewsError while displaying Laravel Relationship data
Gentlemen, I am creating a relationship between 3 tables, the product that takes category values and sessions, but this always returning me the following error: Trying to get Property of non-object…
-
0
votes1
answer70
viewsConvert time obtained by the database from ("Y-m-d H:i:s"); to ("Y-m-d-H-i-s");
In this case how I can convert without using the method DATE_FORMAT(data_access, '%Y-%m-%d-%H-%i-%s') in SELECT <?php $resul_ult_aces = "SELECT as data_acesso FROM adms_ultimos_acessos WHERE…
-
0
votes0
answers67
viewsNext composite primary key ID
I have the following example structure for the people table: CREATE TABLE `pessoas` ( `i_entidade` int(4) UNSIGNED NOT NULL, `i_pessoas` int(11) UNSIGNED NOT NULL, `nome` char(60) COLLATE…
-
0
votes2
answers53
viewsJSON does not return Mysql database data
I made a very simple application to search for projects by state in the database. However, JSON does not show any errors, but also does not return anything. I imagine the problem may be in GET. Do…
-
0
votes0
answers118
viewsAn Exception was Raised while Creating "Panel Authentication Adapter"; no instance returned
Talks blz, face to with an error fd.. in zf2.. (it is just a system for study, I know that the framework is outdated) , the business is as follows. I am with 2 modules, 'Panel', 'Admin' and each of…
-
0
votes0
answers69
viewsVolley: onErrorResponse is returning the error as null
My server is registering normally, but when trying to send a record to register using Volley, it drops to onErrorResponse and the object error.getMessage() is returning null. My java code: private…
-
0
votes2
answers153
viewsLIMIT and OFFSET duplicates data in mysql
I have a table in mysql but when using LIMIT and OFFSET I have an unwanted return, 1 data repeats to each search. Look at the table: then use the following command: SELECT funcionario.nome FROM…
-
0
votes1
answer28
viewsSum of values in Mysql
Good evening. I have to add the natures according to each sector of the company, but it is not going with Count. SQL: SELECT examefuncionario.exameFunc_Natureza, setor.setor_Nome FROM `funcionario`…
-
0
votes3
answers298
viewsCreate table in Mysql using Laravel
I need to create a table with Laravel using the migrate command, the table would currently only have id. Normally two tables would be created, one with the name of the database I put containing the…
-
0
votes1
answer32
viewsUPDATE registration 0 in column even passing the value
I’m trying to edit the data in my database using a form. This same form pulls from a table the data to be edited, in one part of the form there is a select to Voce select the desired field coming…
-
0
votes1
answer54
viewsDynamic input (JS) error passed to SQL by PHP
I have the code below referring to the link Add or Remove Inputs with JS function calcula(){ var total = 0; $("span[id^=linha]:visible").each(function(){ var val_unit = parseFloat($(".class_unit…
-
0
votes1
answer515
viewsMysql and python error when entering data
I have the following code: #encoding: utf-8 from django.utils.encoding import smart_str import mysql.connector mydb = mysql.connector.connect( host="localhost", user="[--CENSURADO--]",…
-
0
votes0
answers552
viewsHow to test with Junit in a C R U D?
I would like to know the condition to use within the test. Got the class Customer package br.myhome.web.model; import java.sql.Connection; import java.sql.PreparedStatement; import…
-
0
votes2
answers320
viewsTwo foreach in a select
Good evening. How do I use foreach suns to check if the names are equal and so leave them with selected. Follows the returns of the variables: $risco_e = Array ( [0] => Postura Inadequada [1]…
-
0
votes1
answer62
viewsHow to pass checkbox data through FILTER_SANITIZE in PHP?
I’m not getting past the values of checkbox in PHP. I have a single file home.php with the following code: <?php session_start(); ob_start(); include_once("conexao.php"); $btnCadastrar =…
-
0
votes1
answer30
viewsHow to make a database information array in codeigniter
For example, I am sending an id array [0] => 1, [1] => 3 and I want to show this in my html as a result. In the case that you search in the database with the first id save in the array and…
-
0
votes0
answers148
viewsHow to get the sum of a Bigdecimal column
I need to add a data column BigDecimal Mysql, which has already been filtered from a given range. I am trying with SELECT SUM(preco_total) FROM venda; in the code below, but I’m not getting results.…
-
0
votes3
answers70
viewsSQL with two different information
I have two queries in the database that work independently, but now the need to join them in a single script. I made some attempts, but without success. Who can help me, I would very much…
-
0
votes2
answers183
viewsHow to redirect user after login according to user level?
in the system there are 2 user levels 1 = admin and 2 = helper, and after logging in need redirect each to a different page. This is my php code <?php session_start(); include('conexao.php'); if…
-
0
votes2
answers201
viewsReturn an "error" message if the mysql query returns empty
Guys I’m starting now in PHP, and I wanted a little help, I need a page to return a message saying that the bank is empty, but I’m not getting, here’s my code: </head> <body> <table…
-
0
votes1
answer151
viewsI need to take data from the database and display in JSON but gives error
I am using SLIM PHP to develop an API. The class that takes information from the database to display in JSON does not work! I access this local host, which I created: api/communications/general The…
-
0
votes1
answer647
viewsPHP/Mysql Undefined variable in code
I’m trying to run this php code, but it reports me an error "Notice: Undefined variable: num_row in C: wamp64 www balance login.php on line 63" The variable was created on line 23 but it still…
-
0
votes1
answer63
viewsHow to change the color of 1 string
Hello, so I want to do 1 player rank on my site, and I put the position of each player there, but it has 1 however, each position has its color, and in mysql is only the title name, as I do for it…
-
0
votes0
answers41
viewsChecking array value and adding corresponding css class
I am developing an odontogram and in the registration form which tooth or teeth will be made the treatment. These choices are recorded in a column and a flag 0 in another column relating that that…
-
0
votes1
answer6535
viewsHow to use line break in the PHP variable that will be stored in a database table?
My question is the following, I have a field in a MYSQL table that stores data and this data is displayed to the user. This data is entered by users, however, users can also add information in this…
-
0
votes1
answer33
viewsSelect help in two columns
I have the following select command: SELECT pa_coduni, pa_proc_id, sum(case when substr(pa_cmp, 1, 4) = 2017 then pa_qtdapr else 0 end) a2017, sum(case when substr(pa_cmp, 1, 4) = 2018 then…
-
0
votes1
answer158
viewsHelp with COUNT mysql and Asp Net Core
In my system I have a form for opening calls, in which each call has the following status: Aberto, Agendado, Em Atendimento and Finalizado. I would like to exhibit in home the amount of each one…
-
0
votes1
answer36
viewsCreate new "panel" dynamically with php and mysql
I am developing a hotel system and I want to represent each apartment registered in the system with a panel containing information, that is, for each apartment the system generates a new panel that…
-
0
votes1
answer1120
viewsConfigure Mysql Tiimezone in Spring Boot
PROBLEM How do I set up Mysql Timezone in a project using Spring Boot with Tomcat? ERROR java.sql.SQLException: The server time zone value 'Hora oficial do Brasil' is unrecognized or represents more…
-
0
votes1
answer53
viewsVerifies Registered User
I’m using this topic as an example of implementation. /a/76694 It works, gives me the message that there is already a registered email, BUT if I click register it registers anyway, ignoring the…
-
0
votes0
answers87
viewsINSERT taking SELECT from two tables with WHERE - MYSQL
Hello! Follow my Insert and below I explain what is happening: INSERT INTO tab_relatorio_ext SELECT t1.CODIGO_EXT, t1.TIPO_EXT, t2.NOME_SITUACAO_EXT FROM Tab_Coletados_Ext as t1 JOIN…