Questions tagged as 'mysql'

Tagged questions
0
answers

PHP - Login external sites

I am trying to create a script that connects to an external site (I have the necessary login data in MYSQL database). I would like to know how I can login and fill out a form on a specific page of that site. Example: www.omeusite.com...
asked by 28.06.2016 / 16:41
0
answers

How to add a value in an empty field in MySQL?

I'm running a query that needs to get the first 5 lines with limit 5 . However, there are times when they will return less than 5 lines. The value is empty, neither NULL , nor 0 . I try to make a case when , b...
asked by 29.06.2016 / 17:26
1
answer

back up mysql through the data folder

How do I backup mysql through the data folder? I want to make a back up by the folder date, because banks are great if done via dump it took a long time to download to go up again besides a big chance of error.     
asked by 29.06.2016 / 07:26
0
answers

Button in javascript execute action in php

Hello. I have a question: / I'm doing an anime site, posting and etc., at first I thought I could do everything in javascript, however, I now had to use php to access the Database and etc. Problem I have a button that when clicked should...
asked by 31.07.2016 / 17:15
1
answer

How to do sum and count in MySQL?

I have query that brings up the number of rows of a given fault. select falhas, count(falhas) from tabela where semana = 'semana-5' group by falhas order by count(falhas) desc; The result has the following values:...
asked by 29.06.2016 / 20:31
1
answer

How can I make a select by date and time

Well, what I initially intend is to do a while while showing me all the results of my column reservations. However I want to make a select that shows me the closest days and then the closest hours. The name of my days column is "dialevant" an...
asked by 07.07.2016 / 06:25
1
answer

PHP and MySQL - Placing textboxes in div

I am trying a reverse engineering with PHP, Javascript and MySQL query. I am creating a form for editing events registered in a database table. In one of the fields, called the Presence List, here's how it brings the value of the presence lis...
asked by 20.06.2016 / 18:03
1
answer

Working with AES_ENCRYPT and AES_DECRYPT [closed]

I'm having trouble encrypting and decrypting data. I used the following insert directly in mysql insert into interditado (usuario_id, nome, data_cadastro) values (1, AES_ENCRYPT('Zé da Silva','MIICeQIBADANBgkqhkiG9w0BAQEFAASC') , sysdate());...
asked by 15.07.2016 / 22:23
1
answer

What is the error in the last row of UPDATE usage in the MySQL language?

I developed a final project without error, done in Java, but I still only have a UPDATE error in the last line of the database creation clientes of the database in the MySQL language. I am asking to update the data. public void a...
asked by 20.06.2016 / 18:16
2
answers

Model Relational database with SKU

I am creating a system for selling products and I need these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of this database and I would like to know if this model...
asked by 10.07.2016 / 23:18