Questions tagged as 'mysql'

Tagged questions
0
answers

Counter using update in WordPress

I'm trying to create a counter, but the code is not incrementing one more, could you help me? $wpdb->update('QuantidadeTestes', array('QtdTeste' => QtdTeste+1), array('idUsuario' => $user_info->ID), array('%s'),array('%d'));     
asked by 03.11.2017 / 16:55
0
answers

SQL execution error PHPMyAdmin

I am trying to include records by PHPMyAdmin, but it is returning a strange error, as follows:    Error   # 1054 - Unknown column 'Fâ € ™' in 'field list' Query: INSERT INTO 'pe_orclinhas' ('id_orclinha', 'grupo', 'orcgrupo', 'bandeira'...
asked by 14.10.2017 / 17:32
0
answers

How to put an attribute as foreign and primary key at the same time?

I use MySQL Workbench and I have to represent a DER in the physical model. I come across a specialization: TABELA_PESSOA cpf* nome sexo TABELA_CLIENTE cpf_pessoa* email...
asked by 21.10.2017 / 20:40
2
answers

Code 1215 in SQL "Can not add foreign key constraint"

When creating this code always comes the error:    1215 "Can not add foreign key constraint" I have tried everything, checked the foreign key constraints and nothing. Can someone help me? create table alunodisc ( codigodisc int,...
asked by 22.10.2017 / 13:29
0
answers

Zeos Query freezing program

I have a system that makes remote connection to a server with MySQL on the Web using Zeos, in some cases, where the connection wont oscillate, at the time of running Open in a query, the system freezes, does not display error and does not...
asked by 05.10.2017 / 20:15
0
answers

Trigger formatting date

create trigger tr_Fmt_Data before insert on Tempos for each row set new.Mes = date_format(new.Datas, "%M"); insert into Tempos (Datas) values("2017-10-03"); Would it be possible to help me complete the above trigger? I want to format the date...
asked by 04.10.2017 / 17:33
1
answer

select unique name in the mysql table

I have a mysql table that contains a column called Name and contains the following values: | name Aline Alice Aline | Valdemord | Aline and another column named ID containing it 1 | 1 | 2 | 2 | 3 | 3 | In this case, I would like to s...
asked by 30.10.2017 / 09:59
0
answers

Upload path with variable

I'm trying to use a "mutable" upload path. I made a bidding system, that with each new bid, a folder with the name of the same one will be created where the related files will be uploaded using mkdir (); but now I do not know how to send the fil...
asked by 02.10.2017 / 14:12
2
answers

JavaScript error [closed]

Could someone tell me how to do the JOIN to populate the data automatically from the description field. You acknowledge this error Notice: Trying to get property of non-object in C:\xampp\htdocs\PhpProject1\function.php on line 9 {"codigo_pro...
asked by 02.10.2017 / 19:06
0
answers

How to use Eloquent without losing performance (51.39%) in Lumen 5.4?

Developing an API that must handle a high-performance website. By doing a few tests, I noticed that Eloquent usage is lowering the performance of requests in the MySQL database in 51.39% (more than half). The OS is ubuntu 16.04 and the fra...
asked by 12.10.2017 / 15:42