Questions tagged as 'mysql'

Tagged questions
1
answer

How to do an update in two tables that does not return "safe update mode" in MySQL?

I have two table, one of users, and one of validation codes. I do a code check in PHP and need to query the validation table at the same time that I update this table by disabling this code so that it is not validated again, and enable the us...
asked by 18.06.2018 / 05:38
2
answers

Servlet with JSP does not insert into the database

I'm doing my Interdisciplinary College Project and it would be an e-commerce. Well, I was following the part of inserting in the bank for a course book I made for Caelum, but I do not know if something is missing in the book, but at the time of...
asked by 08.11.2018 / 04:54
2
answers

Modeling a friend system database

Hello, I'm developing an application where there will be an option to add friends, it's very simple, it's not social network, but you have to add a friend. I have the user table. Which tables and which relationships do I have to create to add fr...
asked by 10.11.2014 / 18:18
1
answer

Search by date in mysql

Good evening, I have records in my table about phases of the moon 4089 Lua nova 1983-05-12 19:26:41 4090 Primeiro Trimestre 1983-05-19 14:18:16 4091 Lua cheia 1983-05-26 18:48:29 4092 Quarto Minguante...
asked by 24.10.2014 / 02:15
1
answer

Save formatted text in MySQL DB

I am developing a news system and need to save formatted text, with line breaks, images between one paragraph and another and bold / italic etc. It's all working php posting, display and everything. Could someone show me how I can save that way?...
asked by 13.06.2014 / 15:37
1
answer

How to report a variable, associated with a row in a table field, for a template

I am trying to build a list of links that point to a template, where one of the variables, with the contents of one of the fields in the table, must be dynamically informed in the template (being associated with a specific row in the table) p>...
asked by 17.09.2015 / 20:43
1
answer

Optimize insert in MySql table - Java

I have a loop making the sequential insert of millions of rows into a single MySql table. I wonder if it's possible to parallelize the insert or use some feature that increases insert performance. Code: public static java.sql.Connection...
asked by 16.09.2015 / 00:11
1
answer

Issues with accent and Entity Framework

This is an excerpt from my search method at the bank: public dynamic GetAll(Func<TEntity, bool> predicate, int limit, ClassContexto contexto, int idEmpresa) { dynamic data = null; try { data = li...
asked by 11.09.2015 / 03:07
2
answers

How to add 3 columns of different tables

I am developing a financial system. Today we have the following situation: Banks (id, name, initial balance); Recipes (id, geraParcela, qtdeParcelas) Recipes_parcels (id, recipe_id, value, date_wind) Expenses (id, generatesParcela, qtd...
asked by 22.04.2014 / 23:29
1
answer

Update LONGBLOB field possible?

I have a script that uploads images to a table with LONGBLOB field, uploads any image, and displays it without any problems. My question is: even though I know we should not insert images in mysql , is there a way to UPDATE...
asked by 28.04.2014 / 23:30