Questions tagged as 'mysql'

Tagged questions
1
answer

Mysql return JSON

I'm trying to make this example but it's giving the error: # 1582 - Incorrect parameter count in the call to native function 'JSON_OBJECT' SELECT JSON_OBJECT('City', Name, 'Dist', District, 'Pop', Population) FROM City; sql example returni...
asked by 21.02.2018 / 13:01
1
answer

How to print only one sale with your products using jasperReport?

I'm trying to print only the sales you want with jasperSoft reports, only you're printing all the sales and all the products you then added into other sales. jasperSoft report image impress.javaStringrelatorioStream=servlet.getRealPath(thi...
asked by 21.02.2018 / 04:14
1
answer

Date format to save to the Bank

How to make date formatting in php, receive default date (d-m-Y) and save in the bank (Y-m-d). This is the line of code used within input (Y-m_d) value="<?php $date = new DateTime(''); $date->add(new DateInterval('P0D')); echo...
asked by 22.06.2018 / 17:14
1
answer

I can not change the collate of my column in mysql to utf8_general_ci

Good morning, people. I have a problem with changing the collate of a column in my database. An example of how I'm running: ALTER TABLE 'minhaTabela' CHANGE COLUMN 'nome' 'nome' VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci' AFTER...
asked by 16.02.2018 / 16:18
1
answer

Error storing byte in mysql db

I am trying to store what I get in db mysql, but this is giving this error I believe it is type of column error: 26/02/2018 09:25:14 User connected 26/02/2018 09:25:14 Login : Skell 26/02/2018 09:25:14 Error: System.FormatException: Input str...
asked by 26.02.2018 / 13:36
2
answers

Login Problem [duplicate]

I'm trying to create a Basic Login, with verification so it does not have records with same users in the database. But I'm having an error on this line $row = $resulta->fetch_assoc();    Fatal error: Uncaught Error: Call to a me...
asked by 04.04.2018 / 02:25
1
answer

Problem syntax MySql generating by PhpMyAdmin

I have a problem when MyAdmin generates a table creation script. The Script: CREATE TABLE 'crud_ABC'.'cliente_ABC' ( 'id' INT(10) NOT NULL AUTO_INCREMENT , 'nome' VARCHAR(300) NOT NULL , 'valor' DOUBLE(20) NOT NULL , 'descricao' TINYTEXT...
asked by 03.04.2018 / 00:27
2
answers

Select only if the ID is in 2 tables [closed]

I have 2 tables in Mysql, INSCRICAO1 and INSCRICAO2 . Both have a field called COD that receives a user code. A INSCRICAO1 saves the user's personal information INSCRICAO2 stores user's car information I need to select only INSCR...
asked by 03.04.2018 / 22:27
1
answer

Help with protection

Hello, I'm developing a simple thing comments system, I'm using php with ajax, and storing in a MySQL database, my question is as follows, input $MENSAGEM = filter_var($text, FILTER_SANITIZE_STRING, FILTER_FLAG_ENCODE_AMP); How can I avoi...
asked by 04.04.2018 / 04:33
1
answer

Backend with mysql database and frontend in javascript (react-native)

I'm developing an application in javascript (for android) and I would like to use mysql as the database for this application, but I was not able to use mysql in the same code so I did some searches that indicated separating by backend and fronte...
asked by 07.02.2018 / 11:31