Questions tagged as 'mysql'

Tagged questions
1
answer

Insert same data into two MySQL columns

Hello! I have a table with the name tabx and two columns y and z, when I will insert the values in the column and I need a trigger to copy this value to the z-column. Have I tried some solutions but unsuccessfully can someone help me?     
asked by 06.01.2017 / 23:15
1
answer

Query with count returning empty

I have the following query: SELECT numero, sistema, status, date_first_queued FROM ocorrencias HAVING DATE(date_first_queued) between DATE_FORMAT(CURDATE() ,'%Y-%m-01') AND CURDATE() AND sistema = '17' It retu...
asked by 28.12.2016 / 15:05
1
answer

Do not want to save form data in ionic POST + PHP + MySQL

It works the way I do in other forms, but this one does not know which error I'm making. I have a "suppliers" table: AforminIonic,normal:<ion-viewview-title="Cadastrar seu Restaurante" hide-nav-bar="false" > <!-- content --&g...
asked by 27.09.2016 / 15:00
2
answers

Problem Code UPDATE MYSQL PHP [closed]

Someone could confirm me if the code below is correct, I'm not good at php or mysql, I only make arrangements and I'm not getting the expected result, the connection with db is correct, it does not show any errors error) ... The expected resu...
asked by 01.10.2016 / 19:25
2
answers

Password renewal system

My question is that I'm trying to do a password reset system. [Current Password] [ New password ] [Change] Good codes below settings.php <?php require_once('assets/system/core.php'); if (isset($_POST['password'])) { $p...
asked by 22.09.2016 / 14:22
1
answer

Select with MD5 password returning empty

I'm using the query below to login, it was working normal with normal passwords, but now I'm migrating to the Md5 password, but this only giving invalid password, I believe it's my select that is with error "SELECT * FROM usuarios WHERE usu_l...
asked by 22.09.2016 / 15:56
1
answer

Problem in creating table in the bank

I put these commands to create the table; CREATE TABLE pessoa ( codigo BIGINT(20) PRIMARY KEY AUTO_INCREMENT, nome VARCHAR(80) NOT NULL, codigo_condominio BIGINT(20) NOT NULL, codigo_proprietario BIGINT(20) NOT NULL, tipoPe...
asked by 18.09.2016 / 17:19
1
answer

Query mysql with results from the last 30 days displaying totals per day

I have a query where I get results from the last few days, I need the results to be shown per day, I used group by , but it still did not work, as you can see below. resultado esperado: 2016-09-15 07:49:45 1 2016-09-14 07:49:45 1...
asked by 15.09.2016 / 15:05
1
answer

Adding mysql columns

Good afternoon, I opened a question yesterday but I could not express myself correctly, I have the following query SELECT C.id, C.name as NomePC, C.serial AS Serial, MF.name AS Fabricante, CM.name AS ModeloPC,OS.name AS Sistema, OSV.name...
asked by 27.07.2017 / 19:29
2
answers

Insert special characters into mysql and pull these identical values in the web application [duplicate]

Good evening, I need to add values to the database by mysql so that they have special characters. I can add, but I can not pull the values correctly, they end up coming with symbols in place of the special characters, for example ... Comput...
asked by 27.07.2017 / 05:09