Questions tagged as 'mysql'

Tagged questions
1
answer

Using MySQL with the R in the RMySQL package

I'm new to MySQL and I installed this program to use with R. I was able to install the RMySQL library, following the tutorials I found on the internet and the course I'm doing at Coursera as link and link I even tried to install an...
asked by 02.06.2017 / 21:18
1
answer

DataSet does not recognize LIKE and search parameters

Good evening. I have a table in the MySql database and I am using a DataSet to handle it in my Windows Form project. The problem is that when I try to use a query with LIKE, it does not recognize the parameter I'm requesting. SELECT nome FROM...
asked by 30.05.2017 / 01:02
2
answers

Adding value with Mysql

How do I add the values of the three selects below: ( SELECT (valor1 + valor2 + valor3) AS total SELECT SUM(valor) AS valor1 FROM pagamentos WHERE pagamentos.cliente = '1' AND contratosid = '9289' AN...
asked by 28.12.2016 / 14:58
2
answers

MySQL Workbench Error "Unknown File Encoding"

I have a problem, I backed up my database, however when I load script into MySQL Workbench , I get a message saying: "Unknown File Encoding" IfIchooseutf8Igetthismessage: I can only open if I choose latin1 , bu...
asked by 26.06.2016 / 09:48
1
answer

Entity Framework: Data Model with column with the largest possible number of characters

I'm creating tables with Entity Framework , and I'm using Data Annotation to determine the amount of characters, I wanted to know what the largest size supported for typing text and if the correct type would be string same?...
asked by 18.01.2017 / 22:48
1
answer

Cache on server

I have a system that holds more than 2000 clients and it keeps growing, and every time they do a search, they call mysql with more than 20,000 items (and that number also keeps increasing), would it be possible for me to have one cache or do som...
asked by 10.02.2016 / 13:16
1
answer

My database is changing the surname by the registered name and the email does not appear

File that writes: <html> <head> <meta charset="utf-8"> <title>cadastrando...</title> </head> <body> <?php $host = "localhost"; $user = "root"; $pass = ""; $banco = "cadastro"; $conexao=@mysql_connec...
asked by 05.10.2015 / 20:56
1
answer

Doubts about Select

Hello, I'm doing a user / password check in java and I need to perform a query that checks the database for a login and a password for the type in jTextFields . But I can not get anyone to help me, I'm grateful, to help get a sense of what...
asked by 05.10.2015 / 17:10
1
answer

Display exclude link only if there are no child categories

I have a database with the following columns: |id|id_pai|nome_categoria| +--+------+--------------+ |01| 0 | Eletronicos | |--+------+--------------+ |02| 01 | Notebook | |--+------+--------------+ |03| 0 | Livros | +--+----...
asked by 24.02.2016 / 15:09
1
answer

Update and increment column by sorting (UPDATE and ORDER BY)

I have the following table ID | NOME | ANO | REGISTO ---------------------------------- 0 A 2015 4 1 B 2017 6 2 C 2014 15 3 D 2017 2 4 E 20...
asked by 20.03.2017 / 18:14