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
answers2936
viewsInsert special mysql characters and pull these identical values in the web application
Good evening, I need to add values to the database by mysql so that they have special characters. I can add, but I can’t pull the values correctly, they end up coming with symbols in place of the…
-
0
votes0
answers204
viewsProblem with Mysql and php connection
I’m trying to connect to the database to remove data that is returned with the get_data function: Warning: mysqli_error() expects exactly 1 parameter, 0 given in…
-
0
votes1
answer131
viewsInsert with select from two different places
My code when registering a new user: $sql1 = "INSERT INTO usuario (login, senha_hash, nome, email, direito_deAcesso) VALUES ('{$usuario}', '{$senha_hash}', '{$nome}', '{$email}',…
mysqlasked 8 years, 6 months ago Cesar Augusto 300 -
0
votes1
answer132
viewsSort select by date
How to sort this select by DATE? (SELECT * FROM mensagens WHERE de = '2' && para = '1' ORDER BY data) UNION (SELECT * FROM mensagens WHERE de = '1' && para = '2' ORDER BY data)…
-
0
votes1
answer68
viewsHow to edit registered data so that when selecting the registration to be changed, its data will appear in the same form that was created?
Given the following form: <form action="action_page.php"> <fieldset> <legend>Personal information:</legend> First name:<br> <input type="text" name="firstname"…
-
0
votes1
answer71
viewsPost system - Tips
Hello, I’m looking to create a blog system for my site and I have an initial idea of how to do it, very basic. In basic, I would have one that will send the text of a <textarea> to the…
-
0
votes1
answer59
viewsTags in a table for each?
I have the table "news"and I will make a system of tags, these tags will have to have a table for each or just a table ?
-
0
votes1
answer37
viewsMap tables to save access history
I have an application, in which I need to save at least once on the day, the date and time that user accessed the application/ system. Because we charge at the end of the month for the number of…
-
0
votes1
answer719
viewsExtract and include SQL data with R
I am designing an SQL database that will have tables that store collected data and a table that stores calculated indexes of this data to be later exposed on a Dashboard. I intend to calculate these…
-
0
votes1
answer90
viewsMysql update event
I asked this question yesterday, I got the answer I wanted, I’ll be straight and straight: I have the query: UPDATE users SET time = time - 1 time is the type int and receives as default value 0, in…
-
0
votes1
answer84
views$('#type'). val('juridica');
I am having a big problem in receiving and sending the data to the database because, when creating a system where there is the possibility of using the physical person or legal person, they send to…
-
0
votes1
answer468
viewsHelp with image uploading and viewing with $_SESSION or $_COOKIE
I need to make, that the user changes the image without changing the source file of the Database, that is, when he closes the BROWSER after having made the exchange, he or any other user entering…
-
0
votes1
answer487
viewsSend a value to modal
I have a table with several employees and on it counts the plate of each hum. I created a modal that when the manager clicks on the employee name is called a modal where it is possible to enter the…
-
0
votes1
answer50
viewsHow to solve wrong encoding in xml sheet export
I have a form that receives some of registration and are transmitted to another page via ajax that makes the entry in the database. The problem is that at the time of receiving, if I do not use the…
-
0
votes1
answer32
viewsHow best to update inputs alternately
I have some inputs, however I should only update the fields that have been filled: For example: Logo and Digital Certificate are blank. UPDATE should not occur to these fields. Logo and Password are…
mysqlasked 7 years, 3 months ago lucasbento 856 -
0
votes0
answers45
viewsConnecting several banks with mysql loop
good afternoon My doubt is related to connection to several databases in mysql for reporting I would like the annual result of the year 2016 in sales, so I want to take the result of each month, but…
-
0
votes1
answer71
viewsWhere affecting only one field in select
Good morning, how do I make my Where clause affect only one (1) field in my search? For example: $query = DB::table('proventosdesc as proven') ->join('calculo_rh as calc', 'proven.pessoaId', '=',…
-
0
votes0
answers93
viewsSum of working time of several employees
I have a collaborators table, and other 2 activity tables, each with a column of time used to perform that activity and I would like to add these tables to know the total time, example, employee A…
-
0
votes1
answer124
viewsReturning External Array when Retrieving Data with Laravel
I have a column called clube and in one line she has the following {"clube":["Santos"]}, using this form for the data $clubes = Socios::where('socio', $socio)->select('clube')->get(); He…
-
0
votes1
answer427
viewsHow to handle calendar in database
Hello, I am doing a personal project, to practice programming and I came across a situation that I am struggling to resolve. A user has a routine that repeats weekly, where each day of the week he…
-
0
votes2
answers52
viewsColumn Not Found With Inner Join
Lines: 1 - Data from filter form 2 - That with i enter a Model relationship function. I do this because I need to sort my list by column order MEDIA. 3 - The strange thing is that I need to do an…
-
0
votes1
answer721
viewsMYSQL: ERROR 2027 (HY000): Malformed Packet
I am unable to connect a Mysql server remotely. The connection seems to be ok because with telnet [ip] [port] I get answer: 4.1.3b-beta-nt-max▒@\0v'[uZ,B{efSLa$,Q4N When run by command line or Mysql…
-
0
votes0
answers28
viewsMysql full text does not find underlined results
I’m using the MATCH/AGAINST of mysql to implement a search system, the problem is that, words with underlining (ex: lista_compras_mercado.txt) are interpreted as one, there is some way to turn…
-
0
votes2
answers37
viewsError inserting data into table
Opening Connection: private static final String USUARIO = "root"; private static final String SENHA = "123456"; private static final String URL = "jdbc:mysql://127.0.0.1:3306/escolabd"; private…
-
0
votes0
answers661
viewsI can’t start Mysql on Easyphp
Whenever I use Easyphp I cannot start Mysql and Apache starts normally. What I can do?…
-
0
votes1
answer1061
viewsHow to get LAST_INSERT_ID() from a mysqli_multi_query() function with SET and INSERT?
this is my 'Betting Signup Method' on my betting system. In this way, I register data in two tables, a call BET and another BET_MATCHES, the system is controlled by time, so in all entries I need to…
-
0
votes1
answer588
viewsbackup of specific mysql content data via java
Hello, I have the following method that backs up my database: public static void makeBackup() throws IOException{ String caminho = "C:\\Program Files\\MySQL\\MySQL Workbench 6.3 CE\\mysqldump.exe";…
-
0
votes1
answer62
viewsProblem with mysql
I wonder what I can do for the mysql recognize the "+" character, because it shows in a part of my site the name with the "+" and when I make a request in $_GET I need to recover this name by url…
-
0
votes1
answer111
viewsData comparison
My setting: I took a code from the Internet that parses the Openvpn log and plays it in the database to play it in a table on an html page. The exit is more or less like this:…
-
0
votes1
answer264
viewsSelect command to delete duplicates by summing the results
How to change a table that looks like this: produto | quant a | 10 a | 5 b | 8 b | 3 And leave her like this: produto | quant a | 15 b | 11 Is there any command select that I can use to make this…
-
0
votes4
answers216
viewsCreate links with tags registered in the database
I have a field in the MySQL with the following content: Alesso; Anitta; Billboard; Marshmello; Poo Bear I need to take each of the values separately and create a link like this: <a…
-
0
votes0
answers156
viewsButton loads all instead of filtering by group
I have a problem, where if I press the button to load more blocks through the database, it will load all in the ID order, however if I have in some filter it keeps loading all instead of only that…
-
0
votes1
answer150
viewsBring Records You Don’t Have - 3° Table
Scenario, four tables. TABELA A | TABELA B | TABELA C | TABELA_D ID_A ID_B ID_A ID_B ID_D ID_D DESC 1 10 1 10 1 1 PEÇAS 10 1 2 SERVIÇOS 10 1 3 COMPRA The first table has the PK Id_a. The second…
mysqlasked 8 years, 6 months ago Diego Souza 16,524 -
0
votes2
answers398
viewsLog in with user or email in the same field
Hello! I have a login code but, I can’t get the user to log in with your email or username using the same field! Below follows my code, the email on my base date is named "mail".
-
0
votes1
answer559
viewsIs it possible to connect to a Mysql database without Mysql.Data.dll?
Whenever I will use a Mysql database in a console or windows Forms application, you need to have the dll MySql.Data.dll inside the application folder. With that, I wonder, if you have any way to use…
-
0
votes3
answers170
viewsColumns do not hit insertion
You’re making a mistake Column Count doesn’t match value Count at Row 1…
-
0
votes1
answer63
viewsPrint dynamic query
I have a query in a system where the user selects the month and the corresponding records are shown on the same page. I want to print the result of the query but how the form sends via GET: <form…
-
0
votes1
answer181
viewsMYSQL: Find subsequences in a sequence and group by ID
I have a table with the following result: ------------------ |seq | ID | ------------------ | 1 | 12345 | | 2 | 12345 | | 3 | 12345 | | 4 | 12345 | | 8 | 12345 | | 9 | 54321 | | 10 | 54321 | | 11 |…
-
0
votes1
answer1654
viewsSend null date if not filled in
How do I enter a date null in that capacity? $data_saida = $this->post('data_saida'); //aqui pega a data se não for vazia e formata if($data_saida) { $arraydata = explode("/", $data_saida);…
-
0
votes1
answer814
viewsDelete Cascade with Entity framework
I have the following situation: my database is Mysql, when I try to delete a record directly in the database, from this message: Cannot delete or update a parent row: a foreign key constraint fails…
-
0
votes0
answers178
viewsGrab table id generated by setFetchMode(PDO::FETCH_ASSOC)
Good afternoon friends, I am trying to generate a link sending a parameter that would be the row id of the table clicked <a href="page?id=echo'.rows['id'].'">Editar</a> this code works…
-
0
votes0
answers33
viewsHow to free mysql server for external access?
I hosted a web application using iis on windows server, but need to let the online database other applications access it. How to free mysql server for external access so I can use in other…
-
0
votes1
answer100
viewsAssociate logged-in user with your information?
After doing "Session", how do I bring the logged in user information? i know it’s not just creating a session, I need to bring user information like Name/Nickname, avatar, email etc.
-
0
votes1
answer31
viewsHow to run the same query for different "ids"
I have an array with the following Ids: Array ( [0] => 2 ) Array ( [0] => 3 ) Array ( [0] => 5 ) The query should return all the values found for these Ids, so, how will the assembly of the…
-
0
votes1
answer857
viewsMysql error "Cannot add Foreign key Constraint"
I am starting in SQL language. I have the following error: Table 'linces.controlos' doesn't exist I haven’t found the solution yet, someone can help? Drop Database if Exists Linces; Create Database…
-
0
votes2
answers64
viewsReturn Attribute group of a specific category
I have 3 tables: (http://sqlfiddle.com/#! 9/08b79f) tb_attributes, tb_atr_to_prod, tb_atr_to_cat. Table TB_ATRIBUTOS has all parent and child attributes. The TB_ATR_TO_PROD Table has all attributes…
-
0
votes2
answers1453
viewsCount number of people from a table by age group, gender and company
I’m having a hard time getting one working select where to bring the amount of people who work in a enterprise, banded age, age and sex. I did the example below, but so far I could not make it work,…
-
0
votes2
answers872
viewsDeck of random cards
I am creating a site for people to play cards with php. I would like to know how to create a deck of 50 cards for each person. In the database I have a table with 300 different cards and of these…
-
0
votes1
answer566
viewsError Report Viewer and Mysql: Visual Studio Enterprise 2017
In this case did not appear in the Report Viewer list the Mysql database after I was able to install Mysql to Visual Studio 1.27 in the case at the end of the table connection process with the…
-
0
votes1
answer82
viewsCompare different value, value "null" does not enter the resutaldo
I have a table of files, and in it there is a field called "document type", which is filled with 1 or when it is not filled is NULL, the problem is that when I give a SELECT and use the comparator…