Questions tagged as 'mysql'

Tagged questions
0
answers

Create a Checkbox

My question is the following as I can call from a mysql database in my view in laravel, and filling that data in a list with checkbox so that I can choose the user to whom I want to upload a file of type pdf or doc or txt if you could help me wi...
asked by 25.10.2018 / 17:32
1
answer

Insert and Select in MySQL

I have a small problem with a database ... since what I need is to be able to mix that data. Currently this is my BD However, I need you to stay like this: In theory I must add the MATRIX with (intertidal) and (subtidal) ... th...
asked by 25.10.2018 / 20:09
0
answers

Error Notice: Undefined index: rate in C Bd mysql Php

What happens is I have a variable in javascript called rate, and when I save this variable in the DB I get an error, I do not know why this error is due or how would I save a variable (fix) of javascript in Php? . WITHOUT AJAX. Here is the co...
asked by 25.10.2018 / 18:45
1
answer

MySQL Show all data to the LEFT of a table

I have the following problem. I formulated an SQL query that gives me data of trucks that work during the current week , the problem is that I need to show all the trucks, including those that have not worked during the current week (with data...
asked by 25.10.2018 / 19:47
0
answers

linked server and transactions SQL server to MYSQl

Good morning, the issue is like this, I have two databases sql server and mysql, every time an insert is made (this side of sql server) in a table, these changes must also affect the table in mysql , I have a linked server, I decided to make a t...
asked by 23.10.2018 / 16:02
0
answers

how to include in a table (orders) several records of another table (products)

Hello is my first question on this site, first of all I am new in the world of programming and others, my problem is that I have a table orders and another table products, the problem is that I do not know how they have to be related tables amon...
asked by 23.10.2018 / 16:59
1
answer

Why does the mysql Workbench always throw me an error when I synchronize tables?

With the latest version of mysql workbench, I have only problems. I create two tables, one using an n: n relation, I synchronize it and it always ends with the same message "ERROR: Error 1064: You have an error in your SQL syntax; check the manu...
asked by 24.10.2018 / 04:08
0
answers

FullCalendar does not update automatically when adding an event

Please read the comment in each code. The code of the file that inserts the data is: <?php header('Content-Type: application/json'); $conexion = new PDO ("mysql:host=localhost;dbname=scouts_601_palmira","root",""); if(isset($_GET['id']...
asked by 24.10.2018 / 15:41
1
answer

Why does not UPDATE make me

I am trying to Create a Trigger for MYSQL but it does NOT leave me Insert in table or update (Note: And installed the trigger from Navicat I do NOT know if I have something to do but I do the query to create the triger Success if it leaves me BU...
asked by 22.10.2018 / 23:40
4
answers

Why does the Inspector Character ( ) appear in some data obtained from the Database?

I was dealing with the dilemma of converting the accents and special characters of my system. It happens that now some of the data obtained from the database that have tildes come out with this: . The strange thing is that there can be up...
asked by 31.03.2017 / 12:53