Questions tagged as 'sql'

Tagged questions
1
answer

Advantages and disadvantages of SQLite [closed]

   SQLite is a powerful API for working with structured data, but it requires a lot of effort from the programmer to use it. According to Developer (2018), the programmer faces the famous "boilerplate code", that is, the programmer must implemen...
asked by 14.10.2018 / 04:11
2
answers

Problem accentuation PHP and MySQL [duplicate]

I have a question regarding accentuation, specifically the return of% with%. My bank has collation Ç , I'm using HTML tags: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html lang="pt-BR"> <head>...
asked by 07.12.2015 / 13:09
1
answer

Query SQL query

I need to make a MySQL query in the following situation: I have two ads and likes tables; when a user likes an ad, a record is created in the likes table with the user id and ad id Enjoyed it. You need to capture the most tanned ads. S...
asked by 13.01.2016 / 19:17
1
answer

Querys MYSQL PERTENCE

I need to make a query in mysql , within the WHERE I need that is containing COD_IDENT within a group. That is: COD_IDENT 5 6 7 My query must return all results where COD_IDENT is equal to 5,6,7...
asked by 05.02.2016 / 18:32
1
answer

Setar auto-increment in DBeaver

After creating the idpagamentoCielo column as the primary key, I was not able to add the auto-increment property to the column. How can I assign the auto-increment property to the idpagamentoCielo column? Note:...
asked by 04.09.2018 / 14:55
1
answer

List and Count Rows of a Table in MySQL

I'm trying to make a listing of users who logged in and at the same time a count of how many times each user logged, from logins records in a table, I do not know how to explain very well, MySQL table (logins): Nome | Hora_de_Login ---------...
asked by 01.03.2018 / 21:24
1
answer

C # - Pass only numbers in a currency formatted field

I have an application that shows me in a textbox the value of a course enrollment: string mensalidade = string.Format("{0:C}", Convert.ToDouble(leitura["Mensalidade"])); cursoSelecionado.Mensalidade = mensalidade; tb_Mensalidade.Text = Convert...
asked by 13.03.2018 / 23:16
1
answer

Non-repetition of SQL SERVER code

I have the following code in sql server. I need to make it in the first if it exits and execute the same statement that is inside the else tag so as not to repeat the code it has in there. How do I do this? DECLARE @AG_NUM varchar(15) DECLARE...
asked by 02.04.2018 / 14:45
2
answers

IF / ELSE in SQL (Control Structures) [closed]

Okay, I'm reading some articles on SQL control structures, but I'm not getting a lot out of it, could anyone explain how it works in a summarized way?     
asked by 07.06.2018 / 01:40
1
answer

How to insert data (cadastre) in SQLite?

Hello, my connection to SQLite is as follows: Connection connection = null; try { // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:database.db"); S...
asked by 30.05.2018 / 05:36