Questions tagged as 'mysql'

Tagged questions
1
answer

Select for Meeting Room Scheduling Mysql

The problem follows: I am creating a system for meeting room scheduling. I would like to ensure that it will not be possible to schedule the same room in the same period. So after completing the inclusion form in the table it will check if the t...
asked by 08.11.2017 / 14:19
1
answer

HELP - I can not identify error - PHP and SQL

Hello,  I am trying to bring in a table the grouping of all steps and item evaluation per year along with the average of the scores and weights. I can only bring the last step and item p table, that is, it is not doing the grouping, although...
asked by 08.11.2017 / 15:03
2
answers

Project Laravel works in mysql but the error in the migration when using postgres

I have a project that I started in mysql, I created some migration and I put relationships inside them, whenever I needed to make changes, delete the database and run the migrate again, with mysql always worked. I need to change the database f...
asked by 17.11.2017 / 20:37
1
answer

Why my procedure is not being accepted, I am using mysql6.3

create procedure cadastrar_nadador (out nome_v varchar(80),out sexo_v varchar(1),out nascimento_v date,out patrocinio_v varchar(80)) begin insert into nadador(nome,sexo,nascimento,patrocinio) values (nome_v,sexo_v,nascimento_v...
asked by 18.11.2017 / 21:53
2
answers

Result of mysqli_fetch array different than the one executed in phpmyadmin

I have the following php code that does a query to the database and returns a vector with the data. public function executeSelect($query){ $resultado_id = mysqli_query($this->objetoConexao, $query); if($resultado_...
asked by 07.11.2017 / 20:44
1
answer

Subquery returns more than 1 row MySql

Follow the code below that is causing the error quoted in the title: select (select id from message where user_from = tempMsg.user OR user_to = tempMsg.user) as id from tempMsg How can I solve it? Could someone help me fast?     
asked by 07.11.2017 / 01:19
0
answers

Foreign key does not work! MYSQL

Good afternoon guys, could anyone help me? My foreign key is not working in a database. I had already done a foreign key in another database the same way, but now it is not working for no apparent reason. I already changed the engine to INNODB,...
asked by 08.11.2017 / 18:48
0
answers

MySQL DUMP with large base mto (BLOBs)

I need to make a DUMP from a giant base, it has more than 500,000 PDFs loaded into it in a BLOB field. > Is it possible to do a DUMP from such a database and restore it without any problems? If yes, how? Do you have any details? I tri...
asked by 08.11.2017 / 19:33
1
answer

Case MySql returning blob type

I created a MySQL search query using case inside it. The problem is that when returning the value of the column that is of integer type, the value comes with the response blob . Here is the SELECT with the result of the query bel...
asked by 29.11.2017 / 13:26
1
answer

Select Group with PHP

I'm trying to feed a select group with bank data, but it's not working. Can anyone see the error? <div class="form-group"> <select class="" name="agencia" tabindex="-1" style="height: 30px;" required="">...
asked by 31.10.2017 / 13:26