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
votes3
answers1024
viewsTake comma-separated values from the database and organize them into <li>
I have in my database, inside my table "db_home_content" the column "a2_content_x_imploders" ("x" would be the respective content number, as represented in the image) that contains some data…
-
-1
votes1
answer19
viewsReturn of values from a column of table X that has 1 code in common
I need to solve a big problem. I have a table of answers of a poll where the answers made with checkboxes are in different lines with a common code, that of the answered question, example:…
-
-1
votes1
answer151
viewsERROR: Incorrect function
I developed a portal and it works properly on the localhost, but when I went to put it on the air, the connection to the bank stopped working. So when trying to make the connection with the bank it…
-
-1
votes1
answer55
viewsProblem with Database Connection
Could you help me figure out why you’re making this mistake? Code: using (_connection = new MySqlConnection("Database=test;Data Source=localhost;User Id=root;Password=teste;SslMode=None;")) {…
-
-1
votes2
answers138
viewsdoubt with select sum() Mysql
I have these two tables, January and February: each field corresponds to the day of the month, D1= day 01, etc. I need to create a select that shows the monthly value of each account plan, example:…
-
-1
votes1
answer64
viewsInsert GET mode
Good morning, This is the form of a question form of mine: <form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET"> <fieldset>…
-
-1
votes1
answer155
viewsI want to add all the points of all teachers and create a rank with the top 3
I would like to sum up the points of all teachers' classes and create a rank with the 3 largest. My problem is creating QUERY SQL to return the data to my system. Here’s a picture of my bank.…
mysqlasked 8 years ago Diego Silva 13 -
-1
votes2
answers543
viewsAssign value to SQL variable
How do I make one select which assigns the value "10" in all of the games column? Note: Without giving update on the table. /*minha_tabela*/ codigo jogos --------------------- 1 10 2 10 3 10 4 10 5…
-
-1
votes1
answer795
viewsList data only for a given ID
I made a small system where the administrator "sends" documents to a particular user, where it sends the info to a BD and generates a folder with the user ID. In the image below is the BD…
-
-1
votes1
answer381
views -
-1
votes1
answer130
viewsUsing LIKE in Mysql
I am trying to run an SQL with LIKE in Mysql without success, with some search I realized that Mysql only accepts like after a Where, but in my search there is no need for Where, because I’m looking…
-
-1
votes3
answers795
viewsHow to do a query that only refers to the DIA of a date?
I have a MYSQL bank and I need an SQL that refers to the PAYMENT DAY in the DAY field (this field will only have the DAY of the month that the client chose to make the payment, this field is of the…
-
-1
votes1
answer48
viewsHow to have more than one value for another table?
Good people, I come with a doubt that has been chasing me for a long time. Let’s get to it: I have the table X however values of table X I picked up at table Y. How to store more than one value in…
-
-1
votes1
answer47
viewsJava arithmetic operations with database data
What is the best way to calculate values in java? I need to make a method that returns the sum of all inputs and output and subtraction. Example: Insert all Double entries in column X, and all…
-
-1
votes1
answer2612
viewsInsert file path in mysql
I need to insert a file .pdf by page and write in the database only the file path. The user uploads and writes. The file goes to folder specifies and the Mysql database only gets the path. Follows…
-
-1
votes1
answer53
viewsDynamicreports Dynamic Graphics Generation
Hi, I made some reports with the DynamicReports http://www.dynamicreports.org/, when searching about how to make graphs I found several examples, but none with the data (shown in the graph) being…
-
-1
votes1
answer607
viewsHow to save the full HTML of a form to Mysql?
I’m trying to record the full HTML of a form. Since I have a system in which each user can have his or her individual form of payment, which requires that each one record the code of the buy button…
-
-1
votes1
answer46
viewsHow do I pick a line from a field that has no bounds and break into an array?
I have the code that takes a string from a field in the example below: material plant part flow light This string has no delimitations and on top of that, as you can see, the words of the string I…
-
-1
votes1
answer43
viewsHow to check day of the week being 1,3,5
Galley, I have a field in my table that keeps the day of the month, example But in this very field I’m recording the information like this: 1,2,3,5,22 Today is day 22 DAY( NOW( ) = 22 See that in my…
-
-1
votes1
answer33
viewsSql calculates date instead of inserting
I’m trying to insert date in my BD but sql calculates the result is always 1997 in the fields I tested as "date" and did not insert "varchar e text" resulted in a subtraction calculation of the…
-
-1
votes1
answer123
viewsMysql syntax error
I am making a form to insert data in my database but the function that does this is returning me a syntax error that I cannot find. Function function insereProduto($conexao, $nome, $descricao,…
-
-1
votes1
answer70
viewsforeach returning non-existent empty data
I have the following form: <form class="form-horizontal" action="perguntas.php" method="GET"> <fieldset> <?php $StringPerguntaLoja = "SELECT * FROM sug_pergunta_fixa AS p inner join…
-
-1
votes1
answer318
viewsHow to give permission to write temporary files in the c windows tmp folder with Laravel 5.4?
I would like you to help me solve this problem: How to give permission to write temporary files in the windows tmp c folder with Laravel 5.4?
-
-1
votes1
answer51
viewsSelect with most messaging users
I’m making a system and I have to know which user sent the most messages. My tables are more or less like this: User id|nome|sobrenome|email| ... Messages id|uid|nome|email|assunto|msg| ... I just…
-
-1
votes1
answer1390
viewsHow to leave a mysql database online?
I have a database on my computer, but I need to share it with other people. I’m using the Mysql database, and I need to access this database off the network, on other devices. How to leave this…
-
-1
votes1
answer7655
viewsString replace with single quotes - php/mysql
Hello! I’m doing an Insert/update in a database through a csv file. I have problems when I try to upload the file and it finds data with simple quotes, for example: "SANTA BARBARA D'OESTE". My…
-
-1
votes1
answer220
viewscannot connect with mysql on the web server
You are showing the following error: Fatal error: Uncaught Exception 'Pdoexception' with message 'SQLSTATE[HY000] [2003] Can’t connect to Mysql server on 'Ipservidorweb' (111)' in…
-
-1
votes1
answer102
viewsperformance in a select query
For DBMS what is faster to receive all the fields specified or use the character * which represents all fields. If there is a difference, why? Select coluna1,coluna2,coluna3, .....,colunaN from Or…
-
-1
votes1
answer289
viewsSynchronize the server database with a localhost
I need to synchronize two databases so that the information of both are equal due to problems of instability of the internet. researching found the replication that exists in phpmyadmin, but as I…
-
-1
votes1
answer57
viewsI am creating a school system, I want together a list of linked teachers and materials Database (Mysql)
I am creating a school system, I want to add a list of teachers linked to materials and virse and versa. I use the Mysql database Example: Professor 1 - Materia 1 Professor 1 - Materia 2 Professor 1…
-
-1
votes1
answer765
viewsUpdate in two MYSQL tables
How to update two tables, e.g.: first table users, would update only on senha, but on the table users_info would update cos fields, cidade, nascimento, sexo and etc. I can do it in one, but I wanted…
-
-1
votes2
answers46
viewsError using Inner Join in MYSQL
I’m using the INNER JOIN mysql to merge and display data. Tables and data insertion: CREATE TABLE EXPERIENCIA( exp_pri INT NOT NULL AUTO_INCREMENT, experiencia VARCHAR(100), PRIMARY KEY(exp_pri) );…
-
-1
votes1
answer416
viewsJOIN 3 tables +1 JDBC junction table
I have a program in java that returns the list of users who have an appointment that day, for this I built a database that related some important data of the users, the name of the doctor with whom…
-
-1
votes2
answers456
viewsMysql query with PHP brings duplicate results
I’m trying to create a code in php to build a ranking, I managed to make the data appear, the problem is that is duplicating the results. $rank = mysql_query("SELECT * FROM user_quizzes ORDER BY…
-
-1
votes2
answers1770
viewsINSERT PHP MYSQL does not insert
I have a simple problem with INSERT in the PHP with MYSQL , happens that it does not insert anything in the database , already put to report the errors but does not work , I’m using vertrigo server…
-
-1
votes1
answer583
viewsHow to update to table with Foreign key
I have table discipline and table teacher. The teacher contains discipline. How do I change the name of the discipline and automatically change in the teachers? I’m a little confused about using On…
-
-1
votes2
answers1139
viewsPHP - Create a checkbox list dynamically
I have the following code, where I select categories from a MYSQL table. <?php include 'conect.php'; // array que conterá as categorias $cats = array(); $sql = "SELECT id_carac, nome_carac FROM…
-
-1
votes1
answer133
viewsUndefined index array Pdo
good people I’m trying to get the id of a user who logged in and saved in the session but , not working, I make a query in the bank when logging in and turn the result into an array to pick up the…
-
-1
votes1
answer46
viewsHow to show that the user is logged in to the pages he visits?
How do I make the after the user logs in, that he can see in some corner of the screen his name with some information from him with that login and that when he presses the "back" or "exit" button a…
-
-1
votes1
answer110
viewsQuery to join specific tables
I need to put together three different tables. But the result I want is: When there is the reference it must join, when there must be no blank or NULL. My structure: Table contact…
-
-1
votes1
answer423
viewsHow to auto-dump in Mysql?
I have a simple system for managing a store that for now, in the testing phase, is running with local server. I wanted to know a way to do the dump Mysql database automatically at the same time…
-
-1
votes1
answer12
viewsGrab all the product tables and move in just one
Like I have the products bank and the tables,?
-
-1
votes1
answer531
viewsAndroid Application and Mysql Database
I have an application developed on Android and need to connect to a Mysql database that is local on a Desktop. I can easily get the IP address of the machine where the bank is. How can I connect the…
-
-1
votes1
answer492
viewsProblems with phpMyAdmin Uolhost
I have a site on Uol host and a database too, the site communicates perfectly with mysql, but I have a desktop software that I need to communicate with mysql as well, Is there any configuration I…
-
-1
votes1
answer59
viewsPHP update undefine
I can’t update the database php faults. <?php if($_SESSION['MM_Username']=="Comandante"){ if(isset($_POST['estadoComando'])){ updater($_POST['estadoComando'],$_POST['id']); //<-- linha 213 }…
-
-1
votes2
answers155
viewsCreate PHP form using recovered result of an SQL query
I need to send what was entered in the input field and send by the POST method. My code is like this: <?php include_once("../controle/conexao.php"); //Recuperar o valor da palavra $usuarios =…
-
-1
votes1
answer338
viewsConnect Visual Studio to database
Hello, I am trying to connect my project in Visual Basic, in Visual Studio, with my Mysql database, it presents the error below, would anyone tell me how to solve this problem? I already installed…
-
-1
votes2
answers2237
viewsPHP insert a data array into a mysql table
I have an array in php that contains some data, example: Array ( [nome] => Nome [sobrenome] => Sobrenome [genero] => 1 [email] => [email protected] ) And I would like to insert this data…
-
-1
votes1
answer1695
viewsXampp MYSQL does not work
The following error is happening with my mysql. MySQL Service detected with wrong path Change XAMPP MySQL and Control Panel settings or Uninstall/disable the other service manually first Found Path:…
-
-1
votes2
answers79
viewsWhen giving the result of a query, this inserting only the first line
I am bringing a query from one bank and I will insert in another,this running the question and that is only inserting the first line and not all the results,see my script below: <?php…