Questions tagged as 'sql'

Tagged questions
0
answers

Show information that is not in another table

I am trying to bring data that is not found in another table with codeigniter My model: public function getEntradas($proveedor){ //Mostrar entradas del proveedor que no estan en pagos $this->db->select('...
asked by 10.05.2018 / 02:24
0
answers

Filter date range and send data by means of drop-down list

I have the following code PHP and HTML I want to filter by dates first and then send data by means of a drop-down list. but when I run it, it shows me the following error:    syntax error, unexpected '==' (T_IS_EQUAL) in C: \ Ap...
asked by 14.05.2018 / 21:39
0
answers

Problem sql show data

I have the following sql where I show depending on the company what is causing me a problem that contractors technicians bring me SELECT e.idtickets, e.empresa, e.status, e.tipo_ticket, e.cierre_ticket, t.idtickets, t.asi...
asked by 14.05.2018 / 23:44
1
answer

Division in postgreSQL shows incorrect result

I have the query that returns the value of an index that is the result of an operation between two columns, the result I want in decimals and shows it that way, what happens is that the result is not correct: here I leave my query: SELECT dep....
asked by 09.05.2018 / 17:01
0
answers

Structure of the sepomex table

I am downloading the SEPOMEX database to use it in one of my applications, the question is that they ask me to break down the structure of that database. In my first image I show the fields that I am going to take from the database (highlighte...
asked by 09.05.2018 / 17:28
2
answers

Problems in a query with related tables

I am not an expert in SQL and I have the following problem ... I have two "related" tables, one of products and another of product characteristics in which I keep values that these products can have, for example: colors, materials , sizes, etc ....
asked by 08.05.2018 / 10:54
0
answers

Sub SQL selections

I have to separate and group the results of a query by year and by location. Both sources of information are in the same table. If I use group by per year it combines all the locations, likewise the inverse one. I imagine that the solutio...
asked by 09.05.2018 / 23:51
1
answer

Sql filter query

In the following query, the user has several filtering options, you can filter by name, title, area, headquarters the problem is that the name field is not filtering , nothing is returning instead with the other filters if you return results...
asked by 14.05.2018 / 04:47
0
answers

Error importing database into phpmyadmin error code # 1064

Good afternoon folks, I have a problem trying to import a sql database into phpmyadmin, I'm getting the following error. SQL query:    $$$$       MySQL has said:    #1064 - You have an error in your SQL syntax; check the manual that co...
asked by 14.05.2018 / 00:49
2
answers

REGEXP_REPLACE SQL / ORACLE

Good I am trying to replace certain characters of a string belonging to a field in my database. 352-6325632 Serially Replaced (352) -632-5632 when using the regexp_replace function of oracle the second parameter is always equal to the expected o...
asked by 21.05.2018 / 18:22