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
-
-1
votes1
answer121
viewsSum query
I’m having some kind of problem with this query, but what I want to happen is for all values like: Goals Scored, Assists Made,Key passes etc, to make sum for each Player ID making them appear only…
-
-1
votes3
answers208
viewsWriting to Mysql with PHP
I want to record this data more than once but I can’t. I have 10 items each of them with $position,$track,$Artist,$Recorder coming from the form. I can record the first time, then I try to record…
-
-1
votes1
answer150
viewsModal with Iframe
I have a login screen, after logging in, the content I have opens in modals, and when clicking on them (open by iframe), you lose the login session... How to solve this problem?…
-
-1
votes1
answer654
viewsAdd data to a database via a link
I did a quick search but did not find, so I’m posting here. Well, here’s the thing, I want when the person click one link (in the case <a href=.......>inserir</a>) execute the following…
-
-1
votes1
answer578
viewsInsert MYSQL into Web form C# - I cannot insert anything
I’m trying to get an insight into my comics of a college app I’m developing. However, I’m having difficulties. Taking the values of the texbox protected void button1_cad_cliente(object sender,…
-
-1
votes1
answer146
viewsDistinct values
SELECT `forma`,`id_produto`,`id_lanche`,`qtd_max`, if(`id_lanche` in (select `id_lanche` from `produtos` where `id_lanche` = {$id_produto}),'checked','') as marca FROM `formas` db product = products…
-
-1
votes1
answer89
viewsHow to fix insert error in table genres?
How can I fix the code below? It takes the spaces between the commas of the genres or if I have these genres "action, adventure, romance" it puts so "action, adventure, romance" right? Only if I do…
-
-1
votes1
answer88
viewsHow to change alphabetic and numerical pager?
How can I change this code so that it works as follows: in case it puts the initial letters of each item added in $aInitials there if click it filters listing all items with that initial letter with…
-
-1
votes1
answer246
viewsIs it feasible to use Mysql with Entity Framework 6 and get good CRUD performance?
It is feasible to use Mysql with Entity Framework 6 and get good CRUD performance?
-
-1
votes1
answer466
viewsHow to search all the records in the database?
Help me out, guys!!! $BuscaProdutosAtivos = $pdo->prepare("SELECT * FROM tbl_produtos p INNER JOIN tbl_categorias c ON c.cat_id = p.prod_categoria INNER JOIN tbl_variacoes v ON v.cod_prod = p.id…
-
-1
votes1
answer77
views"You have an error in your SQL sintax"
I’m getting this error while accessing the page: You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for the right syntax to use near '' at line 1…
-
-1
votes2
answers651
viewsLicensing of Mysql
I’m starting to develop a system that will run on Android, Web and Windows. The 3 versions should talk to each other and the three versions will have the same functions will be a port of the same…
-
-1
votes4
answers765
viewsHow to put a DB column loop inside an array?
I have a database with dynamic columns that can appear one time, another time not... can also be added more columns or even extracted the ones that already exist. I made a code that allows me to…
-
-1
votes2
answers102
viewsSearch in related table
I have a search script that scans up to three fields of a table called products, now I need to do a search in a table called brand, the product table has the id_brand that relates to the brand…
-
-1
votes1
answer27
viewsSelect in items that have not been inserted
Next, I have table entries in case list of requests to rent a dvd The Tabelab will be inserted which dvd I will rent, so I need to select the list of dvds that were not rented in Table or just bring…
mysqlasked 9 years, 10 months ago Carlos Leandro Ferreira de Alm 339 -
-1
votes1
answer40
viewsMysql and PHP Base
On a Dropbox-style web system (but not for storage), where the user logs in and is already redirected to his HOME (Home), where he has access to its resources. Some idea of how to work this…
-
-1
votes1
answer325
viewsInsert mysql query into a variable
Personal I am making a code to send email via phpmiler the problems is in how to generate an html as body of the email containing variables. Type Tipo arquivo html.php $variavel = " <html>...…
-
-1
votes1
answer338
viewsVarios Count in a Mysql sql
I have 2 tables, one called and another client, I need to return how many calls the client had in the current month, last month and last month, tried using Union, he returned me normally, but, I can…
-
-1
votes1
answer260
viewsRelationship of tables using FK’s
I am making a system that the user create an account and select the movies he has already watched. I have a table in Mysql movies to register all the movies on the site and a generous table that is…
-
-1
votes2
answers307
viewspass php value to js giving error
<!DOCTYPE html> <html> <head> <style> table { width: 100%; border-collapse: collapse; } table, td, th { border: 1px solid black; padding: 5px; } th {text-align: left;}…
-
-1
votes2
answers1112
viewsHow to select all columns of a row?
It is possible to select all columns of a row? I have a function where, on the screen where the user will be created, a validation is made in the first field typed to verify if the ID user I am…
-
-1
votes2
answers697
viewsDo SQL query in 3 tables and return the value to another table?
I have 3 tables ( A, B, C ) with column descricao (with different records between them). I want to do the SELECT of the three tables and send the result to another table D. It would be something…
mysqlasked 9 years, 6 months ago david silva 17 -
-1
votes1
answer376
viewsHow to block login on 2 devices?
I am developing a PHP application where the user can stay logged in even after signing out, using cookies. However, the user cannot stay connected to 2 devices simultaneously. More specifically,…
-
-1
votes1
answer1674
viewsAvoid date and time duplicity for the same scheduling professional
Friends I’m trying to create an agenda for a dental clinic, but I’m having a hard time preventing the client from scheduling a date and time that has already been scheduled for that selected…
-
-1
votes1
answer32
viewsImplementing a system on the server
I have to install a java application whose database is on the server. However I have doubts about the process, through searches, I conclude that I only have to install Mysql on the server, and in…
mysqlasked 9 years, 4 months ago Prostetnic Vogon Jeltz 408 -
-1
votes2
answers585
viewsSaving in the database
I need to save a form in the bank, with several fields input. Someone has an example of how to pass the fields. I am using the framework Angularjs (If I need to turn them into one array or use json…
-
-1
votes1
answer54
viewsProblem to run project
I can’t run my project from the bug "com.android.ide.common.process.Processexception: org.gradle.process.internal.Execexception: Process 'command 'C: Program Files Java jdk1.7.0_79 bin java.exe''…
-
-1
votes1
answer2460
viewsFunction in Mysql for sending EMAIL
I want to shoot some email to some clients I have registered in a table, I did not want to develop an application to run this task, I would like to do directly in the data group, is it possible to…
-
-1
votes3
answers141
viewsQuery problem - Accentuation
My Mysql database is in UTF-8, pages in UTF-8, so far all working. No problem with charset. The problem is when I research something (company) in the search, for example: I type "A" and it returns…
-
-1
votes1
answer401
viewsDisplay only landline and mobile phones with type 9 in front
Following I have a table called telefonia_numero and within it is a field called Numero where contains all user phone. Ex . Jose - Number 81 3636-1145, 81 99873-7787 and 9873-7787, Here comes what I…
-
-1
votes1
answer43
viewsAccentuation error database Data Collection
Well, I have a query that takes data from a database table and stores it in an array, however, the data in the database has accents. When I go to print on the screen the data with <?php echo…
-
-1
votes1
answer75
viewsDynamicreports chart: comparing sales by years
In the graphic shown in the image I show the sales values of some products. What I wanted now was to create a chart that showed the same information but comparing the sales of these products in…
-
-1
votes1
answer78
viewsmysql_query() does not execute
I am trying to test if my database has connected correctly from a query, but apparently mysql_query() does not execute and changes my table. This is my code: <?php //conecta a base de dados $dbc…
-
-1
votes1
answer194
viewsquestions on category and subcategory
good afternoon I created a product category system in the store I am riding on it I have a page that calls for get the categories but I have a problem I have more than one category per product and I…
-
-1
votes2
answers672
viewsCan I use IF inside FROM in Mysql?
It would be possible to do IF within the FROM? I looked but couldn’t find anything about it. Follow an example of what I want to do: SELECT usuario.* FROM ( SELECT IF( (SELECT COUNT(*) FROM pessoa)…
-
-1
votes2
answers239
viewsMultiple assignment in Mysql
How to assign multiple values to a table attribute in Mysql? For example a table where a customer can have multiple phones, and in the assignment can be passed the various customer phones at once.…
-
-1
votes2
answers2784
viewsHow to concatenate PHP variable with Mysql column?"
I have the following appointment: function retornaClientesDevedores ($mesReferencia, $dias) { require_once "PhpUtil.php"; $PhpUtil = new PhpUtil(); $string = "SELECT idClientes, nome FROM clientes…
-
-1
votes2
answers124
viewsPassing variable values in ASP.NET and Mysql
Hello, I’m developing a page in Asp.net and I’m having trouble passing values from a Mysql SELECT to variables. I don’t know where to start and would appreciate examples of how to do.
-
-1
votes4
answers676
viewsHow to make a Select from two 1-N tables and return only one record from the second?
I’m having difficulty creating a select that searches data in two tables, follows the description: Tabela produto ( id_produto, nome_produto, preco, categoria ) Tabela imagem ( id_imagem,…
mysqlasked 8 years, 8 months ago Alexandre Galvão Alves 19 -
-1
votes1
answer1475
viewsGet last id inserted in mysql with php
I have the following listing query mysqli_query($conexao,"INSERT into cadastro set nome='$nome',telefone='$fone',cep='$cep',secao='$categoria'"); how do I not have to select the last input to get…
-
-1
votes1
answer77
viewsCheck box of the database with mysql and php
How to automatically create check box with data coming from a database table?
-
-1
votes2
answers3379
viewsMysqli INSERT INTO Does not work
I have a code that inserts records into the database, it is not displaying any error, it is simply not sending the data to the database the code worked previously only that as mysql_* became…
-
-1
votes1
answer392
views -
-1
votes1
answer952
viewsError - mysqli_num_rows
Hello I want to check the number of records in the bank and display on the screen the amount of records, but it’s not working, which may be wrong ? <?php include '../include/connection.php';…
-
-1
votes1
answer559
viewsError 403 - Password validation forbidden access with Mysql in PHP7 code, how to fix?
Good afternoon guys, I am taking a course of a real estate portal system in PHP that I bought and I I stopped at the time to make the portal login system. The course uses PHP below version 5 and the…
-
-1
votes2
answers58
viewsHow do apps validate login on a remote server?
Let’s assume that I have a website with a Mysql database with log-in logs, so a desktop or mobile app would need information like host, root and password to remotely validate a form, but that…
-
-1
votes1
answer148
viewsMysql x Mongodb - Examples of Apps
Cite examples of applications, sites that would be best suited to use Mysql (or any other SGDB) or Mongodb. And the reason why? 'Cause I still can’t see scenarios where Mongodb is better..…
-
-1
votes1
answer54
viewsHow to execute query at the turn of the day?
I wonder if there’s any trigger or process that I can at the turn of the day 00:00 change the status of installments that have their respective maturity dates greater than hoje(). Any suggestions?…
mysqlasked 8 years, 4 months ago Rodrigo Cunegundes 11 -
-1
votes2
answers212
viewsComparison between decimal numbers
I have 2 posts on a table, with prices 500,00 and 88,98. When I run to sort according to the highest price, Mysql returns me that 88.98 is higher than 500.00, the "price" field is a string, because…
-
-1
votes4
answers582
viewsHow do I SELECT then INSERT
How do I select and return more than 1 record does the UPDATE and return 0 records does the INSERT ? Look how I did it here only it’s not working: if(isset($_POST['submit'])){ $query =…