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
answer115
viewsExport Mysql database with foreign keys
My hosting uses phpMyAdmin to manage the bank and does not allow the remote connection because it is a free plan. I need to export my base to the hosting, generated the . sql file with the command…
mysqlasked 7 years, 10 months ago Murilo Souza 247 -
1
votes1
answer413
viewsHow to store multiple checkbox
I am creating a system and how could I store multiple checkbox and inputs in mysql ? I know I can do it this way but only if it goes to a column , in my case are four as could do…
-
1
votes1
answer620
viewsIs it possible to execute multiple queries in a single run?
I needed some data from a database in mysql. However, the data were in different tables, so the most obvious solution was to filter using relational tables, with the respective indexes. But I don’t…
-
1
votes3
answers4806
viewsSplit the database to multiple clients or create one for each?
I am developing an app for business management. It will consume data from a Mysql database through a Web Server. My question is: What strategy to follow to store each customer’s data? Save all data…
-
1
votes2
answers4260
viewsUpdate page after sending the form
Good guys may seem something simple , but I’m not getting , I have an Insert page that works perfectly , after I do the Insert I use the <script> history.go(-2) </script> for back two…
-
1
votes2
answers65
viewsGet records from 3 tables with JOIN
I need to get data from 3 tables in the same SELECT. I just need to get user data from the table users, take the quantity of quotas (column quantity_quotas) that the user has of the table quotas (if…
-
1
votes1
answer164
viewsList posts of friends
I have a database with the following structure: Table users: usuario_id Primária int(11) nome varchar(128) nascimento date Table friendships: id_amizade Primária int(11) id_remenente int(11)…
-
1
votes1
answer970
viewsPerform update and Insert in mysql via Asp classic
Good morning Personal I would like a help half boring can be up to something kind of banal I have a page on Asp connects.Asp as follows <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"% <% dim conn sub…
-
1
votes1
answer1102
viewsHow to pass a controller variable to view?
I need to pass the variable $limit to my view and display it there, how could I do it? public function index() { // .... $this->pagination->initialize($config); $data['pagination'] =…
-
1
votes0
answers42
viewsChanging mysql_result to mysqli
I have a problem in the code that my teacher passed, I would like to change to mysqli, but I couldn’t get the mysql_result. Here’s the code he gave me, if anyone can help me, I’d appreciate it.…
-
1
votes3
answers260
viewsProblem in PHP+Mysql query using LIKE
Good afternoon guys, recently in one of my projects a problem arose and I hope you can help me. To better understand the site is a site of consultations in the area of health, as clinics,…
-
1
votes2
answers305
viewsError in web system authentication
I’m learning together with a tutorial to develop a petshop system and I’m getting the following hibernate error: Hibernate: selectcliente0_.idClient as idClient2_2_, cliente0_.email as email3_2_,…
-
1
votes0
answers23
viewsHibernate Connection
I’m trying to make an application using the Hibernate, but when will I create the file .cfg.xmI don’t recognize the driver of the mysql, even though it’s in my lib the connector of mysql. Someone…
-
1
votes2
answers186
viewsHow do I display total records in a Manytomany relationship when I use HAVING?
I have the tables below: Articles tags article_tag (pivot table with the columns article_id and tag_id) In the query below I can recover the articles that have the two tags (with id 1 and 3). In the…
-
1
votes1
answer1924
viewsPHP Mysql: Comparing Data Between Two Tables
I have the following tables draw and games in a particular Mysql database. In the draw table, are stored the data of the contest number, drawn 1st decade, 2nd, 3rd, 4th and 5th decade. draw table…
-
1
votes1
answer189
views -
1
votes2
answers42
viewsproblems with HTML and PHP + Mysql
I am learning the ninja arts of PHP and my code is giving a little headache. <div class="container"> <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12"> <section class="painel…
-
1
votes2
answers377
viewsHow to find the second largest number
I need to search the photo with the second highest salary <?php $host = "localhost"; $username = "root"; $password = ""; $db = "imagem"; mysql_connect($host,$username,$password) or…
-
1
votes1
answer208
viewsMultiple ADD INDEX together or separately?
I wanted to know the practical difference between this, in Mysql: ALTER TABLE `tabela` ADD INDEX `col1` (`col1`); ALTER TABLE `tabela` ADD INDEX `col2` (`col2`); For this: ALTER TABLE `tabela` ADD…
-
1
votes3
answers1439
viewsWhile inside another While (PHP - SQL)
I searched the forum and the internet, but I could not solve the problem yet! I am making a query in the database by PHP and searching users. After I look for the users I look for his academic…
-
1
votes1
answer385
viewsSelect with subquery turning into column
Well, I didn’t know how to put the title... Anyway, I have the table tblnotadiscipline (follows picture) which will store student grades for a certain period. These grades have a kind of evaluation…
mysqlasked 7 years, 9 months ago Josivan Sousa 61 -
1
votes1
answer286
viewsHow to print a string array on the screen?
How do I print this SQL query on the screen in string form? $current_user = wp_get_current_user(); $resultado = $wpdb->get_results( "SELECT meta_value FROM $wpdb->usermeta WHERE user_id =…
-
1
votes1
answer80
viewsHow to change table records in the Database after 30 days?
How do I create in PHP a condition that changes the record of a field in a column in the database every 30 days? Example: if ( $valor == 'value_1'){ // Função que altera o registro } value_2 //…
-
1
votes2
answers166
viewsCount IF Mysql Workbench
i have a table that has an ID field. ID 1234 1234 1235 1235 1235 1236 And I would like to get via query the following result: ID ID_Counter 1234 2 1234 2 1235 3 1235 3 1235 3 1236 1 Where in the…
-
1
votes0
answers53
viewsConnect Java to Access (.accdb)
I’m trying to connect a desktop application that uses Java to a server. First I tried to use Acess, but I had problem with drivers, I tried to use Ucanaccess and more problems, anyway, I gave up, I…
-
1
votes1
answer99
viewsMysqli Prepare with Loop for Select
I’m trying to make a SELECT using MySQLi and PREPARE in a FOR but not working. Always returning a single zero. Application Code: if( $teste = $mysqli->prepare("SELECT COUNT(*) AS TOTAL_CONTATOS,…
-
1
votes1
answer945
viewsHow to get an element id that has just been inserted - JAVA
How do I catch one id of an element that has just been inserted into Database in Java? Something like: mysql_insert_id() in the PHP.
-
1
votes1
answer45
viewsMysql - List results from 2 tables
I have two tables with the same field and I need to make a SELECT with two conditions, I’m trying this code but is listing 2 times the result only from the first table (entrada), nothing from the…
-
1
votes1
answer77
viewsMysql - How to get the table name where the result came from?
I have the following mysql code: (SELECT * FROM entrada WHERE idUsuario = "1") UNION (SELECT * FROM saida WHERE idUsuario = "1") It’s all working but I need to know which of the 2 tables the result…
-
1
votes1
answer159
viewsHow to load an entity State-related Parents
I’m starting out in the Entity Framework and when trying to load a State entity, the related Parent entity is coming with null value, which I could adjust in my code to resolve? State class: public…
-
1
votes0
answers128
viewsHow to check new fields entered into a mysql table in real time?
In my work there is a database where a turnstile system inserts new fields in the table and the Nodejs application needs to check when it has new fields inserted. How best to monitor a table in real…
-
1
votes2
answers256
viewsData field update in string format
Guys, I took an old bank from a client where there’s a birth date column that’s in a string format and doesn’t date. So far so good only that it has certain recorded dates that do not have the 0 in…
-
1
votes3
answers245
viewsResolver undifined index
I’m trying to create one table with data from a database mysql, but when I open the page, it shows some results and then above appears this error: Notice: Undefined index: TASK DESCRIPTION in C:…
-
1
votes1
answer52
viewsRetrieve Browser Information in Procedure Mysql
You can pick up browser information on a PROCEDURE via Mysql code? No need to pick up via back-end code and pass as parameter. That is, Mysql has some function that returns information from the…
-
1
votes1
answer37
viewshow to make a message field with formatting buttons
I have something on my mind here and I need the idea of you I want to put a field in my system where I can save student feedbacks, add images and format fonts, this message field that will have a…
-
1
votes0
answers486
viewsApostille Caelum fj21 mysql driver error
Good afternoon, everyone, Starting I am studying the Java WEB workbook from Caelum but the following error is appearing. I already imported the Mysql driver, I switched between the commented line…
-
1
votes0
answers243
viewsHow to update the database when reordering list by sortable
Daew guys, I’m using sortable to reorder a list. How do I make the change in the bank within the function? Follow my code: <?php session_start(); if ($_SESSION['clienteLogado']=="") {…
-
1
votes1
answer1657
viewsProblem with id AUTO_INCREMENT in SQL
I created a table in Mysql Workbench with the following settings: CREATE TABLE teste ( id INT AUTO_INCREMENT, nome VARCHAR(50) NOT NULL, email VARCHAR(40) NOT NULL ); And when I try to insert data…
-
1
votes0
answers537
viewsInsert in mysql database with java
I’m trying to give 6 insert in 6 tables, but I did not succeed that way, someone can help me with a better idea? private void salvarActionPerformed(java.awt.event.ActionEvent evt) { DadosFuncionario…
-
1
votes3
answers227
viewsHyphenate when value is 0 in select
How can I do in the mysql one query (SELECT) so that when the value is equal to 0, replace it with hífen(-). Field of value: int.
-
1
votes1
answer1673
viewsPHP connection problems with Mysql.(Access denied for user)
I am a beginner in the area that refers to programming and computers. I have a problem that I can’t get the solution anywhere. I have a Linux virtual machine with a Mysql server to supply the Zabbix…
-
1
votes1
answer1595
viewsGeneral error: 1449 when fetching Mysql Database records
I am getting the error below while doing SELECT: SELECT * FROM vn_horario_view; SQLSTATE[HY000]: General error: 1449 The user specified as a Finer ('root'@'localhost') does not exist How to resolve…
-
1
votes1
answer88
viewsIs there a way to join 2 queries of different tables in a single query?
I wonder if there is a way to join 2 queries of different tables in a single query? For example, in the code below I have 2 queries in separate tables. However, there is a way to perform these 2…
-
1
votes1
answer983
viewsSQLSTATE[42000]: Syntax error or access Violation
SQL: "SELECT * FROM produto WHERE ($cliente=null OR cliente LIKE '%".$cliente."%') AND ($n_cad=NULL OR n_cad=$n_cad) AND ($cod=NULL OR id=$cod) AND ($dt_inicial=NULL OR data_emissao >=…
-
1
votes1
answer554
viewsJDBC connection in Eclipse Neon
I need help adding the JDBC driver to my project done in the Eclipse Neon version. If possible pass a connection class to test.
-
1
votes3
answers83
viewsDate Doubt in SQL
I’m setting up a database for a video store to learn SQL. My goal is to have a return date of the film. For this, I created the table with a column named "return" to store when the movie will return…
-
1
votes0
answers311
viewsProblem with Widfly
I am having an error starting the library project with Widfly 10. Until the part connecting with the bank was working, agr when connecting with mysql am having problems. I’ve already set up the…
-
1
votes1
answer121
viewsrecover mysql error message with php
Good guys, I know check the error code, but do not know how to recover the error message. Follow my example: $conexao->query($query); $erro = "Errorcode: $conexao->errno"; I want to make the…
-
1
votes2
answers407
viewsHow popular is the list of objects with select(C# and Mysql) results?
string strSQL = "SELECT usuperm.idusuario, usuperm.codfunc, usuperm.perm FROM usuperm INNER JOIN usuarios ON usuarios.idusuario = usuperm.idusuario WHERE usuarios.loginusuario = @loginusuario AND…
-
1
votes0
answers181
viewsWhat alternative to Sql_latin1_general_cp1251_cs_as in Mysql
What would be an alternative, in Mysql, for COLLATION Sql_latin1_general_cp1251_cs_as for Mysql or how to remove the accent from a string (or for any table or column) using commands? Reference:…
mysqlasked 7 years, 8 months ago lucasbento 856