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
votes2
answers34
viewsAdjust query sql according to available discipline
I have this query, working well, but it only works if I have data for the two disciplines PORTUGUES and MATEMATICA, how can I do so that, without harming the result, regardless of there being only…
mysqlasked 6 years, 7 months ago Miguel Silva 491 -
0
votes1
answer100
viewsChange the order of a result in PHP WHILE from Mysql
I am with the following difficulty, in a table are stored records of product categories, I made the connection mysqli, SELECT and WHILE, and everything is fine so far, but what I’m having difficulty…
-
0
votes0
answers710
viewsSelect on one server, Insert on another
I use the following query to select data from one database and insert into another: insert into banco_novo.cliente (codcliente, nome, cpf, rg, sexo, data_nascimento, endereco, bairro, cidade,…
mysqlasked 6 years, 7 months ago Pedro Augusto 2,392 -
0
votes0
answers83
viewsInitial SQL to list clients (PF and PJ). How to migrate a pure SQL Query to Laravel Eloquent?
I set up an initial SQL to pull the data. It’s working in pure SQL. I need to migrate this code to Laravel’s eloquent pattern. Can anyone help me? Thank you! Follow the example SQL: Code: SELECT…
-
0
votes1
answer276
viewsHelp in Mysql Phpmyadmin How to insert a table in a database?
How do I insert a table into a abanco ? I am a beginner mysql user and beginner in the world of programming. I made the following code: INSERT INTO banco1( CREATE TABLE Cliente ( id INT NOT NULL…
-
0
votes0
answers96
viewsMysql query does not return data even if records exist
I’m trying to make an appointment with mine BD but strangely returns nothing, even existing records with the given parameters, yes, the script still uses the mysql_And I’m changing it, but I’d like…
-
0
votes1
answer21
viewsHow to pull the Option value from the select HTML property that is saved in MYSQL
How do I change and be saved in the database, once I update the saved value is filled in the box, the way I am doing saved in the bank, but when updating the page it always leaves the box filled…
-
0
votes1
answer349
viewsPHP - Receiving the ID of a value via select option $_POST
Good afternoon guys, I’m developing a code. I need to get a value to register it as fkid of a table. I have that part of the code: <td><h3>Vincular Conteudo</h3></td> <td…
-
0
votes1
answer54
viewsError while doing select
Warning: mysqli_fetch_assoc() expects Parameter 1 to be mysqli_result, Boolean Given I already tested the fetch_array, fetch_object, I don’t know how to do it. function pegaId($nomeConteudo){ $query…
-
0
votes2
answers42
viewsQuery problem using SQL in PHP
I have the following code: $nomeConteudo = $_POST['tipoConteudo']; echo $nomeConteudo; $id = $conteudo_fkid->cataId($nomeConteudo); echo $id; In it, the variable methodName receives the value of…
-
0
votes0
answers52
viewsSearch first empty space in database
I have a small application in C#, which creates the automatic supplier code. I wonder if anyone knows any way of the system to search for an empty code, ex: 1 - Manoel 2 - Daffodil 4 - Mustela The…
-
0
votes1
answer44
viewsAttribute for $_POST loses information
I have an attribute called $nomeConteudo, that makes a select in my database and returns the value correctly, because through echo I confirm that the value is normal. Within a form, I need to send…
-
0
votes4
answers169
viewsI can’t convert seconds into minutes
I’m doing the following query: SELECT SEC_TO_TIME(sum(Total_Segundos_Consumidos)/count(distinct IDTRANSACTIONS)) AS `Tempo Médio` FROM (SELECT IDTRANSACTIONS,…
mysqlasked 6 years, 7 months ago Layla Comparin 553 -
0
votes1
answer28
viewsAdd open plots with Join
I have two tables, Cliente and Parcela. The table Parcela owns the id do cliente as foreign key, a column pagamento that is null or contains the payment date in format date and a column valor that…
-
0
votes1
answer266
viewsmysql execution error - XAMPP
I’m trying to create a localhost with the shaman, but the Mysql does not start. Gives this log mysql_error.log: 2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is…
-
0
votes0
answers385
viewsHow to take modal bootstrap data and send it to PHP
I need to get the data from the Modal form via Ajax My code: var url = 'fotovisita.php'; var data = $('#foto').serialize(); var type = "POST"; $(document).on('click', '#save-foto', function () {…
-
0
votes1
answer20
viewsWhen adding user, it always gives ERROR but ends up adding
Good people, I have a problem that is the following: in a form to add the user I fill everything and add the user but appears the message to say: ERROR:"Try Again". How is it possible to add the…
-
0
votes1
answer171
viewsCombobox with Mysql
I am not able to take the data from the unit table and put it in a combobox. The combobox does not work and appears to subanswer. I have a table called "tblutentes" with the name of the user and…
-
0
votes0
answers28
viewsHow to use PDO and PHP to Show in Table Query Data
I have a question. I do not understand why my code is not correct. Please, if you can review it, I would be very happy. <?php require_once "db_connect.php"; //conectar banco $conectar = new…
-
0
votes1
answer60
viewsBring multiple values from a Join in mysql
Guys, I have a question about a mysql query using the Codeigniter Framework. I have the following tables: Table Products |--------|-----------------| | id | nome_produto |…
-
0
votes1
answer114
viewsSort query by Mysqli relevance
how the query below could be ordered by relevance and then by date? $query = $mysqli->prepare( "SELECT `id`, `titulo`, `foto`, `descricao`, `slug`, `data`, '' as `local` FROM `noticias` WHERE…
-
0
votes0
answers283
viewsphp - How to set maximum run time using interval on each loop?
Good morning! I need to send some email reminders according to some conditions. I built a script that queries the information in the database (Mysql) and triggers the emails. The script is working…
-
0
votes0
answers1129
viewsError 500 after deploying Laravel application using Mysql on Google Cloud Platform
I have an Laravel application using Mysql 5.7: https://github.com/01viniciusmelo/app-login-laravel In my local environment is working perfectly. I followed this tutorial, but the result is an error…
-
0
votes1
answer251
viewsHow do I use Jenkins to see which files were modified in the commit?
I am working with PHP and Mysql on Windows, my repository is in Gitlab. I wish to use Jenkins to run a job or pipeline when pushing to the repository. The job should check the changed files in the…
-
0
votes1
answer26
viewsBest method for categories via php and mysql
I am creating a system with php + mysql. It is a type of social network. I am in the planning part of the database and with a doubt on the best way to record, for example, the skills of the…
-
0
votes1
answer394
viewsProblem with autocomplete
Good evening, I’m trying to do an input with auto complete per query in mysql database, but I’m having problems. I did all the code following a tutorial and still will not, nor errors appear to me.…
-
0
votes0
answers83
viewsPassing a string created in Windows Forms to Crystal Report
I needed to add a string created in Windows Forms Application in the Parameter Fields, shown in the first image below, inside the Crystal Report to later make a filter, as in the second image below.…
-
0
votes0
answers189
viewsHow to display the result of a search in mysql where returns more than 10mil result without crashing the browser?
I am currently using the table jquery to display the results, but it takes a long time to display all the results and while the search is not finished the browser sometimes hangs. has some better…
-
0
votes4
answers247
viewsHow do I enter this into the database through the form?
Hello, I’m having trouble connecting to the database. The following error is appearing: Fatal error: Uncaught Error: Call to Undefined Function msqli_query() in C: xampp htdocs Data clients.php:15…
-
0
votes1
answer72
viewsShow mysql database data in a php/html page
I have a problem showing data from a database table on the screen. I was able to show the data but I can’t jump the line, show the data sequentially, code below. $sql = $connection->query("Select…
-
0
votes0
answers82
viewsSave loop for data to database
Good morning I am developing a financial part where I fill out a certain form which is due date, full amount, discounted value, school year, percentage of the discount and amount of portion however…
-
0
votes1
answer119
viewsCreate query in query Builder - Standard
I’m starting to work with Laravel and need to make a query in the database, is a simple query, but as I’m starting I do not know yet perform it. I need to get the sales done today, yesterday, this…
-
0
votes2
answers208
viewsQuote problem in query syntax in Mysql
I have a class, and within this class, I have a function to update a data in the Mysql database. Follow the function: public function set_detail($id, $detail, $value) { $query = "UPDATE `contacts`…
-
0
votes2
answers164
viewsShow Json + Mysql + PHP Value
I need to do this, but coming from the database.... I don’t know how to do it... function decodificar($id) { if ($id == '1') { return json_encode( array( 'id' => '1', 'desc' => 'descricao do…
-
0
votes0
answers47
viewsConnection Limit, Slow Query (MYSQL)
I performed a select to return me about 70k lines, everything was working perfectly until I add the function "group_concat()", after adding this function the query enters timeout and can not return…
mysqlasked 6 years, 7 months ago Gabriel Castro 46 -
0
votes0
answers81
viewsHow to call a foreign key?
Guys I have a platform that has a page to add person and another page has to add a plan to a person. That is, first creates a person, and only then is it possible to add a plan. My problem is…
-
0
votes1
answer34
viewsSelect with Join alternative MYSQL
Table - log_tables_restaurants id | id_restaurant | id_admin | id_user | action 1 | 10 | 2 | NULL | adicionou 2 mesas 2 | 11 | 3 | NULL | removeu 2 mesas 3 | 20 | NULL | 30 | adicionou 10 mesas I…
mysqlasked 6 years, 7 months ago Daywison Ferreira Leal 101 -
0
votes1
answer33
viewsDoubt with Insert and Select
I’m new around here and I’m having a database doubt that I’m stuck since yesterday, tried to solve and nothing, follows the next exercise: Com a Tabela de Clientes (id_cliente, nm_cliente,…
mysqlasked 6 years, 7 months ago accquaviva 41 -
0
votes1
answer20
viewsSelect Indicator, Indicated and Indicated
All right, y'all. I have a table in Mysql in which each record has the member’s CPF and the indicator’s CPF (who indicated it). I’m trying to select both the nominee and your indicators. For…
mysqlasked 6 years, 7 months ago Jhonatan Pereira 537 -
0
votes1
answer232
viewsReturn a Result set from a Mysql storeProcedure
Good afternoon. I have the following storedprocedure in Mysql..: DELIMITER $$ CREATE DEFINER=`ricardo`@`%` PROCEDURE `teste2`() BEGIN Select * from Tabela; END As I call this storedprocedure by…
-
0
votes1
answer123
viewsHow to use URL friendly?
I’m doing my TCC and the theme is SEO, to complete need to put URL friendly since the current link is like this: php post? id=79 Well, I looked into it. htaccess and managed to make the main pages…
-
0
votes0
answers104
views -
0
votes1
answer29
viewscode Smell - select max(numeroProntuario)+1, but how to fix it?
I have a table Paciente mysql, in it I have the column id, nome, numeroProntuario etc. This column numeroProntuario is defined by the increment of +1 resulting from select max(numeroProntuario)…
-
0
votes0
answers30
viewsHow to put a Count inside a box
i wanted to put a time counter ( ex: a promotion of 10% for a certain time) would be able to do this with mysql ? Could someone give me a hand on how to start doing that? ( how to put Count inside…
-
0
votes1
answer51
viewsAdd access level to this php code
<?PHP include('config.php'); # Validar os dados do usuário function anti_sql_injection($string) { include('config.php'); $string = stripslashes($string); $string = strip_tags($string); $string =…
-
0
votes0
answers104
viewsMy HTTP(GET) request is not running on ngOnInit() - Angular 6
I have a CRUD at Angular 6 that connects to Node and mysql. When I access the homepage the getQuotes() function loads all the data I need. When I access the screen to update a record and perform…
-
0
votes1
answer64
viewsPHP sends partial data to mysql
opa ! I am learning to use the trio html+php+mysql and the business is giving me a ball. when I finally managed to understand the mistakes I was making, I went to the most real test, I made a very…
-
0
votes1
answer67
viewsHelp when logging in login system, disappear the 2 forms
Well I am wanting to leave a login system that after being validated the login when it appears to the page of the login form that it is logged in and not the login form: ex: we log in the same page…
-
0
votes2
answers27
viewsGet an item from each Row
How can I get an Item from each Row? For example, I have a column with the following rows: TEST TEST TESTE2 TESTE2 TESTE3 As I wished: TEST TESTE2 TESTE3 My code: public void carregar(){ qy =…
-
0
votes1
answer35
viewsHow to search a mysql table with two filters?
I have a page where it returns a table from my database, but as this table receives several data I am trying to set up a filter for it, I made a form and from it a filter, follows example: $busca1 =…