Questions tagged as 'sql'

Tagged questions
1
answer

Importing a very large .sql file

I have a file with about 192.2 MB in size. I tried importing it through PHPMyAdmin but it complains that the file is too big. I searched the internet for a possible solution to the case, and saw that it has to be through the "source" example:...
asked by 11.11.2015 / 15:17
1
answer

Query Result with SET STATISTICS

I wanted to know if I could get the "SET STATISTICS TIME ON" result. For example, the result of my query gave 1139ms. Can I get this result and manipulate it? Convert to seconds, minutes, write to a table ...     
asked by 17.03.2016 / 14:41
2
answers

If an int variable does not receive anything from the select it is zero or not

Let's say I have this block: declare @teste int declare teste_cur cursor for select campo1 from tabela ..... while @@fetch_status = 0 begin set @teste = 0 select @teste = campo1 from tabela where campo2 = condicao2 end ..... If the sele...
asked by 25.04.2017 / 13:18
2
answers

Compare Salary among Arrays ()

I have the following Query: SELECT * FROM folhapagamento_storages WHERE idFolhaParametro = '1' AND valor_min >= '1083.4' AND valor_max <= '1083.4' Only the return will always be 0, what would you be doing wrong? What would be the corr...
asked by 05.10.2015 / 18:25
1
answer

Encryption AES128 / 256 C # .net E SQL 2008/2012

Greetings, Does anyone know of any implementation of AES encryption compatible between C # and SQL? I want to encrypt in C # and decrypt in SQL.     
asked by 29.09.2015 / 19:04
2
answers

Search without returning PDO data

My variable is being passed but in the filter process it is not always returning anything. try { $keyword = trim($_GET["keyword"]); if (!empty($keyword)) { $sql = "SELECT * FROM noticias WHERE titulo LIKE :keyword...
asked by 07.10.2015 / 22:14
1
answer

Update with Select

I'm new to the forum and SQL. I use the MySQL Workbench DBMS to try to learn the syntax. Querying a site of tutorial, I was to carry out an update using a select, follows command line: update actor set salario = salario * 1.1 where salario = (...
asked by 20.01.2016 / 18:30
1
answer

How to complement these queries to get the buyer's data in the bank?

I made these queries below to get the data from the buyer's database and the products he bought. With the first query, I took the ID of the requests and with these IDS I made a new foreach that took the products that each ID acquire...
asked by 22.01.2016 / 11:52
3
answers

Relationship of tables

Good Night, I have a database with several tables and I need to do a query relationship 4 tables CREATE TABLE IF NOT EXISTS 'cad_cliente' ( 'id_cliente' smallint(5) unsigned NOT NULL, 'nome_cliente' varchar(45) NOT NULL, 'nom...
asked by 06.07.2015 / 23:00
1
answer

What kind of conversion does the precompiler of a DBMS with the SQL language?

The precompiler of a DBMS treats commands written in SQL. Assuming I'm using MySQL. What would be done with the command:    select * from client; What kind of conversion does the precompiler of a DBMS with the SQL language?     
asked by 02.11.2015 / 02:02