Questions tagged as 'sql'

Tagged questions
1
answer

Sql. table, date and time organized

I have a sql table that will contain appointment, date and time. I keep all three based on ID. I have a question regarding date and time. id = 0; data 28/08/2018 - 13:11h id = 1; data 26/08/2018 - 17:10h id = 2; data 25/08/2018 - 11:15h I...
asked by 25.08.2018 / 02:29
3
answers

Oracle - Select distinct in just one column

I have a table: student1 - given1 student1 - die2 student2 - given1 student2 - die2 And I want my query to return: student1 - given1 (recent + date) student2 - given2 (recent + date) How do I give a student distinct only with the mos...
asked by 21.08.2018 / 17:44
1
answer

SQL Nested Doubt

I'm using this SELECT , but now I need to search the customer table for the fields (eg cli_clifone and cli_clicontato ), how can I include it to bring this information to SELECT below, I'm trying however only returns me error:...
asked by 23.08.2018 / 20:54
0
answers

problems with REPLACE in decimal field in MySQL with Python3

In Python 2 I used the SQL query of the following form SELECT REPLACE(SUM(valor), '.', ',') FROM pedidos and the result was thus 1790394.95 But in Python3 I run the same query and the result comes like b'1790394,95 ' I'm using Python3...
asked by 16.08.2018 / 21:19
0
answers

Variable error with assigned array

I'm making a map that shows information, located in a database, through bookmarks. So far, I can only show the last data in the database. What should I do to resolve this problem? PS: This is done in PHP and JS. BODY echo' <script>...
asked by 14.08.2018 / 17:36
0
answers

Upload client account system on the server, php, mysql

I'm trying to upload an application with php and mysql on my hostgator server but I'm not getting it, it works perfectly locally, I thought the only changes I should make were $config['base_url'] = 'dominio.com.br'; And...
asked by 14.08.2018 / 19:48
1
answer

How many tables will be needed in MySQL?

I'm starting a project that aims to manage student grade and grade. The information I need to store is: Total subjects (All subjects that the student will need to study) Matters in force (Matters released for the semester, ex 7) Notes...
asked by 14.08.2018 / 05:28
0
answers

Problems with Inner Join in Dapper

I have the following problem when I inner join in 3 in> Dapper does not bring me all the columns of the 3 tables, but only the parent table of my inner join (ie the first table in the query). My classes public class ItemQuesti...
asked by 11.08.2018 / 01:16
2
answers

MySQL, PHP and HTML communication

Good night everyone, I already talked about this, but it seems that they are not understanding what I mean, so I'll see if I explain better: so far as I know, I did everything right, in my case I'm using XAMP, I have a mysql command, and I want...
asked by 12.08.2018 / 23:56
1
answer

Power BI - Oracle SQL Query

Hello, I'm trying to get data in Power BI via Query in an Oracle DB and is experiencing the following error. Unable to establish connection Details: "Oracle: ORA-01843: not a valid month" SELECT DISTINCT J.JOBID, J.JOBNAME, --J.FOLDER...
asked by 05.08.2018 / 20:22