Best answeres tagged with mysql

4

answers

How to save form image directory to bank

In the system I'm developing it has a form with a field where the user can attach an image. After saving the form, the user wants to view the record including the image, so I thought about saving the image to a folder on the system and its di...

asked by 16.08.2018 / 15:50

3

answers

Select with like detailed

How to perform a select considering that there may not be an exact comparison in the database. I know there is LIKE , but I've already tried and did not have the desired effect. The problem is next, I have to search the bank for a name...

asked by 31.01.2018 / 17:41

2

answers

How to make MySQL accept a number of type 1.457,40?

I'm developing an application that needs to automatically export excel spreadsheets to the database. I'm using MySQL, but the spreadsheet data is not all well formatted the way the bank accepts it. I have already set as utf8_general_ci...

asked by 06.03.2018 / 14:18

2

answers

Make 3 simultaneous searches on the same table

I would like to know if it is possible to perform 3 simultaneous searches on the same table. The situation is as follows: I have a table that contains the columns: Car, Material, IP, date Then I have to search: 1 - Quantos carros foram c...

asked by 20.03.2015 / 22:51

2

answers

How can I select a range of items, after some values using SQL IN operator

For example: I want to search, 1,2,5,7,11 and then the rest until 100, in a DQL SELECT. Ex.: SELECT column_name(s) FROM table_name WHERE column_name IN (1,2,5,7,11 ... value100); In case my doubt is regarding the use of the IN operator, i...

asked by 24.05.2018 / 20:15

3

answers

How do I know if the query in the database was successful?

I have a database with people's records, the name of my db and Registration and in it I have a table users > with four columns already filled id, age, name and email I am developing a user search system here is the search page...

asked by 05.06.2016 / 17:12

4

answers

Problems formatting the date type returned from select

Good morning I would like you to help me with a small problem that I am trying to return from a select in php. I would like the return of my "Mes_Ref", from my select to be only month and year without the day and year being reduced. example this...

asked by 04.05.2016 / 16:51

3

answers

How to consult and return all the information about a product?

I have the following problem and will ask a question in a didactic way so that it can be useful to all the users that may need it. I want to make a SQL query that meets all the requirements and returns the values. The tbl_cor in thi...

asked by 26.11.2014 / 11:49

2

answers

How can I differentiate a 'NULL' string from a null fact value?

I made this example for you to understand how the query is done in the bank on my system. $sql = "SELECT * FROM tabela"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) {...

asked by 23.10.2017 / 14:57

2

answers

Make selection from the results obtained from the same

Good afternoon, I have the following table .. *eventos* ---------------------------------------- | id_evento | id_projeto | nome_evento | ---------------------------------------- I need to do a procedure as follows: "Select events w...

asked by 23.10.2017 / 22:38

Questions tagged as 'mysql'