Questions tagged as 'mysql'

Tagged questions
1
answer

Add point ('.') after 3rd character

I have a registry with the original product code, however I need to put one. (dot) after the 3rd character. Original code : 2022027 How should it be : 202.2027 The table structure follows: id nome descricao aplicacao i...
asked by 15.04.2016 / 20:00
1
answer

Query MySQL with mixed ORDER BY?

My question is a bit boring to explain but I'll try to make it as simple as possible. I have the following tables in a MySQL database: produto , preco , preco_produto (mapping many to many), venda and itens_venda...
asked by 21.07.2016 / 15:49
1
answer

Error when using EF6 CodeFirst with Mysql

I have the following error when I run Migrations: HowcanIsolveit?Ihaveeverythingproperlyinstalled.Here'smyWeb.Config:<connectionStrings><addname="ProjetoCultContext" providerName="MySql.Data.MySqlClient" connectionString="server=l...
asked by 11.04.2016 / 22:36
1
answer

Doubt group by + sum function

I have a problem putting a query into my mysql database for attendee attendance at an event. I have a participant table where I have participant information, and it has the attendance of those participants on days 1, 2 and 3 (th...
asked by 11.04.2016 / 21:45
1
answer

Difference between texts with several paragraphs in Mysql

I have two fields in the table (text) that receive several lines (paragraphs) of information, for example: CAMPO1 linha1 linha2 linha4 linha5 CAMPO2 linha1 linha2 linha3 linha4 I need to check which line is missing by crossing the informat...
asked by 22.06.2016 / 17:23
1
answer

Execute Query according to RadioButton selected

I have the following form: <?php echo"<fieldset>"; echo"<legend>OPÇÕES</legend>"; $query_menu = mysql_query("SELECT rm_id AS FUNCAO, rm_desc AS DESCRICAO, rm_obs AS OBSERVACAO, rm_status AS STAT...
asked by 22.06.2016 / 16:32
1
answer

Result PDO Search PHP Does not return a field

I make a sql query using PHP PDO. When checking the result of the query, the value of a field returns empty, but the field has value. Using the SQL statement directly in phpMyAdmin the result returns normal with all fields. I've never seen th...
asked by 22.06.2016 / 21:11
1
answer

Java Connection mySQL JDBC

I have a problem following this class video : I seem to follow what he says to do but the line goes red and with errors: con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/videoAulaJDBC", "root", ""); The error that happens are...
asked by 22.06.2016 / 17:03
1
answer

Problem with editing database data

I had already asked a question before because the modal did not multiply with while (already resolved). This was the result: $editar = 0; $sql = mysql_query("SELECT a.n_processo,a.nome,a.data_nasc,a.cc,g.designacao, a.ciclo_formacao,t.t...
asked by 20.04.2016 / 18:55
1
answer

Create PROCEDURE by entering given and checking in 2 tables

I have a question on how to do a PROCEDURE, I created a guide image to explain my doubts. Caption: Yellow table and blue column, linked by line. The property CASA1 has the ID 23 this property has additional options (features) such as...
asked by 13.04.2016 / 16:31