Questions tagged as 'mysql'

1
answer

SQL error on fullcalendar connection

My code is returning false, I have debugged but I do not find the error it returns "There was some problem .." <!DOCTYPE html> <html lang="pt-br"> <head> <meta charset="utf-8"> <meta name="description" conten...
asked by 24.10.2017 / 05:24
1
answer

Error C # and MySql: Authentication with old password no longer supported, use 4.1 style passwords

Context: We have an application built a few years ago in ASP 6 that accesses a MySql database, there in LocalWeb. To make the connection, the application uses the MySQL ODBC 5.1 driver. and works perfectly. Objective:  We are building a ne...
asked by 14.11.2017 / 14:45
1
answer

Failed to register NULL value in database - PHP7

Good night everyone, I'm a beginner and I'm developing a CATEGORY and SUBCATEGORY registration system in PHP7 and MYSQL; The logic I used to register for Categories and Subcategories is: All PAI CATEGORY is null and any subcategory has a v...
asked by 13.11.2017 / 00:13
0
answers

Update within a mysql function

I have to do a process to perform an update on a given field in a table. I created a function in mysql. But within this function would need to perform an update, plus the function does not accept uptade would have any way to perform this proc...
asked by 14.06.2018 / 03:38
0
answers

Error making MySQL connection using .NET. How to solve?

Exception when connecting to bank:   IsPasswordExpired: 'conn.IsPasswordExpired' threw an exception of type 'System.NullReferenceException'       ServerThread: 'conn.ServerThread' threw an exception of type 'System.NullReferenceException'  ...
asked by 16.11.2017 / 15:04
1
answer

Error converting image to String to save to bank

I'm trying to save an image to my form in the database, but I'm having trouble resolving the error:    Field error in object 'user' on field 'photo': rejected value [org.springframework.web.multipart.support.StandardMultipartHttpServletReques...
asked by 11.06.2018 / 17:44
2
answers

Compare a subquery with another subquery

I have two tables, table A and table B, each with a column called text . Both tables have equal records up to a point, up to the character ' = '. What I want to do is SELECT all of the records in table A where the records up to the '=' characte...
asked by 19.11.2017 / 18:13
0
answers

How to execute a SQL statement concatenated with a variable in a Procedure in MySQL

I'm creating a procedure to create a base and some tables within that base. I get the name of the base to be created by parameter. I'm having trouble concatenating this parameter next to the table creation script. Below is the code I did:...
asked by 29.12.2017 / 14:29
0
answers

Sort by deep JSON column

I have a column called data , which has, for example, this JSON    [{"name": "unit", "value": "2", "validator": ["required"]}, {"name": "name", "value": "teste", "validator": ["required"]}] I need to make a SELECT that...
asked by 03.10.2017 / 22:21
2
answers

List Tree Categories in Laravel 5.1

I'm starting with Laravel 5.1 and I'm a bit lost yet. I need to list categories, subcategories and "sub-subcategories". Table: Categorias ------------------------ id | int nome | varchar categoria_pai | int Data:...
asked by 11.08.2015 / 19:53