Questions tagged as 'mysql'

Tagged questions
1
answer

Doubt - UPDATE MYSQL with PHP

I need to update to the mysql database but I can not. I'm basically following these steps: I get bank variables that are similar to a particular CPF and display 2 people The user will click a button to select 1 person Once the user...
asked by 26.01.2018 / 16:32
1
answer

Variable type for persistence in MYSQL Longtext

Good morning, In my database MySQL , I have a column of type longText. My question is how to declare the type and annotation of this variable in the java class. In brief research I found the following information: @Blob private String...
asked by 18.01.2018 / 14:14
1
answer

SQL grouping information

I have the following sql statement: SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR' AND TIPO_CAMPANHA = 5 AND DT_CAMPANHA = '01.08.2018' UNION SELECT * FROM TB_CADPRECO WHERE MAT_GESTOR = 123 AND UF_PRODUTO LIKE 'PR'...
asked by 24.01.2018 / 17:47
0
answers

DevExpress XAF Express Framework Framework

Alright? I would like an indication of courses or material on DevEspress's XAF Framework, preferably in Portuguese.     
asked by 17.01.2018 / 18:48
1
answer

SQL Error (1093): You can not specify target table 'import2016' for update in FROM clause

I'm running this PROCEDURE, and it returns this error! BEGIN SET @cont = 0; REPEAT SET @sqlstring = "UPDATE import2016 SET coluna4 = (SELECT coluna4 FROM import2016 AS a WHERE a.coluna2 ='' and a.coluna4 like'%/%' L...
asked by 17.01.2018 / 21:11
4
answers

Using MySQL to create a Select that looks for words "together"

In MySQL how to create a select that looks for words "together". For example: SELECT pessoa FROM tabela WHERE pessoa like '%josedasilva%' But this way it does not return anything. Because it is registered as "José da Silva". I would like y...
asked by 17.01.2018 / 20:13
0
answers

I can not connect to the MySql database

I have a classic ASP application and I can not connect to the database. I set up all the right faces stringConnection = {DRIVER = {MySQL ODBC 5.3.9 ANSI Driver}; SERVER = localhost; DATABASE = asseitsesi.com.br; UID = root; PWD =; Ignore Prep...
asked by 17.01.2018 / 12:41
0
answers

Error starting MariaDB in CentOS7

Good morning. I have a dedicated server running CentOS7 and MariaDB has stopped and I can not restart the service. [root@new ~]# mysqld start 2018-01-17 13:31:10 140236707752192 [Note] mysqld (mysqld 10.1.22-MariaDB) starting as process 19665...
asked by 17.01.2018 / 14:52
0
answers

How to change form according to cookies

I'm working on a betting site, I would like to know how I can do when the bet is placed, change the view of that bet (show as already made the bet and give the link if you want to edit). Remember that it has to be according to the person's login...
asked by 21.01.2018 / 18:29
0
answers

auto_increment command for Id does not work after deleting data and rewriting them

When I create a table with the column "Id int null auto_increment" and enter values in the table, after deleting the values and reinserting them, the Id does not start from 1, and sometimes with a random order. And besides 8 row (s) affected Rec...
asked by 21.01.2018 / 18:14