Questions tagged as 'mysql'

Tagged questions
2
answers

JSON invalidated when it comes to query php mysql, but it works when it is called json format

After reading hundreds of similar problems and unable to find the solution to the problem, I ask the following. I have a php file where the data is listed by datatables , which come by ajax from another php file. The problem is that when I w...
asked by 04.01.2019 / 04:32
1
answer

Sort and replace positions in bd mysql

I have a table with these values Juan 5 Pedro 7 Luis 6 I want to replace the consecutive numbers that are listed from least to largest starting from number 1 ie a php script that detects that the table does not have the number 1 the...
asked by 05.04.2017 / 13:29
1
answer

How to compare a query with 2 variables at the same time in a table of the BD?

I have an elaborated application, everything works excellent, I only have one detail: I need that when making a query (The plate of a vehicle) it is compared at the same time with 2 variables of a table in the BD (plate_1 and plate_2) How can I...
asked by 10.04.2016 / 22:58
1
answer

Is Caul the syntax for defining foreign key constraints in MySQL?

What in SQL SERVER is constraint fk_name foreign key references tabla(campo)     
asked by 28.12.2018 / 20:29
0
answers

# 1305 - FUNCTION ANY_VALUE does not exist

I am replicating a linux server database on my laptop, but in the queries it occurs an error that #1305 - FUNCTION ANY_VALUE does not exist whose query I did myself in servidor linux which runs without problems, I just installed th...
asked by 28.12.2018 / 23:19
0
answers

Doubt MySQL INT, SMALLINT, etc

What is the difference between int(255) and int(100) In other words, the number within the parentheses changes     
asked by 27.12.2018 / 23:34
0
answers

how to edit an event with eventdrop from fullcalendar and ajax?

I am creating an application and I need to be able to move the events of the fullcalendar and edit them, the code to edit it and it works, the problem is that when moving events and canceling them, you save the id of the canceled events and edit...
asked by 26.12.2018 / 14:20
0
answers

Conceptual database schema [closed]

My problem is this: I am designing a BD for an application that manages the soccer tournaments of an institution The problem is that I must comply with the following: Match results record You must allow the administrator to indicate wh...
asked by 25.12.2018 / 22:22
1
answer

Error: The module has not been deployed

I am reading this book about Java Swing and JEE, and I'm in chapter 9, in which you start to create a java web project, a database with a phone table, and the entity and session bean of telephone next to a .jsp simple form that uses a servlet...
asked by 27.04.2016 / 19:19
3
answers

CONSULTATION JOINING VARIOUS COLUMNS

I have a table with 5 columns ... I search the database through the following line where $ search contains the search criteria that I want to make. $sql=("SELECT * FROM bdfo WHERE piso LIKE '%$buscar%' OR sala LIKE '%$buscar%' OR fil...
asked by 20.12.2018 / 02:04