Questions tagged as 'sql'

Tagged questions
0
answers

xp_cmdshell how to put folders that have space?

I put a folder in the terminal exec xp_cmdshell 'dir b:\teste\*xlsx*' exec xp_cmdshell 'dir b:\teste teste\*xlsx*' When I add space it does not find. It is not possible to change the name of all folders that have space because there are sev...
asked by 16.05.2018 / 17:41
1
answer

MariaDB returns null with between dates

Has anyone ever had this problem after I updated MariaDB, it seems that it ignores the between ... On my server these schemas returns null do not know why. Has this ever happened to anyone there? The version of my mariadb is 10.2.14     
asked by 16.05.2018 / 01:35
0
answers

Populate multiple select with SQL data

I was able to save a select multiple in the database, however, I can not bring it back to make the data edit page. At save time I used implode . When you have only one record saved, it returns right in select multiple = appears s...
asked by 20.05.2018 / 22:47
2
answers

SQL - group by, count

Good afternoon, I currently have the following code and result. Instead of having this result, I would rather have only one line for each type (column 1), this line being the one whose column 4 has the highest value. If anyone can help (I'm a be...
asked by 20.05.2018 / 14:56
1
answer

Filtering results in PostgreSQL from the lowest value of only one column

It's a matter of logic and knowledge of PostgreSQL features. I have the following query result: I need to do a filtering, grouping by [hour] so that only the closest [real_time] remains, and consequently the whole corresponding line (I...
asked by 15.05.2018 / 14:51
0
answers

Location search box in App Inventor

Hello people, help me, I'm doing an uber-style app in the inventor app as a college work, but I stopped at the following question, I'm using AppInventor and showing the map using the web method and using google APi, but I can only show my loc...
asked by 14.05.2018 / 01:13
1
answer

Query in SQL query with Group by and Order by

Good afternoon, everyone! I have a sql query that is simple but I'm having a hard time performing an order by two fields at the same time. Such a query is for me to assemble a report, but before assembling I need to validate this query. The q...
asked by 13.05.2018 / 19:27
0
answers

search system that searches in two different tables!

I created a search engine. $search = Fnc::_GET('q'); if($search != null){ $results = Select::baseData("users.name,users.user,posts.title", "users INNER JOIN posts ON users.user = posts.user", "WHERE users.name LIKE :NAME OR users.us...
asked by 19.05.2018 / 19:04
1
answer

group records with the same value as a column

I have a table called stores , this table has: ..., store_name and store_category, example: nome_loja | loja_categoria -------------------------- loja1 | roupas loja2 | brinquedos loja3 | roupas What I would like to do is to...
asked by 11.05.2018 / 19:37
1
answer

SELECT and INSERT - Inserting only the first data

I wanted you to save the two separate data (from sector and to sector) but it is only saving the first two Insertion script (html): <div class="form-group"> <label for="de_setor" class="w3-text-black">Do setor de:</l...
asked by 11.05.2018 / 18:57