Questions tagged as 'mysql'

1
answer

It is faster to delete + insert or select + update

I'm building an application that will receive data from several different ERPs every day. But I have the following problem, the next day the ERP can send me the same data that did or did not change + some new data. And I need to insert these...
asked by 14.10.2017 / 09:21
2
answers

Select in MySQL with an array

I have a form with a field multiple select : <form action="processa-chose.php" method="post"> <select id="selecionar" name="fornecedor[]" data-placeholder="Fabricantes" style="width:350px;" multiple...
asked by 25.08.2014 / 15:06
1
answer

How to show the value of the bank on a star rating?

I was able to do the star rating system, but I wanted the vote to be displayed on the screen or saved in the star so that it would be filled according to the votes. Could someone help me, here is my code: This is the page where the stars are:...
asked by 29.08.2015 / 16:46
4
answers

Is it possible to use PHP in a data-title field?

Is it possible to use PHP within a data-title field? I have the following code: <div id="grid" class="m-row shuffle--container shuffle--fluid"> <? $result = $connection -> query("SELECT * FROM portfolio") or die($co...
asked by 11.03.2015 / 14:05
1
answer

How do I change MySQL database insertion order?

I want to insert something into my MySQL (PhpMyAdmin) it inserts and above the last post. Example: Yesterday I inserted Nome: Pedro | Idade: 20 Anos and it was at the top because it was the first one to be inserted into the database...
asked by 27.10.2018 / 15:11
3
answers

What is the difference between a View and a Stored Procedure in SQL? [duplicate]

I have encountered Views in SQL and also with stored procedures. I would like to understand better, what is the difference between a view and a stored procedure and what are its purposes? Would it be possible to provide a practical case for...
asked by 27.08.2018 / 15:46
1
answer

Update with Inner Join

update will affect all fields that satisfy the imposed condition in the inner join or just the first field?     
asked by 18.10.2015 / 12:36
4
answers

How not to write duplicate data in MySQL with PHP? [duplicate]

I'm learning PHP and for starters I'm doing a phone book project, with name, DDD, and phone. However, before the new data is entered, how do I check if the same phone number is already registered?     
asked by 27.03.2014 / 10:17
2
answers

Concurrent transactions in MySQL

I'm working on a system that needs to sort out multiple data (coupons) from one table and return it to the user, but I can not risk delivering the same coupon to the other user. I thought about using GET_LOCK ( ) from MySQL to temporarily l...
asked by 07.02.2014 / 19:20
2
answers

Change Varchar field to Date MySQL

I need to fix a table that was built in the wrong way, the field that would be to store the date was created as varchar . With this structure I can not select a certain period, since varchar are sorted from left to right in...
asked by 23.06.2016 / 17:52